*** 2008-06-18 11:23:43.000
*** SESSION ID:(21.16) 2008-06-18 11:23:43.000
STAT #1 id=1 cnt=10 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #1 id=2 cnt=10 pid=1 pos=1 obj=0 op='FILTER  '
STAT #1 id=3 cnt=10 pid=2 pos=1 obj=25 op='FIXED TABLE FULL X$KSUSESTA '
STAT #1 id=4 cnt=1 pid=2 pos=2 obj=24 op='FIXED TABLE FULL X$KSUSGIF '
=====================
PARSING IN CURSOR #1 len=211 dep=0 uid=59 oct=3 lid=59 tim=14252235729 hv=3424955152 ad='66d27bbc'
SELECT PT.VALUE FROM SYS.V_$SESSTAT PT WHERE PT.SID=:1 AND PT.STATISTIC# IN (:"SYS_B_0",:"SYS_B_1",:"SYS_B_2",:"SYS_B_3",:"SYS_B_4",:"SYS_B_5",:"SYS_B_6",:"SYS_B_7",:"SYS_B_8",:"SYS_B_9") ORDER BY PT.STATISTIC#
END OF STMT
PARSE #1:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14252235723
EXEC #1:c=0,e=93,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14252251490
FETCH #1:c=46875,e=41429,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=14252295433
FETCH #1:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=9,dep=0,og=4,tim=14252298797
*** SESSION ID:(20.1) 2008-06-18 11:23:43.000
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #1 id=2 cnt=4 pid=1 pos=1 obj=30802 op='TABLE ACCESS FULL PLAN_TABLE '
=====================
PARSING IN CURSOR #1 len=56 dep=0 uid=59 oct=3 lid=59 tim=14252310030 hv=1030366697 ad='66d14488'
select count(ename) from employee where empno=:"SYS_B_0"
END OF STMT
PARSE #1:c=0,e=185,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14252310024
EXEC #1:c=0,e=94,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14252323106
FETCH #1:c=828125,e=4380192,p=11128,cr=11861,cu=0,mis=0,r=1,dep=0,og=4,tim=14256705924
FETCH #1:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=14256711223
*** SESSION ID:(21.16) 2008-06-18 11:23:48.000
STAT #1 id=1 cnt=10 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #1 id=2 cnt=10 pid=1 pos=1 obj=0 op='FILTER  '
STAT #1 id=3 cnt=10 pid=2 pos=1 obj=25 op='FIXED TABLE FULL X$KSUSESTA '
STAT #1 id=4 cnt=1 pid=2 pos=2 obj=24 op='FIXED TABLE FULL X$KSUSGIF '
=====================
PARSING IN CURSOR #1 len=211 dep=0 uid=59 oct=3 lid=59 tim=14256738671 hv=3424955152 ad='66d27bbc'
SELECT PT.VALUE FROM SYS.V_$SESSTAT PT WHERE PT.SID=:1 AND PT.STATISTIC# IN (:"SYS_B_0",:"SYS_B_1",:"SYS_B_2",:"SYS_B_3",:"SYS_B_4",:"SYS_B_5",:"SYS_B_6",:"SYS_B_7",:"SYS_B_8",:"SYS_B_9") ORDER BY PT.STATISTIC#
END OF STMT
PARSE #1:c=0,e=172,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256738665
EXEC #1:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256752419
FETCH #1:c=46875,e=41218,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=14256796475
FETCH #1:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=9,dep=0,og=4,tim=14256800147
*** SESSION ID:(20.1) 2008-06-18 11:23:48.000
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
STAT #1 id=2 cnt=2097152 pid=1 pos=1 obj=30800 op='TABLE ACCESS FULL EMPLOYEE '
=====================
PARSING IN CURSOR #1 len=45 dep=0 uid=59 oct=7 lid=59 tim=14256814210 hv=3646959301 ad='66ccb964'
DELETE FROM PLAN_TABLE WHERE STATEMENT_ID=:1
END OF STMT
PARSE #1:c=0,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256814201
EXEC #1:c=0,e=167,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=4,tim=14256828308
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  '
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=30802 op='TABLE ACCESS FULL PLAN_TABLE '
=====================
PARSING IN CURSOR #1 len=94 dep=0 uid=59 oct=50 lid=59 tim=14256842980 hv=3987873915 ad='66cc5b74'
EXPLAIN PLAN SET STATEMENT_ID='PLUS316' FOR select count(ename) from employee where empno=7934
END OF STMT
PARSE #1:c=0,e=1573,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=14256842970
=====================
PARSING IN CURSOR #2 len=477 dep=1 uid=59 oct=2 lid=59 tim=14256858362 hv=3757861941 ad='66cc27b4'
insert into plan_table (statement_id, timestamp, operation, options,object_node, object_owner, object_name, object_instance, object_type,search_columns, id, parent_id, position, other,optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates ) values(:1,SYSDATE,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27)
END OF STMT
PARSE #2:c=0,e=104,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=14256858352
=====================
PARSING IN CURSOR #3 len=85 dep=1 uid=0 oct=3 lid=0 tim=14256874227 hv=2929147647 ad='66cba0b8'
select o.name, u.name from sys.obj$ o, sys.user$ u where obj# = :1 and owner# = user#
END OF STMT
PARSE #3:c=0,e=92,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,tim=14256874216
EXEC #2:c=0,e=271,p=0,cr=1,cu=1,mis=0,r=1,dep=1,og=4,tim=14256893023
EXEC #2:c=0,e=229,p=0,cr=0,cu=1,mis=0,r=1,dep=1,og=4,tim=14256896879
EXEC #2:c=0,e=229,p=0,cr=0,cu=1,mis=0,r=1,dep=1,og=4,tim=14256900850
EXEC #1:c=46875,e=46385,p=0,cr=1,cu=3,mis=0,r=0,dep=0,og=4,tim=14256904527
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=30800 op='TABLE ACCESS FULL EMPLOYEE '
=====================
PARSING IN CURSOR #1 len=818 dep=0 uid=59 oct=3 lid=59 tim=14256918002 hv=4184106318 ad='66cb5b7c'
SELECT ID ID_PLUS_EXP,PARENT_ID PARENT_ID_PLUS_EXP,LPAD(:"SYS_B_00",:"SYS_B_01"*(LEVEL-:"SYS_B_02"))||OPERATION||DECODE(OTHER_TAG,NULL,:"SYS_B_03",:"SYS_B_04")||DECODE(OPTIONS,NULL,:"SYS_B_05",:"SYS_B_06"||OPTIONS||:"SYS_B_07")||DECODE(OBJECT_NAME,NULL,:"SYS_B_08",:"SYS_B_09"||OBJECT_NAME||:"SYS_B_10")||DECODE(OBJECT_TYPE,NULL,:"SYS_B_11",:"SYS_B_12"||OBJECT_TYPE||:"SYS_B_13")||DECODE(ID,:"SYS_B_14",DECODE(OPTIMIZER,NULL,:"SYS_B_15",:"SYS_B_16"||OPTIMIZER))||DECODE(COST,NULL,:"SYS_B_17",:"SYS_B_18"||COST||DECODE(CARDINALITY,NULL,:"SYS_B_19",:"SYS_B_20"||CARDINALITY)||DECODE(BYTES,NULL,:"SYS_B_21",:"SYS_B_22"||BYTES)||:"SYS_B_23") PLAN_PLUS_EXP,OBJECT_NODE OBJECT_NODE_PLUS_EXP FROM PLAN_TABLE START WITH ID=:"SYS_B_24" AND STATEMENT_ID=:1 CONNECT BY PRIOR ID=PARENT_ID AND STATEMENT_ID=:1 ORDER BY ID,POSITION
END OF STMT
PARSE #1:c=0,e=244,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256917996
EXEC #1:c=0,e=263,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256935292
FETCH #1:c=0,e=622,p=0,cr=13,cu=0,mis=0,r=1,dep=0,og=4,tim=14256939397
FETCH #1:c=0,e=58,p=0,cr=0,cu=0,mis=0,r=2,dep=0,og=4,tim=14256944171
STAT #1 id=1 cnt=3 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #1 id=2 cnt=3 pid=1 pos=1 obj=0 op='CONNECT BY WITH FILTERING '
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS  '
STAT #1 id=4 cnt=1 pid=3 pos=1 obj=30802 op='TABLE ACCESS FULL PLAN_TABLE '
STAT #1 id=5 cnt=1 pid=3 pos=2 obj=30802 op='TABLE ACCESS BY USER ROWID PLAN_TABLE '
STAT #1 id=6 cnt=2 pid=2 pos=2 obj=0 op='NESTED LOOPS  '
STAT #1 id=7 cnt=3 pid=6 pos=1 obj=0 op='BUFFER SORT '
STAT #1 id=8 cnt=3 pid=7 pos=1 obj=0 op='CONNECT BY PUMP  '
STAT #1 id=9 cnt=2 pid=6 pos=2 obj=30802 op='TABLE ACCESS FULL PLAN_TABLE '
=====================
PARSING IN CURSOR #1 len=148 dep=0 uid=59 oct=3 lid=59 tim=14256987191 hv=1618402685 ad='66cac458'
SELECT ID ID_PLUS_EXP,OTHER_TAG OTHER_TAG_PLUS_EXP,OTHER OTHER_PLUS_EXP FROM PLAN_TABLE WHERE STATEMENT_ID=:1 AND OTHER_TAG IS NOT NULL ORDER BY ID
END OF STMT
PARSE #1:c=0,e=81,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14256987181
EXEC #1:c=0,e=91,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14257007614
FETCH #1:c=0,e=134,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=4,tim=14257012180
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=30802 op='TABLE ACCESS FULL PLAN_TABLE '
=====================
PARSING IN CURSOR #1 len=45 dep=0 uid=59 oct=7 lid=59 tim=14257026212 hv=3646959301 ad='66ccb964'
DELETE FROM PLAN_TABLE WHERE STATEMENT_ID=:1
END OF STMT
PARSE #1:c=0,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=14257026201
EXEC #1:c=0,e=322,p=0,cr=3,cu=3,mis=0,r=3,dep=0,og=4,tim=14257044068