How to Identify the SQL Used by Enterprise Manager 10g and 11g Grid Control of 12c and 13c Cloud Control For Administrative / Real-time Monitoring Pages of a Database Target
Last updated on FEBRUARY 28, 2017
Applies to:
Enterprise Manager for Oracle Database - Version 10.2.0.1 and laterInformation in this document applies to any platform.
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
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 hundreds of Community platforms