EM 13c: Target DB Optimizer Statistics Gathering Page Hangs
(Doc ID 2819882.1)
Last updated on JULY 20, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.1.0.0 to 13.5.0.1.0 [Release 13c]Information in this document applies to any platform.
Symptoms
In EM 13.4, gathering optimizer statistics page hangs, check the below
Login to EM Console, Targets --> Databases, click on DB target
From DB home page, Administration --> Oracle Scheduler --> Automated Maintenance Tasks then click on Optimizer Statistics Gathering. Page was not responding.
Below gets executed in respective DB target, which is running for long and DB performance got degraded
begin EXECUTE IMMEDIATE 'alter session set NLS_TIMESTAMP_TZ_FORMAT = ''YYYY-MM-DD HH24:MI:SS:FF TZH:TZM'''; :1 := dbms_stats.report_stats_operations( detail_level => 'ALL', format => 'XML', since=> systimestamp-7 ); end;
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 |
| References |