Re: Advanced SQL_TRACE

To show Waits and binds:

At the system level

alter system set events '10046 trace name context forever, level 12';

or at the session level

alter session set events '10046 trace name context forever, level 12';

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"news.kpnqwest.com" <a_at_b.com> wrote in message news:qVnH8.12$NZ1.634_at_nreader1.kpnqwest.net...
> Hi,
>
> Anybody who can tell me how I can turn on the advanced SQL_TRACE options
> that show me output like:
>
> EXEC #23:c=1,e=1,p=0,cr=2,cu=7,mis=0,r=1,dep=0,og=4,tim=23255927
> WAIT #23: nam='SQL*Net message to client' ela= 0 p1=675562835 p2=1 p3=0
> *** 2001-11-30 09:40:38.000
> WAIT #23: nam='SQL*Net message from client' ela= 1662 p1=675562835 p2=1
p3=0
> XCTEND rlbk=0, rd_only=0
> WAIT #0: nam='log file sync' ela= 1 p1=444 p2=0 p3=0
> WAIT #0: nam='SQL*Net message to client' ela= 0 p1=675562835 p2=1 p3=0
> WAIT #0: nam='SQL*Net message from client' ela= 0 p1=675562835 p2=1 p3=0
> STAT #2 id=1 cnt=0 pid=0 pos=0 obj=0 op='SORT AGGREGATE '
>
> Kind regards,
> Dick Westeneng
>
>
Received on Fri May 24 2002 - 05:41:24 CDT