How to get the sql statement executed to get the "average active sessions,Instance Disk I/O and Inst
The database is 10.2
In order to identify the SQL statement behind any transaction performed on a database, I open the following page with contains all SQL history on this Database,
1- Login to EM Grid Control using username and password
2- Press on 'Targets' tab on the top right of the page
3- Select any db from Databases
4- Press on 'Administration' tab under the DB page
5- Press on 'SQL History' link under the Related Links section at the bottom of the page.
6- Clear this page and keep it opened
7- Navigate to the operation I need to check its SQL statement on the Database, and once I view the information on the page, then the SQL History page will display the SQL Statement that run on the DB behind this operation.
In order to identify the SQL statement behind any transaction performed on a database, I open the following page with contains all SQL history on this Database,
1- Login to EM Grid Control using username and password
2- Press on 'Targets' tab on the top right of the page
3- Select any db from Databases
4- Press on 'Administration' tab under the DB page
5- Press on 'SQL History' link under the Related Links section at the bottom of the page.
6- Clear this page and keep it opened
7- Navigate to the operation I need to check its SQL statement on the Database, and once I view the information on the page, then the SQL History page will display the SQL Statement that run on the DB behind this operation.
0