Enterprise Manager 10g to 12c - Tablespace Data Query shows as Top SQL and Runs Slow
(Doc ID 1327378.1)
Last updated on SEPTEMBER 27, 2019
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.5 and later
Information in this document applies to any platform.
This database instance performance problem may be experienced when using Enterprise Manager DB Control, Grid Control or Cloud Control.
This is a database problem and not a Enterprise Manager problem. It can be seen outside Enterprise Manager.
The SQL completes however it runs slow, and shows as 'Top SQL'.
Any TableSpace-related SQL query completes, but is very slow and belongs to the "TopSQL".
The following SQL from OEM shows as the 'Top SQL' on the Database Target:
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