Re: Help: How do i know which sql is a session executing if user is using PL/SQL?
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Sat, 18 Jul 2009 10:22:44 -0700 (PDT)
Message-ID: <8ccbf501-56fc-4f50-bc16-b56341a34a87_at_c29g2000yqd.googlegroups.com>
On Jul 18, 9:11 am, Edward <edwardnin..._at_yahoo.com> wrote:
Date: Sat, 18 Jul 2009 10:22:44 -0700 (PDT)
Message-ID: <8ccbf501-56fc-4f50-bc16-b56341a34a87_at_c29g2000yqd.googlegroups.com>
On Jul 18, 9:11 am, Edward <edwardnin..._at_yahoo.com> wrote:
snip
> 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