Excessive Archivelogs Generation During Maintenance Window From Large Execution Of "update seq$ ..." Commands
(Doc ID 2721512.1)
Last updated on NOVEMBER 06, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Excessive archive logs are generated during Maintenance Window.
Following symptoms may be seen.
- Job queue process (Jxxx) doing "auto optimizer stats collection" task is showing top activity.
- AWR shows "SQL ordered by Executions" top SQL as:
update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
- Taking event 10046 trace (SQL Trace) on the problematic Jxxx process shows above "update seq$ ... " statement being repeatedly executed.
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