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

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