Help: How do i know which sql is a session executing if user is using PL/SQL?
Date: Sat, 18 Jul 2009 06:11:07 -0700 (PDT)
We are using Oracle 10g2
One of the session is showing wait as "db file sequential read", but from v$session and v$sqltext, i can only see he is executing
BEGIN package_name.procedure_name('xxx', 'yyyy'); END;
How could you digging further to see which SQL is he executing, so we can further tune the sql?
Thanks for your help Received on Sat Jul 18 2009 - 08:11:07 CDT