Slow Performance Of Cloud Control 12c Tablespace Monitoring SQL czzfwwn404avq
(Doc ID 2368687.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
Cloud Control 12c executed SQL czzfwwn404avq every 30 minutes, since dba_recyclebin is not empty, this SQL occupied too much CPU time; and Administration Storage Tablespaces page takes long time to display data.
Following is the navigation:
1. Login to 12c console
2. Navigate to Targets --> Databases
3. Click on database name to go to database home page
4. From the database home page, navigate to following:
Administration ->Storage ->Tablespaces
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!