Auto Optimizer Stats Runs Multiple Jobs During Long Maintenance Windows In 12.2.0.1
(Doc ID 2489114.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Auto Optimizer stats runs multiple jobs during same maintenance windows in 12.2.0.1
CLIENT_NAME WINDOW_NAME JOB_STATUS JOB_START_TIME JOB_DURATION
---------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------ --------------------------------------------------------------------------- ---------------------------------------------------------------------------
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 06.00.03.649452 AM UTC +000 00:00:36
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.04.40.543329 AM UTC +000 00:00:29
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.14.41.618082 AM UTC +000 00:00:13
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.24.43.330328 AM UTC +000 00:00:12
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.34.44.750451 AM UTC +000 00:00:13
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.44.46.202109 AM UTC +000 00:00:19
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 07.54.46.971199 AM UTC +000 00:00:12
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 08.04.48.079796 AM UTC +000 00:00:13
auto optimizer stats collection SUNDAY_WINDOW SUCCEEDED 04-NOV-18 08.14.49.673943 AM UTC +000 00:00:12
...
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |