Dump file d:\oracle\admin\di29\udump\di29_ora_4420.trc Thu Aug 20 11:40:10 2009 ORACLE V9.2.0.8.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 Service Pack 2, CPU type 586 Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production Windows 2000 Version 5.2 Service Pack 2, CPU type 586 Instance name: di29 Redo thread mounted by this instance: 1 Oracle process number: 10 Windows thread id: 4420, image: ORACLE.EXE *** 2009-08-20 11:40:11.433 *** SESSION ID:(9.608) 2009-08-20 11:40:10.512 APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240 ===================== PARSING IN CURSOR #1 len=32 dep=0 uid=41 oct=42 lid=41 tim=3517459833 hv=3943786303 ad='19a3a42c' alter session set sql_trace=true END OF STMT EXEC #1:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3516522582 *** 2009-08-20 11:43:22.450 ===================== PARSING IN CURSOR #1 len=51 dep=0 uid=41 oct=3 lid=41 tim=3708431862 hv=1684949949 ad='1a62ef9c' select * from ms_sales_test where sales_id = :atest END OF STMT PARSE #1:c=15625,e=1267,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=0,tim=3708431858 EXEC #1:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3708482094 FETCH #1:c=0,e=70,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=3708495259 FETCH #1:c=0,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=3708502895 STAT #1 id=1 cnt=1 pid=0 pos=1 obj=79636 op='TABLE ACCESS BY INDEX ROWID MS_SALES_TEST ' STAT #1 id=2 cnt=1 pid=1 pos=1 obj=79637 op='INDEX UNIQUE SCAN MS_SALES_TEST_PK ' ===================== PARSING IN CURSOR #1 len=51 dep=0 uid=41 oct=3 lid=41 tim=3711698450 hv=1684949949 ad='1a62ef9c' select * from ms_sales_test where sales_id = :atest END OF STMT PARSE #1:c=0,e=89,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3711698446 EXEC #1:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3711759579 FETCH #1:c=0,e=59,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=3711765990 FETCH #1:c=0,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=3711780322 STAT #1 id=1 cnt=1 pid=0 pos=1 obj=79636 op='TABLE ACCESS BY INDEX ROWID MS_SALES_TEST ' STAT #1 id=2 cnt=1 pid=1 pos=1 obj=79637 op='INDEX UNIQUE SCAN MS_SALES_TEST_PK ' ===================== PARSING IN CURSOR #1 len=35 dep=0 uid=41 oct=42 lid=41 tim=3729394291 hv=3080343475 ad='1a65b540' alter session set sql_trace = false END OF STMT PARSE #1:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3729394287 EXEC #1:c=0,e=91,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3729434700