This works thanks!
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:ues673iv4d78ac_at_corp.supernews.com...
> 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 - 07:15:10 CDT
