PARSING IN CURSOR #711788888 len=126 dep=0 uid=4542 oct=3 lid=4542 tim=6207502208599 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=0,e=241,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1928458682,tim=6207502208598
EXEC #711788888:c=0,e=127,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1928458682,tim=6207502209383
FETCH #711788888:c=0,e=1975,p=0,cr=104,cu=0,mis=0,r=1,dep=0,og=1,plh=1928458682,tim=6207502211578
STAT #711788888 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=104 pr=0 pw=0 time=1998 us)'
STAT #711788888 id=2 cnt=2 pid=1 pos=1 obj=0 op='FILTER  (cr=104 pr=0 pw=0 time=1957 us)'
STAT #711788888 id=3 cnt=2 pid=2 pos=1 obj=0 op='NESTED LOOPS SEMI (cr=101 pr=0 pw=0 time=1263 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=398 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=368 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=329 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=273 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=248 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=218 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=187 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=147 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=87 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=47 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=34 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=60 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=13 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=27 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=26 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=25 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=53 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=37 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=15 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=24 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=857 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=850 us)'
STAT #711788888 id=31 cnt=2 pid=30 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=50 pr=0 pw=0 time=266 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=236 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=213 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=182 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=156 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=134 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=106 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=64 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=25 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=12 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=34 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=20 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=35 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=21 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=22 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=16 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=10 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=19 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=16 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=19 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=551 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=17 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=22 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=667 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=12 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=2,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=1928458682,tim=6207502220467

*** 2017-04-26 09:13:15.765
CLOSE #711788888:c=0,e=41,dep=0,type=0,tim=6207508358372