Big load on your database server, you know the PID but not the actual SQL ID that is eating your resources? Hereby a small query to help you start the quest:
1. Login with sysdba privileges
|
1 |
sqlplus / as sysdba |
2. Execute the following query:
|
1 2 3 |
Select * From v$sqlarea Where sql_id In (Select sql_id From v$session s, v$process p Where p.addr = s.paddr And spid = :spid) |
Oracle query and PID tracking
