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

From: John Hurley <>
Date: Sat, 18 Jul 2009 10:22:44 -0700 (PDT)
Message-ID: <>

On Jul 18, 9:11 am, Edward <> wrote:


> 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

You could put a trace onto that session ( a 10046 trace ) and then use a utility to read and format the contents of that trace file. I like orasrp ... but anyway the trace file will show all the sql calls ( and wait events ) from that session. Received on Sat Jul 18 2009 - 12:22:44 CDT

Original text of this message