PARSING IN CURSOR #711788888 len=126 dep=0 uid=4542 oct=3 lid=4542 tim=6207500558064 hv=205233663 ad='7ffb281ec78' sqlid='180ugr863r7gz' select count(*) from all_sdo_index_info i where i.table_owner='HPD3ATL' and i.table_name = upper('P13_PDB9077_ENCLINE_BACKUP') END OF STMT PARSE #711788888:c=1937500,e=1932667,p=0,cr=8388,cu=0,mis=1,r=0,dep=0,og=1,plh=1928458682,tim=6207500558062 EXEC #711788888:c=0,e=115,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1928458682,tim=6207500559030 FETCH #711788888:c=0,e=1599,p=0,cr=104,cu=0,mis=0,r=1,dep=0,og=1,plh=1928458682,tim=6207500561373 STAT #711788888 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=104 pr=0 pw=0 time=1614 us)' STAT #711788888 id=2 cnt=2 pid=1 pos=1 obj=0 op='FILTER (cr=104 pr=0 pw=0 time=1574 us)' STAT #711788888 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS SEMI (cr=101 pr=0 pw=0 time=1145 us cost=33 size=207 card=1)' STAT #711788888 id=4 cnt=2 pid=3 pos=1 obj=0 op='NESTED LOOPS (cr=48 pr=0 pw=0 time=355 us cost=17 size=207 card=1)' STAT #711788888 id=5 cnt=2 pid=4 pos=1 obj=0 op='NESTED LOOPS (cr=44 pr=0 pw=0 time=327 us cost=16 size=175 card=1)' STAT #711788888 id=6 cnt=2 pid=5 pos=1 obj=0 op='NESTED LOOPS (cr=38 pr=0 pw=0 time=292 us cost=15 size=158 card=1)' STAT #711788888 id=7 cnt=2 pid=6 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=31 pr=0 pw=0 time=236 us cost=12 size=122 card=1)' STAT #711788888 id=8 cnt=2 pid=7 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=27 pr=0 pw=0 time=214 us cost=11 size=118 card=1)' STAT #711788888 id=9 cnt=2 pid=8 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=21 pr=0 pw=0 time=185 us cost=9 size=108 card=1)' STAT #711788888 id=10 cnt=2 pid=9 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=15 pr=0 pw=0 time=157 us cost=7 size=94 card=1)' STAT #711788888 id=11 cnt=2 pid=10 pos=1 obj=0 op='NESTED LOOPS (cr=11 pr=0 pw=0 time=122 us cost=6 size=90 card=1)' STAT #711788888 id=12 cnt=1 pid=11 pos=1 obj=0 op='NESTED LOOPS (cr=6 pr=0 pw=0 time=86 us cost=4 size=54 card=1)' STAT #711788888 id=13 cnt=1 pid=12 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=3 pr=0 pw=0 time=46 us cost=2 size=17 card=1)' STAT #711788888 id=14 cnt=1 pid=13 pos=1 obj=46 op='INDEX UNIQUE SCAN I_USER1 (cr=2 pr=0 pw=0 time=31 us cost=1 size=0 card=1)' STAT #711788888 id=15 cnt=1 pid=12 pos=2 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=33 us cost=2 size=37 card=1)' STAT #711788888 id=16 cnt=2 pid=11 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=5 pr=0 pw=0 time=35 us cost=2 size=72 card=2)' STAT #711788888 id=17 cnt=1 pid=16 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=11 us cost=1 size=0 card=1)' STAT #711788888 id=18 cnt=2 pid=10 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=4 pr=0 pw=0 time=25 us cost=1 size=4 card=1)' STAT #711788888 id=19 cnt=2 pid=18 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=2 pr=0 pw=0 time=14 us cost=0 size=0 card=1)' STAT #711788888 id=20 cnt=0 pid=9 pos=2 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=6 pr=0 pw=0 time=24 us cost=2 size=14 card=1)' STAT #711788888 id=21 cnt=0 pid=20 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=6 pr=0 pw=0 time=17 us cost=1 size=0 card=1)' STAT #711788888 id=22 cnt=2 pid=8 pos=2 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=6 pr=0 pw=0 time=21 us cost=2 size=10 card=1)' STAT #711788888 id=23 cnt=2 pid=7 pos=2 obj=47 op='INDEX RANGE SCAN I_USER2 (cr=4 pr=0 pw=0 time=17 us cost=1 size=4 card=1)' STAT #711788888 id=24 cnt=2 pid=6 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=7 pr=0 pw=0 time=52 us cost=3 size=36 card=1)' STAT #711788888 id=25 cnt=2 pid=24 pos=1 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=6 pr=0 pw=0 time=24 us cost=2 size=0 card=1)' STAT #711788888 id=26 cnt=2 pid=5 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=6 pr=0 pw=0 time=32 us cost=1 size=17 card=1)' STAT #711788888 id=27 cnt=2 pid=26 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=4 pr=0 pw=0 time=13 us cost=0 size=0 card=1)' STAT #711788888 id=28 cnt=2 pid=4 pos=2 obj=2186811 op='INDEX RANGE SCAN SDO_IDX_MDATA_IDX (cr=4 pr=0 pw=0 time=22 us cost=1 size=32 card=1)' STAT #711788888 id=29 cnt=2 pid=3 pos=2 obj=0 op='VIEW PUSHED PREDICATE VW_SQ_1 (cr=53 pr=0 pw=0 time=784 us cost=16 size=0 card=1)' STAT #711788888 id=30 cnt=2 pid=29 pos=1 obj=0 op='FILTER (cr=53 pr=0 pw=0 time=779 us)' STAT #711788888 id=31 cnt=2 pid=30 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=50 pr=0 pw=0 time=244 us cost=16 size=139 card=1)' STAT #711788888 id=32 cnt=2 pid=31 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=46 pr=0 pw=0 time=217 us cost=15 size=135 card=1)' STAT #711788888 id=33 cnt=2 pid=32 pos=1 obj=0 op='NESTED LOOPS (cr=40 pr=0 pw=0 time=194 us cost=13 size=125 card=1)' STAT #711788888 id=34 cnt=2 pid=33 pos=1 obj=0 op='NESTED LOOPS (cr=36 pr=0 pw=0 time=164 us cost=12 size=121 card=1)' STAT #711788888 id=35 cnt=2 pid=34 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=30 pr=0 pw=0 time=139 us cost=10 size=107 card=1)' STAT #711788888 id=36 cnt=2 pid=35 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=24 pr=0 pw=0 time=117 us cost=8 size=93 card=1)' STAT #711788888 id=37 cnt=2 pid=36 pos=1 obj=0 op='NESTED LOOPS (cr=20 pr=0 pw=0 time=91 us cost=7 size=89 card=1)' STAT #711788888 id=38 cnt=2 pid=37 pos=1 obj=0 op='NESTED LOOPS (cr=13 pr=0 pw=0 time=56 us cost=5 size=53 card=1)' STAT #711788888 id=39 cnt=2 pid=38 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=6 pr=0 pw=0 time=20 us cost=2 size=17 card=1)' STAT #711788888 id=40 cnt=2 pid=39 pos=1 obj=46 op='INDEX UNIQUE SCAN I_USER1 (cr=4 pr=0 pw=0 time=11 us cost=1 size=0 card=1)' STAT #711788888 id=41 cnt=2 pid=38 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=7 pr=0 pw=0 time=30 us cost=3 size=36 card=1)' STAT #711788888 id=42 cnt=2 pid=41 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=6 pr=0 pw=0 time=17 us cost=2 size=0 card=1)' STAT #711788888 id=43 cnt=2 pid=37 pos=2 obj=19 op='TABLE ACCESS BY INDEX ROWID IND$ (cr=7 pr=0 pw=0 time=30 us cost=2 size=36 card=1)' STAT #711788888 id=44 cnt=2 pid=43 pos=1 obj=41 op='INDEX UNIQUE SCAN I_IND1 (cr=6 pr=0 pw=0 time=19 us cost=1 size=0 card=1)' STAT #711788888 id=45 cnt=2 pid=36 pos=2 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=4 pr=0 pw=0 time=18 us cost=1 size=4 card=1)' STAT #711788888 id=46 cnt=2 pid=45 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=2 pr=0 pw=0 time=8 us cost=0 size=0 card=1)' STAT #711788888 id=47 cnt=0 pid=35 pos=2 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=6 pr=0 pw=0 time=15 us cost=2 size=14 card=1)' STAT #711788888 id=48 cnt=0 pid=47 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=6 pr=0 pw=0 time=9 us cost=1 size=0 card=1)' STAT #711788888 id=49 cnt=2 pid=34 pos=2 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=6 pr=0 pw=0 time=20 us cost=2 size=14 card=1)' STAT #711788888 id=50 cnt=2 pid=33 pos=2 obj=47 op='INDEX RANGE SCAN I_USER2 (cr=4 pr=0 pw=0 time=24 us cost=1 size=4 card=1)' STAT #711788888 id=51 cnt=2 pid=32 pos=2 obj=36 op='INDEX RANGE SCAN I_OBJ1 (cr=6 pr=0 pw=0 time=14 us cost=2 size=10 card=1)' STAT #711788888 id=52 cnt=2 pid=31 pos=2 obj=47 op='INDEX RANGE SCAN I_USER2 (cr=4 pr=0 pw=0 time=18 us cost=1 size=4 card=1)' STAT #711788888 id=53 cnt=1 pid=30 pos=2 obj=0 op='HASH JOIN (cr=3 pr=0 pw=0 time=497 us cost=3 size=23 card=1)' STAT #711788888 id=54 cnt=1 pid=53 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=0 pw=0 time=15 us cost=3 size=20 card=2)' STAT #711788888 id=55 cnt=5 pid=53 pos=2 obj=0 op='FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=21 us cost=0 size=1300 card=100)' STAT #711788888 id=56 cnt=0 pid=30 pos=3 obj=0 op='FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=1)' STAT #711788888 id=57 cnt=1 pid=2 pos=2 obj=0 op='HASH JOIN (cr=3 pr=0 pw=0 time=404 us cost=3 size=23 card=1)' STAT #711788888 id=58 cnt=1 pid=57 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=0 pw=0 time=10 us cost=3 size=20 card=2)' STAT #711788888 id=59 cnt=5 pid=57 pos=2 obj=0 op='FIXED TABLE FULL X$KZSRO (cr=0 pr=0 pw=0 time=9 us cost=0 size=1300 card=100)' STAT #711788888 id=60 cnt=0 pid=2 pos=3 obj=0 op='FIXED TABLE FULL X$KZSPR (cr=0 pr=0 pw=0 time=0 us cost=0 size=26 card=1)' FETCH #711788888:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=1928458682,tim=6207500578857 *** 2017-04-26 09:13:09.625 CLOSE #711788888:c=0,e=20,dep=0,type=0,tim=6207502207906