Dump file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_744.trc
Fri Jun 29 10:34:47 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 2
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:898M/2046M, Ph+PgF:2692M/3939M, VA:1258M/2047M
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 16

Windows thread id: 744, image: ORACLE.EXE (SHAD)


*** 2007-06-29 10:34:47.578
*** ACTION NAME:() 2007-06-29 10:34:47.515
*** MODULE NAME:(SQL*Plus) 2007-06-29 10:34:47.515
*** SERVICE NAME:(SYS$USERS) 2007-06-29 10:34:47.515
*** SESSION ID:(133.861) 2007-06-29 10:34:47.515
=====================
PARSING IN CURSOR #5 len=70 dep=1 uid=0 oct=47 lid=0 tim=3421350774 hv=3588952050 ad='2dd95d2c'
BEGIN dbms_monitor.session_trace_enable (NULL, NULL, TRUE, TRUE); END;
END OF STMT
EXEC #5:c=0,e=182,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=3421350766
HOTSOS_ILO_TASK.BEGIN_TASK[][HotSos Test 2][Nesting the call to Test 1][AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS][Trying out Nesting]
*** 2007-06-29 10:34:47.640
*** ACTION NAME:(Nesting the call to Test 1) 2007-06-29 10:34:47.656
*** MODULE NAME:(HotSos Test 2) 2007-06-29 10:34:47.656
=====================
PARSING IN CURSOR #6 len=51 dep=1 uid=0 oct=47 lid=0 tim=3421487764 hv=3782099507 ad='2dd94404'
BEGIN DBMS_SESSION.SET_IDENTIFIER(:client_id); END;
END OF STMT
PARSE #6:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=3421487756
BINDS #6:
kkscoacd
 Bind#0
  oacdty=01 mxl=2000(255) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=01 csi=178 siz=2000 off=0
  kxsbbbfp=07996084  bln=2000  avl=45  flg=09
  value="AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS"
*** CLIENT ID:(AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS) 2007-06-29 10:34:47.703
EXEC #6:c=0,e=31300,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=3421549666
BINDS #5:
EXEC #5:c=0,e=4757,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=3421563804
HOTSOS_ILO_TASK.BEGIN_TASK[][HotSos Test][First call to the ILO][AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS][Testing the ILO...]
*** 2007-06-29 10:34:47.734
*** ACTION NAME:(First call to the ILO) 2007-06-29 10:34:47.734
*** MODULE NAME:(HotSos Test) 2007-06-29 10:34:47.734
*** 2007-06-29 10:34:47.734
HOTSOS_ILO_TASK.END_TASK[][HotSos Test][First call to the ILO][AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS][Testing the ILO...]
*** ACTION NAME:(Nesting the call to Test 1) 2007-06-29 10:34:47.750
*** MODULE NAME:(HotSos Test 2) 2007-06-29 10:34:47.750
*** 2007-06-29 10:34:47.750
HOTSOS_ILO_TASK.END_TASK[][HotSos Test 2][Nesting the call to Test 1][AMIS\alex_n~14-317-737~sqlplusw.exe~SYS$USERS][Trying out Nesting]
*** ACTION NAME:() 2007-06-29 10:34:47.781
*** MODULE NAME:(SQL*Plus) 2007-06-29 10:34:47.781
BINDS #6:
kkscoacd
 Bind#0
  oacdty=01 mxl=2000(00) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=01 csi=178 siz=2000 off=0
  kxsbbbfp=00000000  bln=2000  avl=00  flg=09
*** CLIENT ID:() 2007-06-29 10:34:47.812
EXEC #6:c=0,e=38653,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=3421654282
=====================
PARSING IN CURSOR #7 len=59 dep=1 uid=0 oct=47 lid=0 tim=3421664357 hv=1113547141 ad='2dd92c74'
BEGIN dbms_monitor.session_trace_disable (NULL, NULL); END;
END OF STMT
PARSE #7:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=3421664350
BINDS #7:
EXEC #7:c=0,e=5145,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,tim=3421694130