/u5/oracle/9.2.0/admin/OLAP/udump/olap_ora_880.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

*** SESSION ID:(46.106) 2004-07-20 11:44:09.473
APPNAME mod='PL/SQL Developer' mh=1190136663 act='Command Window - New' ah=254318129
=====================
PARSING IN CURSOR #1 len=36 dep=0 uid=0 oct=42 lid=0 tim=7116418302 hv=659427939 ad='90cadd80'
alter session set sql_trace = true
END OF STMT
EXEC #1:c=0,e=187,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7116406214
=====================
PARSING IN CURSOR #2 len=61 dep=0 uid=0 oct=47 lid=0 tim=7116426547 hv=2707513792 ad='8c884a38'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #2:c=0,e=358,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7116426541
EXEC #2:c=0,e=160,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=7116426882
=====================
PARSING IN CURSOR #2 len=61 dep=0 uid=0 oct=47 lid=0 tim=7116432221 hv=2707513792 ad='8c884a38'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #2:c=0,e=152,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7116432216
EXEC #2:c=0,e=91,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=7116432409
*** 2004-07-20 11:44:21.043
=====================
PARSING IN CURSOR #3 len=21 dep=0 uid=0 oct=3 lid=0 tim=7127705487 hv=3293499221 ad='8c8a3f80'
select 'x' from dual
END OF STMT
PARSE #3:c=0,e=171,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7127705472
EXEC #3:c=0,e=115,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7127705826
FETCH #3:c=0,e=159,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=7127706678
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=222 op='TABLE ACCESS FULL DUAL (cr=3 r=0 w=0 time=131 us)'
=====================
PARSING IN CURSOR #3 len=40 dep=1 uid=0 oct=3 lid=0 tim=7127716828 hv=3360804353 ad='8d809900'
select default$ from col$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=801,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=7127716820
EXEC #3:c=0,e=579,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=7127717652
FETCH #3:c=0,e=66,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=7127717782
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=21 op='TABLE ACCESS BY USER ROWID COL$ (cr=1 r=0 w=0 time=42 us)'
=====================
PARSING IN CURSOR #1 len=42 dep=0 uid=0 oct=3 lid=0 tim=7127720513 hv=2750412614 ad='90cacd10'
select count(*) from gkhstar.fc_payments
END OF STMT
PARSE #1:c=0,e=5504,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=7127720505
EXEC #1:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7127720702
FETCH #1:c=1560000,e=1645815,p=3544,cr=3555,cu=0,mis=0,r=1,dep=0,og=4,tim=7129367252
=====================
PARSING IN CURSOR #2 len=61 dep=0 uid=0 oct=47 lid=0 tim=7129382574 hv=2707513792 ad='8c884a38'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #2:c=0,e=447,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7129382567
EXEC #2:c=0,e=296,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=7129383079
=====================
PARSING IN CURSOR #2 len=61 dep=0 uid=0 oct=47 lid=0 tim=7129388483 hv=2707513792 ad='8c884a38'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #2:c=0,e=148,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7129388478
EXEC #2:c=0,e=101,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=7129388684
=====================
PARSING IN CURSOR #3 len=21 dep=0 uid=0 oct=3 lid=0 tim=7134797204 hv=3293499221 ad='8c8a3f80'
select 'x' from dual
END OF STMT
PARSE #3:c=0,e=191,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7134797187
EXEC #3:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7134797443
FETCH #3:c=0,e=203,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=7134798460
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=3555 r=3544 w=0 time=1645744 us)'
STAT #1 id=2 cnt=1689085 pid=1 pos=1 obj=101728 op='INDEX FAST FULL SCAN ACT_PMNT_FK_I (cr=3555 r=3544 w=0 time=1231510 us)'
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=222 op='TABLE ACCESS FULL DUAL (cr=3 r=0 w=0 time=173 us)'
=====================
PARSING IN CURSOR #1 len=37 dep=0 uid=0 oct=42 lid=0 tim=7134807115 hv=3676133329 ad='90a79a68'
alter session set sql_trace = false
END OF STMT
PARSE #1:c=0,e=562,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=7134807109
EXEC #1:c=0,e=115,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=7134807325