My Oracle Support Banner

Oracle Text Auto Optimization for STAGE_ITAB is creating a large number of log file (Doc ID 2628587.1)

Last updated on APRIL 27, 2020

Applies to:

Oracle Text - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Customer is running Automatic Optimization for the STAGE_ITAB table and they have noticed that the process is creating a large number of log files that contain this

Oracle Text, 12.1.0.2.0
14-27-08 01/07/20 begin logging
14-27-08 01/07/20 Starting auto-optimize execution
14-27-08 01/07/20 start auto optimize
14-27-08 01/07/20 Obtaining optimize lock in NOWAIT mode
14-27-08 01/07/20 Analyzing Index:XXXXXXXXXXXXXXXXXX
14-27-08 01/07/20 Rows considered for optimize:0
14-27-08 01/07/20 Rows fetched for optimize:0
14-27-08 01/07/20 Optimizing MDATA delta rows
14-27-08 01/07/20 Optimizing terms from start of $G
14-27-08 01/07/20 Optimize Merge:XXXXXXXXXXXXXXXXXXXXXX
14-27-08 01/07/20 optimize merge XXXXXXXXXXXXXXX complete
14-27-08 01/07/20 Obtaining optimize lock in NOWAIT mode
14-27-08 01/07/20 Analyzing Index:XXXXXXXXXXXXXXXX
14-27-08 01/07/20 Rows considered for optimize:0
14-27-08 01/07/20 Rows fetched for optimize:0
14-27-08 01/07/20 Optimizing MDATA delta rows
14-27-08 01/07/20 Optimizing terms from start of $G
14-27-08 01/07/20 Optimize Merge:XXXXXXXXXXXXXXXXXXXXXX
14-27-08 01/07/20 optimize merge XXXXXXXXXXXXXXXXX complete
14-27-08 01/07/20 Auto-Optimize Job complete
14-27-08 01/07/20 log
14-27-08 01/07/20 logging halted

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.