My Oracle Support Banner

Enterprise Manager 10g to 12c - Tablespace Data Query shows as Top SQL and Runs Slow (Doc ID 1327378.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 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

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