Advanced SQL

From: news.kpnqwest.com <a_at_b.com>
Date: Fri, 24 May 2002 09:41:42 GMT
Message-ID: <qVnH8.12$NZ1.634@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 - 04:41:42 CDT

Advanced SQL_TRACE