I have one application which is executing a number of queries in the current session. I want to know which query is taking how much time?
So I have executed following query in Toad for this purpose, but this is giving details of those queries only which are executed from either Toad or SQL developer.
I am not able to see that particular query which is executed from application. Please suggest me if I am missing something.
from v$session ss, v$sqlarea sa
order by sa.first_load_time desc;
Oracle Version - Release 126.96.36.199.0 Production
Toad Version - 188.8.131.52
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.