This content has been marked as final. Show 2 replies
The best resource for query statistics is either the AWR or trace file.
The latter should be parsed through tkprof (or orasrp )
is there any option for this through Oracle Enterprise Manager 11g?
Actually I have done little bit research on EM console and go through SQL Monitoring Executions page but did not get the particular query details executed through the application.
I have also checked the link - AWR Baseline but not get any result.
As I am new in database administration activities, Please help me regarding this. You can also suggest me other solution except Oracle EM console.