How to Identify the SQL Used by Enterprise Manager 10g and 11g Grid Control or 12c and 13c Cloud Control For Administrative / Real-time Monitoring Pages of a Database Target (Doc ID 357318.1)

Last updated on NOVEMBER 21, 2018

Applies to:

Goal

The document explains the steps for identifying / tracing the SQL used by the OMS, for the Administrative / Real-time monitoring operations performed in the Grid Console, against a target Database.

It is possible to view / trace the SQL statements executed by the OMS against the Target Databases, for the operations performed in the Grid Console:

• In 10.2.0.4 Grid Control Console (or less), navigate to Targets -> Databases -> click on the database name -> 'SQL History' link the bottom of the page, under the 'Related Links' section.
• In 10.2.0.5 Grid Control Console, navigate to Targets -> Databases -> click on the database name -> 'EM SQL History' link the bottom of the page, under the 'Related Links' section.
• In 12c and 13c Cloud Control console, navigate to Targets -> Databases -> Click on the desired database -> Performance menu -> SQL -> Cloud Control SQL history

The EM SQL History page shows the Administration, Real-time and Repository monitoring SQL statements.

Solution

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