My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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

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!


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