Help: How do i know which sql is a session executing if user is using PL/SQL?

From: Edward <>
Date: Sat, 18 Jul 2009 06:11:07 -0700 (PDT)
Message-ID: <>

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

Original text of this message