TKPROF: Release 10.2.0.3.0 - Production on Tue Nov 25 10:18:34 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: svtlsdb_ora_28075.trc Sort options: execpu ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** error connecting to database using: sys/pass4svt ORA-12162: TNS:net service name is incorrectly specified EXPLAIN PLAN option disabled. ******************************************************************************** CALL ICMLSPKG.ICMDELETEITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14, :15) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.28 0.34 5 1137 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.28 0.34 5 1137 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** CALL ICMLSPKG.ICMGETITEM(:1,: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,:28,:29,:30,:31,:32,:33) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.21 0.32 28 170 380 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.21 0.32 28 170 380 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT * FROM (SELECT K.KEYWORDNAME, K.KEYWORDDESCRIPTION, A.COMPONENTVIEWID, A.COMPONENTTYPEID,A.SEGMENTID,A.ITEMTYPEID,A.COMPONENTVIEWNAME, A.ACCESSMODULENAME,A.ACCESSMODULESTATUS,A.ACCESSMODULERESULT, A.ACCESSMODULEVERS,A.PREVACCESSMODULE,A.USERID,A.CREATED , D.COMPONENTVIEWID PARENTVIEWID FROM SVTLSADM.ICMSTNLSKEYWORDS K, SVTLSADM.ICMSTCOMPVIEWDEFS A, SVTLSADM.ICMSTCOMPDEFS B, SVTLSADM.ICMSTITVIEWID C, SVTLSADM.ICMSTCOMPVIEWDEFS D, SVTLSADM.ICMSTITVIEWID E WHERE A.COMPONENTTYPEID = B.COMPONENTTYPEID AND B.PARENTCOMPTYPEID = D.COMPONENTTYPEID AND A.COMPONENTVIEWID = C.COMPONENTVIEWID AND D.COMPONENTVIEWID = E.COMPONENTVIEWID AND C.ITEMTYPEVIEWID = E.ITEMTYPEVIEWID AND A.COMPONENTVIEWID = K.KEYWORDCODE AND K.KEYWORDCLASS = :"SYS_B_00" AND K.LANGUAGECODE = :"SYS_B_01" AND C.ITEMTYPEVIEWID > :"SYS_B_02" UNION SELECT K.KEYWORDNAME, K.KEYWORDDESCRIPTION, A.COMPONENTVIEWID,A.COMPONENTTYPEID,A.SEGMENTID, A.ITEMTYPEID,A.COMPONENTVIEWNAME,A.ACCESSMODULENAME,A.ACCESSMODULESTATUS, A.ACCESSMODULERESULT,A.ACCESSMODULEVERS,A.PREVACCESSMODULE,A.USERID, A.CREATED , B.PARENTCOMPTYPEID PARENTVIEWID FROM SVTLSADM.ICMSTNLSKEYWORDS K, SVTLSADM.ICMSTCOMPVIEWDEFS A, SVTLSADM.ICMSTCOMPDEFS B, SVTLSADM.ICMSTITVIEWID C WHERE B.PARENTCOMPTYPEID = :"SYS_B_03" AND B.COMPONENTTYPEID = A.COMPONENTTYPEID AND A.COMPONENTVIEWID = K.KEYWORDCODE AND K.KEYWORDCLASS = :"SYS_B_04" AND K.LANGUAGECODE = :"SYS_B_05" AND A.COMPONENTVIEWID = C.COMPONENTVIEWID AND C.ITEMTYPEVIEWID > :"SYS_B_06" UNION SELECT K.KEYWORDNAME, K.KEYWORDDESCRIPTION,A.COMPONENTVIEWID, A.COMPONENTTYPEID,A.SEGMENTID,A.ITEMTYPEID,A.COMPONENTVIEWNAME, A.ACCESSMODULENAME,A.ACCESSMODULESTATUS,A.ACCESSMODULERESULT, A.ACCESSMODULEVERS,A.PREVACCESSMODULE,A.USERID,A.CREATED , -:"SYS_B_07" PARENTVIEWID FROM SVTLSADM.ICMSTNLSKEYWORDS K, SVTLSADM.ICMSTCOMPVIEWDEFS A, SVTLSADM.ICMSTITVIEWID C WHERE A.COMPONENTVIEWID NOT IN (SELECT COMPONENTVIEWID FROM SVTLSADM.ICMSTITVIEWID) AND A.COMPONENTVIEWID = K.KEYWORDCODE AND K.KEYWORDCLASS = :"SYS_B_08" AND K.LANGUAGECODE = :"SYS_B_09" AND A.COMPONENTVIEWID = C.COMPONENTVIEWID AND C.ITEMTYPEVIEWID > :"SYS_B_10" ) U ORDER BY ITEMTYPEID ASC, COMPONENTTYPEID ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.05 0.04 0 0 0 0 Execute 1 0.10 0.10 0 0 0 0 Fetch 10 0.05 0.10 53 1144 0 248 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.20 0.24 53 1144 0 248 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 248 SORT ORDER BY (cr=1144 pr=53 pw=0 time=105095 us) 248 VIEW (cr=1144 pr=53 pw=0 time=104030 us) 248 SORT UNIQUE (cr=1144 pr=53 pw=0 time=103773 us) 248 UNION-ALL (cr=1144 pr=53 pw=0 time=59998 us) 171 NESTED LOOPS (cr=419 pr=41 pw=0 time=56813 us) 171 HASH JOIN (cr=75 pr=41 pw=0 time=53176 us) 249 INDEX FAST FULL SCAN ICMSXCOMPVIEWDEF2X (cr=7 pr=6 pw=0 time=14945 us)(object id 42887) 1130 HASH JOIN (cr=68 pr=35 pw=0 time=34639 us) 248 INDEX FAST FULL SCAN ICMSXITVIEW2U (cr=7 pr=6 pw=0 time=8356 us)(object id 42878) 248 HASH JOIN (cr=61 pr=29 pw=0 time=23226 us) 248 INDEX FAST FULL SCAN ICMSXITVIEW2U (cr=7 pr=0 pw=0 time=306 us)(object id 42878) 249 HASH JOIN (cr=54 pr=29 pw=0 time=18535 us) 242 TABLE ACCESS FULL ICMSTCOMPDEFS (cr=23 pr=0 pw=0 time=332 us) 249 TABLE ACCESS FULL ICMSTCOMPVIEWDEFS (cr=31 pr=29 pw=0 time=14088 us) 171 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=344 pr=0 pw=0 time=2079 us) 171 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=173 pr=0 pw=0 time=1165 us)(object id 42872) 77 NESTED LOOPS (cr=418 pr=5 pw=0 time=7784 us) 78 NESTED LOOPS (cr=338 pr=5 pw=0 time=8859 us) 78 NESTED LOOPS (cr=180 pr=5 pw=0 time=6798 us) 77 TABLE ACCESS FULL ICMSTCOMPDEFS (cr=23 pr=0 pw=0 time=945 us) 78 TABLE ACCESS BY INDEX ROWID ICMSTCOMPVIEWDEFS (cr=157 pr=5 pw=0 time=4584 us) 78 INDEX RANGE SCAN ICMSXCOMPVIEWDEF3X (cr=79 pr=5 pw=0 time=4017 us)(object id 42888) 78 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=158 pr=0 pw=0 time=1040 us) 78 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=80 pr=0 pw=0 time=558 us)(object id 42872) 77 INDEX RANGE SCAN ICMSXITVIEW2U (cr=80 pr=0 pw=0 time=863 us)(object id 42878) 0 HASH JOIN (cr=307 pr=7 pw=0 time=14286 us) 1 NESTED LOOPS ANTI (cr=300 pr=7 pw=0 time=13401 us) 249 HASH JOIN (cr=49 pr=2 pw=0 time=4166 us) 249 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=18 pr=2 pw=0 time=1531 us) 249 INDEX RANGE SCAN ICMSXNLSKEYWORDS1U (cr=9 pr=2 pw=0 time=278 us)(object id 42872) 249 TABLE ACCESS FULL ICMSTCOMPVIEWDEFS (cr=31 pr=0 pw=0 time=584 us) 248 INDEX UNIQUE SCAN ICMSXITVIEW1U (cr=251 pr=5 pw=0 time=9638 us)(object id 42877) 248 INDEX FAST FULL SCAN ICMSXITVIEW2U (cr=7 pr=0 pw=0 time=303 us)(object id 42878) ******************************************************************************** SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTYPE, A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS, A.LASTCHANGEDUSERID,A.RMCODE,A.SMSCOLLCODE,A.RESOURCELENGTH,A.MIMETYPEID, A.OBJECTUPDATED,A.RESOURCEFLAG,A.XDOCLASSID,A.EXTOBJECTNAME,A.TIEFLAG, A.OBJECTCREATED,A.ORIFNAME,A.CCSID,A.LANGUAGECODE,A.FORMAT,A.ATTR0000002124, A.ATTR0000002123,A.ATTR0000002132,A.ATTR0000002135,A.ATTR0000002137, A.ATTR0000002163,A.ICMMANAGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02418001 A LEFT OUTER JOIN SVTLSADM.ICMSTCHECKEDOUT B ON A.ITEMID = B.ITEMID WHERE ((A.VERSIONID=:"SYS_B_000" AND A.ITEMID IN (:"SYS_B_001",:"SYS_B_002",:"SYS_B_003",:"SYS_B_004",:"SYS_B_005", :"SYS_B_006",:"SYS_B_007",:"SYS_B_008",:"SYS_B_009",:"SYS_B_010", :"SYS_B_011",:"SYS_B_012",:"SYS_B_013",:"SYS_B_014",:"SYS_B_015", :"SYS_B_016",:"SYS_B_017",:"SYS_B_018",:"SYS_B_019",:"SYS_B_020", :"SYS_B_021",:"SYS_B_022",:"SYS_B_023",:"SYS_B_024",:"SYS_B_025", :"SYS_B_026",:"SYS_B_027",:"SYS_B_028",:"SYS_B_029",:"SYS_B_030", :"SYS_B_031",:"SYS_B_032",:"SYS_B_033",:"SYS_B_034",:"SYS_B_035", :"SYS_B_036",:"SYS_B_037",:"SYS_B_038",:"SYS_B_039",:"SYS_B_040", :"SYS_B_041",:"SYS_B_042",:"SYS_B_043",:"SYS_B_044",:"SYS_B_045", :"SYS_B_046",:"SYS_B_047",:"SYS_B_048",:"SYS_B_049",:"SYS_B_050", :"SYS_B_051",:"SYS_B_052",:"SYS_B_053",:"SYS_B_054",:"SYS_B_055", :"SYS_B_056",:"SYS_B_057",:"SYS_B_058",:"SYS_B_059",:"SYS_B_060", :"SYS_B_061",:"SYS_B_062",:"SYS_B_063",:"SYS_B_064",:"SYS_B_065", :"SYS_B_066",:"SYS_B_067",:"SYS_B_068",:"SYS_B_069",:"SYS_B_070", :"SYS_B_071",:"SYS_B_072",:"SYS_B_073",:"SYS_B_074",:"SYS_B_075", :"SYS_B_076",:"SYS_B_077",:"SYS_B_078",:"SYS_B_079",:"SYS_B_080", :"SYS_B_081",:"SYS_B_082",:"SYS_B_083",:"SYS_B_084",:"SYS_B_085", :"SYS_B_086",:"SYS_B_087",:"SYS_B_088",:"SYS_B_089",:"SYS_B_090", :"SYS_B_091",:"SYS_B_092",:"SYS_B_093",:"SYS_B_094"))) AND ((EXISTS (SELECT :"SYS_B_095" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_096" OR ICMC.ACL=-:"SYS_B_097") AND ICMC.UNUM = :"SYS_B_098" AND ICMC.RPRIV = :"SYS_B_099")) OR (EXISTS (SELECT :"SYS_B_100" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_101" OR ICMC.ACL=-:"SYS_B_102") AND ICMC.UNUM = :"SYS_B_103" AND ICMC.RPRIV = :"SYS_B_104") AND EXISTS (SELECT :"SYS_B_105" FROM SVTLSADM.ICMSTCOMPILEDPERM ICMP WHERE ICMP.UNUM = :"SYS_B_106" AND ICMP.PRIVDEFCODE = :"SYS_B_107"))) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.09 0.09 0 2 0 0 Fetch 4 0.00 0.00 4 294 0 94 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.09 0.09 4 296 0 94 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 94 FILTER (cr=296 pr=4 pw=0 time=7532 us) 94 NESTED LOOPS OUTER (cr=294 pr=4 pw=0 time=7406 us) 94 INLIST ITERATOR (cr=289 pr=3 pw=0 time=5987 us) 94 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=289 pr=3 pw=0 time=2694 us) 94 INDEX RANGE SCAN ICMUX024180011U (cr=195 pr=3 pw=0 time=1797 us)(object id 52526) 0 TABLE ACCESS BY INDEX ROWID ICMSTCHECKEDOUT (cr=5 pr=1 pw=0 time=620 us) 0 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=5 pr=1 pw=0 time=463 us)(object id 51956) 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=106 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=0 pw=0 time=74 us)(object id 42867) 0 INLIST ITERATOR (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=0 pr=0 pw=0 time=0 us)(object id 42867) 0 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=0 pr=0 pw=0 time=0 us)(object id 42868) ******************************************************************************** CALL ICMLSPKG.ICMSEARCH(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15, :16) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.09 0.09 0 20 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.09 0.09 0 20 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT ItemVersions_1.ITEMID, ItemVersions_1.COMPONENTID, ItemVersions_1.VERSIONID, ItemVersions_1.COMPONENTTYPEID, ItemVersions_1.ITEMTYPEID FROM ICMSVALLITEM001001 ItemVersions_1 WHERE (ItemVersions_1.ITEMID = :"SYS_B_00") AND ((( (ItemVersions_1.ITEMTYPEID IN (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B_42", :"SYS_B_43", :"SYS_B_44", :"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48", :"SYS_B_49", :"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61", :"SYS_B_62", :"SYS_B_63", :"SYS_B_64", :"SYS_B_65", :"SYS_B_66") AND (:"SYS_B_67"=:"SYS_B_68") ) OR (ItemVersions_1.ITEMTYPEID IN (:"SYS_B_69", :"SYS_B_70", :"SYS_B_71", :"SYS_B_72", :"SYS_B_73", :"SYS_B_74", :"SYS_B_75", :"SYS_B_76", :"SYS_B_77", :"SYS_B_78") AND (:"SYS_B_79"=:"SYS_B_80") ))))) T , ICMSTITEMS001001 I WHERE T.ITEMID = I.ITEMID AND T.VERSIONID = I.VERSIONID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.02 0.02 0 0 0 0 Execute 2 0.07 0.06 0 0 0 0 Fetch 2 0.00 0.03 14 48 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.09 0.12 14 48 0 2 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 VIEW (cr=24 pr=14 pw=0 time=29745 us) 1 HASH UNIQUE (cr=24 pr=14 pw=0 time=29734 us) 1 NESTED LOOPS (cr=24 pr=14 pw=0 time=28843 us) 1 VIEW ICMSVALLITEM001001 (cr=20 pr=14 pw=0 time=28790 us) 1 UNION-ALL (cr=20 pr=14 pw=0 time=28783 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=228 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=57 us)(object id 42677) 0 TABLE ACCESS FULL ICMSTITEMVER001001 (cr=16 pr=14 pw=0 time=28539 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=43 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=23 us)(object id 42677) ******************************************************************************** SELECT COMP.ITEMTYPEID, COMPATTR.COMPONENTVIEWID, COMPATTR.ATTRIBUTEID, COMPATTR.ATTRIBUTEGROUP, COMPATTR.ATTRIBUTEFLAGS, COMPATTR.SEQUENCENUM, COMPATTR.VIEWOPERATOR, COMPATTR.VIEWCOMPAREVALUE, ATTRS.ATTRFLAGS, ATTRS.MINIMUMVALUE, ATTRS.MAXIMUMVALUE, ATTRS.DEFAULTTYPE, ATTRS.DEFAULTVALUE, ITVIEWID.COMPONENTVIEWID FROM SVTLSADM.ICMSTCOMPVIEWATTRS COMPATTR, SVTLSADM.ICMSTCOMPDEFS COMP, SVTLSADM.ICMSTCOMPVIEWDEFS VIEWDEF, SVTLSADM.ICMSTCOMPATTRS ATTRS, SVTLSADM.ICMSTITVIEWID ITVIEWID WHERE COMPATTR.COMPONENTVIEWID = VIEWDEF.COMPONENTVIEWID AND VIEWDEF.COMPONENTTYPEID = COMP.COMPONENTTYPEID AND COMP.COMPONENTTYPEID = ATTRS.COMPONENTTYPEID AND COMPATTR.ATTRIBUTEID = ATTRS.ATTRIBUTEID AND COMPATTR.ATTRIBUTEGROUP = ATTRS.ATTRIBUTEGROUP AND VIEWDEF.COMPONENTVIEWID = ITVIEWID.COMPONENTVIEWID AND ITVIEWID.ITEMTYPEVIEWID > :"SYS_B_0" ORDER BY COMP.ITEMTYPEID ASC, COMPATTR.COMPONENTVIEWID ASC, COMPATTR.SEQUENCENUM ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.06 0.06 0 0 0 0 Fetch 163 0.05 0.06 0 212 0 4059 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 165 0.12 0.13 0 212 0 4059 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 4059 SORT ORDER BY (cr=212 pr=0 pw=0 time=59178 us) 4059 HASH JOIN (cr=212 pr=0 pw=0 time=42337 us) 4059 HASH JOIN (cr=205 pr=0 pw=0 time=33860 us) 3982 TABLE ACCESS FULL ICMSTCOMPATTRS (cr=107 pr=0 pw=0 time=123 us) 4059 HASH JOIN (cr=98 pr=0 pw=0 time=16444 us) 249 HASH JOIN (cr=14 pr=0 pw=0 time=4611 us) 242 INDEX FAST FULL SCAN ICMSXITEMCOMPDEF2X (cr=7 pr=0 pw=0 time=326 us)(object id 42880) 249 INDEX FAST FULL SCAN ICMSXCOMPVIEWDEF2X (cr=7 pr=0 pw=0 time=294 us)(object id 42887) 4059 TABLE ACCESS FULL ICMSTCOMPVIEWATTRS (cr=84 pr=0 pw=0 time=102 us) 248 INDEX FAST FULL SCAN ICMSXITVIEW2U (cr=7 pr=0 pw=0 time=99 us)(object id 42878) ******************************************************************************** SELECT COMP.ITEMTYPEID, COMPATTR.COMPONENTTYPEID,COMPATTR.ATTRIBUTEID, COMPATTR.ATTRIBUTEGROUP,COMPATTR.SEQUENCENUM,COMPATTR.ATTRFLAGS, COMPATTR.DEFAULTTYPE,COMPATTR.MINIMUMVALUE,COMPATTR.MAXIMUMVALUE, COMPATTR.DEFAULTVALUE , VIEWATTR.ATTRIBUTEFLAGS FROM SVTLSADM.ICMSTCOMPATTRS COMPATTR, SVTLSADM.ICMSTCOMPVIEWATTRS VIEWATTR, SVTLSADM.ICMSTCOMPDEFS COMP WHERE COMPATTR.COMPONENTTYPEID = COMP.COMPONENTTYPEID AND COMPATTR.COMPONENTTYPEID = VIEWATTR.COMPONENTVIEWID AND COMPATTR.ATTRIBUTEGROUP = VIEWATTR.ATTRIBUTEGROUP AND COMPATTR.ATTRIBUTEID = VIEWATTR.ATTRIBUTEID AND COMP.ITEMTYPEID > :"SYS_B_0" ORDER BY COMP.ITEMTYPEID ASC, COMP.COMPONENTTYPEID ASC, COMPATTR.SEQUENCENUM ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.04 0.03 0 0 0 0 Fetch 160 0.05 0.21 191 198 0 3982 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 162 0.09 0.25 191 198 0 3982 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 3982 SORT ORDER BY (cr=198 pr=191 pw=0 time=203725 us) 3982 HASH JOIN (cr=198 pr=191 pw=0 time=136636 us) 4059 TABLE ACCESS FULL ICMSTCOMPVIEWATTRS (cr=84 pr=81 pw=0 time=12948 us) 3982 HASH JOIN (cr=114 pr=110 pw=0 time=39370 us) 241 INDEX FAST FULL SCAN ICMSXITEMCOMPDEF2X (cr=7 pr=6 pw=0 time=15611 us)(object id 42880) 3982 TABLE ACCESS FULL ICMSTCOMPATTRS (cr=107 pr=104 pw=0 time=12451 us) ******************************************************************************** SELECT IDX.INDEXID, IDX.INDEXTYPE, IDX.COMPONENTTYPEID, IDX.INDEXNAME, IDX.COLUMNNAME, OPTS.NAME, OPTS.VALUE, OPTS.OPT_TYPE FROM SVTLSADM.ICMSTCOMPDEFS COMP, SVTLSADM.ICMSTTEXTINDEXES IDX FULL OUTER JOIN SVTLSADM.ICMSTTEXTINDEXOPTIONS OPTS ON IDX.INDEXID = OPTS.INDEXID WHERE COMP.COMPONENTTYPEID = IDX.COMPONENTTYPEID AND (OPTS.OPT_TYPE <> :"SYS_B_0" OR OPTS.OPT_TYPE IS NULL) AND COMP.ITEMTYPEID > :"SYS_B_1" ORDER BY IDX.INDEXID ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.03 0.02 0 0 0 0 Fetch 1 0.00 0.02 13 30 0 21 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.04 13 30 0 21 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 21 SORT ORDER BY (cr=30 pr=13 pw=0 time=21861 us) 21 HASH JOIN (cr=30 pr=13 pw=0 time=21616 us) 21 VIEW (cr=23 pr=13 pw=0 time=18304 us) 21 UNION-ALL (cr=23 pr=13 pw=0 time=18278 us) 21 FILTER (cr=14 pr=12 pw=0 time=18248 us) 21 HASH JOIN OUTER (cr=14 pr=12 pw=0 time=18157 us) 20 TABLE ACCESS FULL ICMSTTEXTINDEXES (cr=7 pr=6 pw=0 time=14625 us) 6 TABLE ACCESS FULL ICMSTTEXTINDEXOPTIONS (cr=7 pr=6 pw=0 time=1424 us) 0 NESTED LOOPS ANTI (cr=9 pr=1 pw=0 time=347 us) 6 TABLE ACCESS FULL ICMSTTEXTINDEXOPTIONS (cr=7 pr=0 pw=0 time=115 us) 5 INDEX UNIQUE SCAN SYS_C004622 (cr=2 pr=1 pw=0 time=165 us)(object id 42695) 241 INDEX FAST FULL SCAN ICMSXITEMCOMPDEF2X (cr=7 pr=0 pw=0 time=59 us)(object id 42880) ******************************************************************************** SELECT SOURCEITEMTYPEID,TARGETITEMTYPEID,DFLTRMCODE,DFLTCOLLCODE,DFLTACLCODE, DFLTPREFCHCOLLCODE,VERSIONCONTROL,ITEMTYPERELFLAG FROM SVTLSADM.ICMSTITEMTYPEREL WHERE SOURCEITEMTYPEID > :"SYS_B_0" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.03 0.02 0 0 0 0 Fetch 6 0.00 0.00 6 12 0 149 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.03 0.02 6 12 0 149 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 149 TABLE ACCESS FULL ICMSTITEMTYPEREL (cr=12 pr=6 pw=0 time=1491 us) ******************************************************************************** delete from ICMUT00204001 where (RTARGETITEMID=:b0 and VERSIONID=:b1) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.03 0.03 3 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.03 3 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE ICMUT00204001 (cr=6 pr=3 pw=0 time=418 us) 0 TABLE ACCESS BY INDEX ROWID ICMUT00204001 (cr=6 pr=3 pw=0 time=404 us) 0 INDEX RANGE SCAN ICMUX002040015X (cr=6 pr=3 pw=0 time=391 us)(object id 42941) ******************************************************************************** SELECT SOURCEITEMTYPEID,SOURCECOMPTYPEID,TARGETITEMTYPEID,TARGETCOMPTYPEID, LINKTYPE,ATTRIBUTEID,ATTRIBUTEGROUP, SEQUENCENUM FROM SVTLSADM.ICMSTITEMAUTOLINK WHERE TARGETITEMTYPEID > :"SYS_B_0" ORDER BY TARGETITEMTYPEID, TARGETCOMPTYPEID ASC, SOURCEITEMTYPEID ASC, SOURCECOMPTYPEID ASC, SEQUENCENUM ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 1 0.00 0.00 2 2 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.02 2 2 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 2 SORT ORDER BY (cr=2 pr=2 pw=0 time=341 us) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMAUTOLINK (cr=2 pr=2 pw=0 time=267 us) 2 INDEX RANGE SCAN ICMSXITEMAUTOLNK1X (cr=1 pr=1 pw=0 time=168 us)(object id 42894) ******************************************************************************** CALL ICMLSPKG.ICMGETITEMTYPE(:1,: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,:28,:29,:30,:31,:32) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.03 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.03 0 0 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT A.KEYWORDNAME, A.KEYWORDDESCRIPTION, B.COMPONENTTYPEID,B.ITEMTYPEID, B.PARENTCOMPTYPEID,B.CARDINALITYMIN,B.CARDINALITYMAX,B.DELETERULE, B.COMPTYPECLASS,B.USERID,B.CHANGED,B.CTOPTION FROM SVTLSADM.ICMSTNLSKEYWORDS A, SVTLSADM.ICMSTCOMPDEFS B WHERE B.ITEMTYPEID > :"SYS_B_0" AND B.COMPONENTTYPEID = A.KEYWORDCODE AND A.KEYWORDCLASS = :"SYS_B_1" AND A.LANGUAGECODE = :"SYS_B_2" ORDER BY ITEMTYPEID ASC, COMPONENTTYPEID ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.02 0 0 0 0 Fetch 10 0.00 0.07 40 41 0 241 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.02 0.10 40 41 0 241 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 241 SORT ORDER BY (cr=41 pr=40 pw=0 time=77472 us) 241 HASH JOIN (cr=41 pr=40 pw=0 time=52759 us) 242 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=18 pr=19 pw=0 time=17354 us) 242 INDEX RANGE SCAN ICMSXNLSKEYWORDS1U (cr=9 pr=19 pw=0 time=15404 us)(object id 42872) 241 TABLE ACCESS FULL ICMSTCOMPDEFS (cr=23 pr=21 pw=0 time=14502 us) ******************************************************************************** SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTYPE, A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS, A.LASTCHANGEDUSERID,A.ATTR0000002084,A.ATTR0000002085,A.ATTR0000002086, A.ATTR0000002103,A.ATTR0000002206,A.ICMMANAGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02427001 A LEFT OUTER JOIN SVTLSADM.ICMSTCHECKEDOUT B ON A.ITEMID = B.ITEMID WHERE ((A.VERSIONID=:"SYS_B_00" AND A.ITEMID IN (:"SYS_B_01"))) AND ((EXISTS (SELECT :"SYS_B_02" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_03" OR ICMC.ACL=-:"SYS_B_04") AND ICMC.UNUM = :"SYS_B_05" AND ICMC.RPRIV = :"SYS_B_06")) OR (EXISTS (SELECT :"SYS_B_07" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_08" OR ICMC.ACL=-:"SYS_B_09") AND ICMC.UNUM = :"SYS_B_10" AND ICMC.RPRIV = :"SYS_B_11") AND EXISTS (SELECT :"SYS_B_12" FROM SVTLSADM.ICMSTCOMPILEDPERM ICMP WHERE ICMP.UNUM = :"SYS_B_13" AND ICMP.PRIVDEFCODE = :"SYS_B_14"))) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.02 0.01 0 6 0 0 Fetch 3 0.00 0.00 3 12 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.02 0.02 3 18 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=6 pr=3 pw=0 time=471 us) 1 NESTED LOOPS OUTER (cr=4 pr=3 pw=0 time=363 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02427001 (cr=3 pr=3 pw=0 time=334 us) 1 INDEX UNIQUE SCAN ICMUX024270011U (cr=2 pr=2 pw=0 time=234 us)(object id 54028) 0 TABLE ACCESS BY INDEX ROWID ICMSTCHECKEDOUT (cr=1 pr=0 pw=0 time=20 us) 0 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=1 pr=0 pw=0 time=15 us)(object id 51956) 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=85 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=0 pw=0 time=62 us)(object id 42867) 0 INLIST ITERATOR (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=0 pr=0 pw=0 time=0 us)(object id 42867) 0 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=0 pr=0 pw=0 time=0 us)(object id 42868) ******************************************************************************** SELECT ITEMID, VERSIONID FROM ICMSTITEMS001001 WHERE ITEMID IN (:"SYS_B_00",:"SYS_B_01",:"SYS_B_02", :"SYS_B_03",:"SYS_B_04",:"SYS_B_05",:"SYS_B_06",:"SYS_B_07",:"SYS_B_08", :"SYS_B_09",:"SYS_B_10",:"SYS_B_11",:"SYS_B_12",:"SYS_B_13",:"SYS_B_14", :"SYS_B_15",:"SYS_B_16",:"SYS_B_17",:"SYS_B_18",:"SYS_B_19",:"SYS_B_20", :"SYS_B_21",:"SYS_B_22",:"SYS_B_23",:"SYS_B_24",:"SYS_B_25",:"SYS_B_26", :"SYS_B_27",:"SYS_B_28",:"SYS_B_29",:"SYS_B_30",:"SYS_B_31",:"SYS_B_32", :"SYS_B_33",:"SYS_B_34",:"SYS_B_35",:"SYS_B_36",:"SYS_B_37",:"SYS_B_38", :"SYS_B_39",:"SYS_B_40",:"SYS_B_41",:"SYS_B_42",:"SYS_B_43",:"SYS_B_44", :"SYS_B_45",:"SYS_B_46",:"SYS_B_47",:"SYS_B_48",:"SYS_B_49",:"SYS_B_50", :"SYS_B_51",:"SYS_B_52",:"SYS_B_53",:"SYS_B_54",:"SYS_B_55",:"SYS_B_56", :"SYS_B_57",:"SYS_B_58",:"SYS_B_59",:"SYS_B_60",:"SYS_B_61",:"SYS_B_62", :"SYS_B_63",:"SYS_B_64",:"SYS_B_65",:"SYS_B_66",:"SYS_B_67",:"SYS_B_68", :"SYS_B_69",:"SYS_B_70",:"SYS_B_71",:"SYS_B_72",:"SYS_B_73",:"SYS_B_74", :"SYS_B_75",:"SYS_B_76",:"SYS_B_77",:"SYS_B_78",:"SYS_B_79",:"SYS_B_80", :"SYS_B_81",:"SYS_B_82",:"SYS_B_83",:"SYS_B_84",:"SYS_B_85",:"SYS_B_86", :"SYS_B_87",:"SYS_B_88",:"SYS_B_89",:"SYS_B_90",:"SYS_B_91",:"SYS_B_92", :"SYS_B_93") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 48 0.01 0.17 142 425 0 94 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 50 0.03 0.18 142 425 0 94 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 94 INLIST ITERATOR (cr=425 pr=142 pw=0 time=640 us) 94 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=425 pr=142 pw=0 time=170105 us) 94 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=331 pr=142 pw=0 time=169754 us)(object id 42895) ******************************************************************************** select RS.FROMWNITEMID from ICMUT00200001 PR ,ICMUT00201001 RS ,ICMUT00202001 WN where ((((((PR.ITEMID= :b0 and PR.VERSIONID=:"SYS_B_0") and PR.COMPONENTID=RS.PARENTCOMPID) and RS.VERSIONID=:"SYS_B_1") and WN.ITEMID=RS.FROMWNITEMID) and WN.VERSIONID= :"SYS_B_2") and (((WN.WORKNODETYPE=:"SYS_B_3" or WN.WORKNODETYPE=:"SYS_B_4") or WN.WORKNODETYPE=:"SYS_B_5") or WN.WORKNODETYPE=:"SYS_B_6")) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.02 0.01 0 0 0 0 Fetch 2 0.00 0.00 2 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.02 0.01 2 4 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=4 pr=2 pw=0 time=295 us) 0 NESTED LOOPS (cr=4 pr=2 pw=0 time=287 us) 0 INDEX RANGE SCAN ICMUX002000012U (cr=4 pr=2 pw=0 time=282 us)(object id 42922) 0 TABLE ACCESS BY INDEX ROWID ICMUT00201001 (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN ICMUX002010013X (cr=0 pr=0 pw=0 time=0 us)(object id 42924) 0 TABLE ACCESS BY INDEX ROWID ICMUT00202001 (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN SYS_C004754 (cr=0 pr=0 pw=0 time=0 us)(object id 42742) ******************************************************************************** delete from ICMSTITEMS001001 where (ITEMID=:b0 and VERSIONID=:b1) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.02 0.00 14 8 33 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.00 14 8 33 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE ICMSTITEMS001001 (cr=4 pr=9 pw=0 time=1237 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=80 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=53 us)(object id 42677) ******************************************************************************** CALL ICMLSPKG.ICMLOGON(:1,: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,:28,:29,:30,:31) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.10 0 28 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.10 0 28 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT A.KEYWORDNAME, A.KEYWORDDESCRIPTION, B.ITEMTYPEID,B.ITEMTYPECLASS, B.ITEMLEVELACLFLAG,B.ITEMTYPEACLCODE,B.DFLTRMCODE,B.DFLTCOLLCODE, B.DFLTPREFCHCOLLCODE,B.DFLTRETENTIONUNIT,B.DFLTITEMRETENTION, B.DFLTXDOCLASSID,B.AUTOLINKENABLE,B.AUTOLINKSMS,B.SEGMENTID, B.SEGMENTTHRESHOLD,B.PARTITIONID,B.PARTITIONTHRESHOLD,B.VERSIONCONTROL, B.VERSIONMAX,B.ITEMEVENTFLAG,B.USERID,B.CHANGED,B.PROCESSNAME, B.DFLTPRIORITY,B.ITEMTYPEFLAG FROM SVTLSADM.ICMSTNLSKEYWORDS A, SVTLSADM.ICMSTITEMTYPEDEFS B WHERE B.ITEMTYPEID > :"SYS_B_0" AND B.ITEMTYPEID = A.KEYWORDCODE AND A.KEYWORDCLASS = :"SYS_B_1" AND A.LANGUAGECODE = :"SYS_B_2" ORDER BY ITEMTYPEID ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.01 0.02 0 0 0 0 Fetch 4 0.00 0.05 27 33 0 76 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.02 0.07 27 33 0 76 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 76 MERGE JOIN (cr=33 pr=27 pw=0 time=37166 us) 76 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=17 pr=13 pw=0 time=3128 us) 76 INDEX RANGE SCAN ICMSXNLSKEYWORDS1U (cr=7 pr=3 pw=0 time=706 us)(object id 42872) 76 SORT JOIN (cr=16 pr=14 pw=0 time=33485 us) 76 TABLE ACCESS FULL ICMSTITEMTYPEDEFS (cr=16 pr=14 pw=0 time=16397 us) ******************************************************************************** SELECT ITVIEWDEFS.ITEMTYPEID, ITVIEWDEFS.ITEMTYPEVIEWID, ITVIEWIDS.COMPONENTVIEWID, ITVIEWDEFS.ACLCODE, ITVIEWDEFS.USERID, ITVIEWDEFS.CREATED FROM SVTLSADM.ICMSTITVIEWDEFS ITVIEWDEFS, SVTLSADM.ICMSTITVIEWID ITVIEWIDS WHERE ITVIEWDEFS.ITEMTYPEVIEWID = ITVIEWIDS.ITEMTYPEVIEWID AND ITVIEWDEFS.ITEMTYPEVIEWID > :"SYS_B_0" ORDER BY ITVIEWDEFS.ITEMTYPEID ASC, ITVIEWDEFS.ITEMTYPEVIEWID ASC, ITVIEWIDS.COMPONENTVIEWID ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 14 0 248 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.01 0 14 0 248 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 248 SORT ORDER BY (cr=14 pr=0 pw=0 time=3203 us) 248 HASH JOIN (cr=14 pr=0 pw=0 time=2999 us) 77 TABLE ACCESS FULL ICMSTITVIEWDEFS (cr=7 pr=0 pw=0 time=266 us) 248 INDEX FAST FULL SCAN ICMSXITVIEW2U (cr=7 pr=0 pw=0 time=57 us)(object id 42878) ******************************************************************************** SELECT FORKEYS.SOURCECOMPTYPEID,FORKEYS.SRCATTRIBUTEID,FORKEYS.SRCATTRGROUPID, FORKEYS.COLUMNSEQ,FORKEYS.TARGETCOMPTYPEID,FORKEYS.TARGETATTRIBUTEID, FORKEYS.TARGETATTRGROUPID,FORKEYS.COLUMNNAME,FORKEYS.DELETERULE, FORKEYS.UPDATERULE,FORKEYS.CONSTRAINTNAME,FORKEYS.TABSCHEMA, FORKEYS.TARGETTBLNAME,FORKEYS.FKATTRFLAGS FROM SVTLSADM.ICMSTCOMPATTRSFK FORKEYS, SVTLSADM.ICMSTCOMPDEFS COMP WHERE COMP.COMPONENTTYPEID = FORKEYS.SOURCECOMPTYPEID AND COMP.ITEMTYPEID > :"SYS_B_0" ORDER BY FORKEYS.SOURCECOMPTYPEID ASC, FORKEYS.CONSTRAINTNAME ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.02 0 0 0 0 Fetch 3 0.01 0.01 6 14 0 70 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.02 0.03 6 14 0 70 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 70 SORT ORDER BY (cr=14 pr=6 pw=0 time=15790 us) 70 HASH JOIN (cr=14 pr=6 pw=0 time=15448 us) 70 TABLE ACCESS FULL ICMSTCOMPATTRSFK (cr=7 pr=6 pw=0 time=13221 us) 241 INDEX FAST FULL SCAN ICMSXITEMCOMPDEF2X (cr=7 pr=0 pw=0 time=57 us)(object id 42880) ******************************************************************************** SELECT RMCODE FROM SVTLSADM.ICMUT02418001 WHERE ITEMID = :x AND VERSIONID= :x call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 98 0.00 0.00 0 0 0 0 Execute 98 0.01 0.00 0 0 0 0 Fetch 98 0.01 0.04 162 294 0 98 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 294 0.02 0.05 162 294 0 98 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=3 pr=6 pw=0 time=516 us) 1 INDEX UNIQUE SCAN ICMUX024180011U (cr=2 pr=5 pw=0 time=421 us)(object id 52526) ******************************************************************************** SELECT VIEWACCESSINFO, ACLSUBSELECT, TO_CHAR(LASTCHANGEDTS, :"SYS_B_0") FROM ICMSTVIEWACCESS WHERE COMPONENTVIEWID=:h1 AND SEGMENTID=:h2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.01 0.00 0 0 0 0 Execute 10 0.01 0.01 0 0 0 0 Fetch 10 0.00 0.01 8 36 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.02 0.02 8 36 0 10 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTVIEWACCESS (cr=4 pr=7 pw=0 time=11200 us) 1 INDEX UNIQUE SCAN SYS_C004661 (cr=2 pr=5 pw=0 time=11009 us)(object id 42708) ******************************************************************************** CALL ICMLSPKG.ICMLISTCOLL(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT SS_FLD_5_1.ITEMID, SS_FLD_5_1.COMPONENTID, SS_FLD_5_1.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID FROM ICMUT02418001 SS_FLD_5_1 WHERE (SS_FLD_5_1.ATTR0000002124 Like :"SYS_B_2") AND (((( (:"SYS_B_3"=:"SYS_B_4") ))))) T , ICMSTITEMS001001 I WHERE T.ITEMID = I.ITEMID AND T.VERSIONID = I.VERSIONID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.04 0.04 0 0 0 0 Execute 1 0.01 0.01 0 0 0 0 Fetch 4 0.03 0.23 257 302 0 94 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.08 0.28 257 302 0 94 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 94 NESTED LOOPS (cr=302 pr=257 pw=0 time=23032 us) 94 VIEW (cr=15 pr=17 pw=0 time=8543 us) 94 FILTER (cr=15 pr=17 pw=0 time=8354 us) 94 INDEX RANGE SCAN SS_FLD_5_IDXNU (cr=15 pr=17 pw=0 time=533 us)(object id 54079) 94 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=287 pr=240 pw=0 time=231619 us) 94 INDEX UNIQUE SCAN SYS_C004557 (cr=193 pr=100 pw=0 time=88611 us)(object id 42677) ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT GPSFolder_1.ITEMID, GPSFolder_1.COMPONENTID, GPSFolder_1.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID FROM ICMUT02427001 GPSFolder_1 WHERE (GPSFolder_1.ATTR0000002084 = :"SYS_B_2") AND (((( (:"SYS_B_3"=:"SYS_B_4") ))))) T call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.02 0.02 0 0 0 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 3 0.00 0.00 3 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.03 0.02 3 9 0 3 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 VIEW (cr=3 pr=3 pw=0 time=332 us) 1 FILTER (cr=3 pr=3 pw=0 time=325 us) 1 INDEX RANGE SCAN ICMUX02427001001U (cr=3 pr=3 pw=0 time=316 us)(object id 54029) ******************************************************************************** SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTYPE, A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS, A.LASTCHANGEDUSERID,A.RMCODE,A.SMSCOLLCODE,A.RESOURCELENGTH,A.MIMETYPEID, A.OBJECTUPDATED,A.RESOURCEFLAG,A.XDOCLASSID,A.EXTOBJECTNAME,A.TIEFLAG, A.OBJECTCREATED,A.ORIFNAME,A.CCSID,A.LANGUAGECODE,A.FORMAT,A.ATTR0000002124, A.ATTR0000002123,A.ATTR0000002132,A.ATTR0000002135,A.ATTR0000002137, A.ATTR0000002163,A.ICMMANAGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02418001 A LEFT OUTER JOIN SVTLSADM.ICMSTCHECKEDOUT B ON A.ITEMID = B.ITEMID WHERE ((A.VERSIONID=:"SYS_B_00" AND A.ITEMID IN (:"SYS_B_01"))) AND ((EXISTS (SELECT :"SYS_B_02" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_03" OR ICMC.ACL=-:"SYS_B_04") AND ICMC.UNUM = :"SYS_B_05" AND ICMC.RPRIV = :"SYS_B_06")) OR (EXISTS (SELECT :"SYS_B_07" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_08" OR ICMC.ACL=-:"SYS_B_09") AND ICMC.UNUM = :"SYS_B_10" AND ICMC.RPRIV = :"SYS_B_11") AND EXISTS (SELECT :"SYS_B_12" FROM SVTLSADM.ICMSTCOMPILEDPERM ICMP WHERE ICMP.UNUM = :"SYS_B_13" AND ICMP.PRIVDEFCODE = :"SYS_B_14"))) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.01 0.01 0 8 0 0 Fetch 4 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.01 0 24 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=6 pr=0 pw=0 time=215 us) 1 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=96 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=3 pr=0 pw=0 time=71 us) 1 INDEX UNIQUE SCAN ICMUX024180011U (cr=2 pr=0 pw=0 time=35 us)(object id 52526) 0 TABLE ACCESS BY INDEX ROWID ICMSTCHECKEDOUT (cr=1 pr=0 pw=0 time=17 us) 0 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=1 pr=0 pw=0 time=12 us)(object id 51956) 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=100 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=0 pw=0 time=70 us)(object id 42867) 0 INLIST ITERATOR (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=0 pr=0 pw=0 time=0 us)(object id 42867) 0 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=0 pr=0 pw=0 time=0 us)(object id 42868) ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT GPSCpDocs1559_5.ITEMID, GPSCpDocs1559_5.COMPONENTID, GPSCpDocs1559_5.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID FROM ICMUT02418001 SS_FLD_5_1, ICMUT02419001 GPSCpDocs1559_5 WHERE ((SS_FLD_5_1.ITEMID = :"SYS_B_2") AND ((SS_FLD_5_1.COMPONENTID = GPSCpDocs1559_5.PARENTCOMPID) AND (SS_FLD_5_1.VERSIONID = GPSCpDocs1559_5.VERSIONID))) AND (((( (:"SYS_B_3"=:"SYS_B_4") ))))) T call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.02 0.01 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.01 0.01 6 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.04 0.04 6 6 0 0 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 0 VIEW (cr=3 pr=6 pw=0 time=13512 us) 0 HASH UNIQUE (cr=3 pr=6 pw=0 time=13507 us) 0 FILTER (cr=3 pr=6 pw=0 time=13316 us) 0 NESTED LOOPS (cr=3 pr=6 pw=0 time=13308 us) 0 VIEW index$_join$_003 (cr=3 pr=6 pw=0 time=13302 us) 0 HASH JOIN (cr=3 pr=6 pw=0 time=13297 us) 0 HASH JOIN (cr=3 pr=6 pw=0 time=12358 us) 0 INDEX FAST FULL SCAN ICMUX024190012X (cr=3 pr=6 pw=0 time=10960 us)(object id 52531) 0 INDEX FAST FULL SCAN ICMUX024190013X (cr=0 pr=0 pw=0 time=0 us)(object id 52532) 0 INDEX FAST FULL SCAN SYS_C0026825 (cr=0 pr=0 pw=0 time=0 us)(object id 52530) 0 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN SYS_C0026814 (cr=0 pr=0 pw=0 time=0 us)(object id 52525) ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT References_5.SOURCEITEMID AS ITEMID, References_5.SOURCECOMPID AS COMPONENTID, References_5.SOURCEVERSIONID AS VERSIONID, References_5.SOURCECOMPTYPEID AS COMPONENTTYPEID, References_5.SOURCEITEMTYPEID AS ITEMTYPEID FROM ICMUT02418001 SS_FLD_5_1, ICMSTRI001001 References_5 WHERE (((SS_FLD_5_1.ITEMID = :"SYS_B_00") AND ((SS_FLD_5_1.ITEMID = References_5.TARGETITEMID) AND (SS_FLD_5_1.VERSIONID = References_5.TARGETVERSIONID))) AND (((( (:"SYS_B_01"=:"SYS_B_02") ))))) AND ((( (References_5.SOURCEITEMTYPEID IN (:"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B_42", :"SYS_B_43", :"SYS_B_44", :"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48", :"SYS_B_49", :"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61", :"SYS_B_62", :"SYS_B_63", :"SYS_B_64", :"SYS_B_65", :"SYS_B_66", :"SYS_B_67", :"SYS_B_68") AND (:"SYS_B_69"= :"SYS_B_70") ) OR (References_5.SOURCEITEMTYPEID IN (:"SYS_B_71", :"SYS_B_72", :"SYS_B_73", :"SYS_B_74", :"SYS_B_75", :"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79", :"SYS_B_80") AND (:"SYS_B_81"= :"SYS_B_82") ))))) T call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.01 0 0 0 0 Execute 1 0.01 0.01 0 0 0 0 Fetch 1 0.00 0.00 3 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.04 0.04 3 3 0 0 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 0 VIEW (cr=3 pr=3 pw=0 time=6614 us) 0 HASH UNIQUE (cr=3 pr=3 pw=0 time=6608 us) 0 FILTER (cr=3 pr=3 pw=0 time=6444 us) 0 NESTED LOOPS (cr=3 pr=3 pw=0 time=6438 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=3 pr=3 pw=0 time=6434 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=3 pw=0 time=6429 us)(object id 42916) 0 INDEX UNIQUE SCAN ICMUX024180011U (cr=0 pr=0 pw=0 time=0 us)(object id 52526) ******************************************************************************** SELECT DISTINCT A.ITEMTYPEVIEWID, A.ITEMTYPEID, C.PRIVS FROM SVTLSADM.ICMSTITVIEWDEFS A, SVTLSADM.ICMSTCOMPILEDACL C WHERE ( C.ACL = -:"SYS_B_0" AND C.UNUM = :x ) ORDER BY :"SYS_B_1" ASC, :"SYS_B_2" ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 40 0.00 0.02 11 9 0 77 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.03 0.04 11 9 0 77 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 77 SORT UNIQUE (cr=9 pr=11 pw=0 time=20189 us) 77 MERGE JOIN CARTESIAN (cr=9 pr=11 pw=0 time=20110 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=5 pw=0 time=1568 us)(object id 42867) 77 BUFFER SORT (cr=7 pr=6 pw=0 time=18466 us) 77 TABLE ACCESS FULL ICMSTITVIEWDEFS (cr=7 pr=6 pw=0 time=18099 us) ******************************************************************************** select PRIVS from ICMSTCOMPILEDACL where ((ACL=:b0 or ACL=(-:"SYS_B_0")) and UNUM=:b1) union select PRIVS from ICMSTCOMPILEDACL where (((ACL=:b0 or ACL=(-:"SYS_B_1")) and UNUM=:"SYS_B_2") and exists (select :"SYS_B_3" from ICMSTCOMPILEDPERM where (UNUM=:b1 and PRIVDEFCODE=:b4))) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.01 0.00 0 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.02 0.00 0 12 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT UNIQUE (cr=12 pr=0 pw=0 time=577 us) 3 UNION-ALL (cr=12 pr=0 pw=0 time=344 us) 2 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=4 pr=0 pw=0 time=208 us)(object id 42867) 1 FILTER (cr=8 pr=0 pw=0 time=121 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=4 pr=0 pw=0 time=70 us)(object id 42867) 2 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=4 pr=0 pw=0 time=39 us)(object id 42868) ******************************************************************************** insert into ICMSTCHECKEDOUT (ITEMID,USERID,GROUPID,CREATED) values (:b0,:b1,:"SYS_B_0",SYS_EXTRACT_UTC(SYSTIMESTAMP)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 6 1 22 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 6 1 22 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) ******************************************************************************** SELECT COMPONENTID FROM SVTLSADM.ICMUT02418001 WHERE ITEMID = :h1 AND VERSIONID = :h2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=3 pr=0 pw=0 time=52 us) 1 INDEX UNIQUE SCAN ICMUX024180011U (cr=2 pr=0 pw=0 time=32 us)(object id 52526) ******************************************************************************** delete from ICMSTRI001001 where (((SOURCEITEMID=:b0 and SOURCECOMPTYPEID=:b1) and SOURCECOMPID=:b2) and SOURCEVERSIONID=:b3) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 3 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 3 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE ICMSTRI001001 (cr=6 pr=3 pw=0 time=395 us) 0 INDEX RANGE SCAN ICMSTRI001001S (cr=6 pr=3 pw=0 time=385 us)(object id 42915) ******************************************************************************** select R.SOURCEITEMID ,R.SOURCECOMPTYPEID ,R.SOURCECOMPID ,R.SOURCEVERSIONID , F.DELETERULE ,F.SRCATTRGROUPID ,C.CARDINALITYMIN ,C.PARENTCOMPTYPEID , I.ITEMTYPECLASS from ICMSTRI001001 R ,ICMSTCOMPATTRSFK F ,ICMSTCOMPDEFS C ,ICMSTITEMTYPEDEFS I where (((((((R.TARGETITEMID=:b0 and R.TARGETCOMPTYPEID=:b1) and R.TARGETCOMPID=:b2) and R.TARGETVERSIONID=:b3) and F.COLUMNNAME=:"SYS_B_0") and R.SOURCECOMPTYPEID=F.SOURCECOMPTYPEID) and R.SOURCECOMPTYPEID= C.COMPONENTTYPEID) and C.ITEMTYPEID=I.ITEMTYPEID) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.01 0 6 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=161 us) 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=152 us) 0 NESTED LOOPS (cr=6 pr=0 pw=0 time=149 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=6 pr=0 pw=0 time=142 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=6 pr=0 pw=0 time=127 us)(object id 42916) 0 TABLE ACCESS BY INDEX ROWID ICMSTCOMPATTRSFK (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN ICMSXCOMPATTRSFK2X (cr=0 pr=0 pw=0 time=0 us)(object id 42886) 0 TABLE ACCESS BY INDEX ROWID ICMSTCOMPDEFS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN SYS_C004491 (cr=0 pr=0 pw=0 time=0 us)(object id 42669) 0 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN SYS_C004469 (cr=0 pr=0 pw=0 time=0 us)(object id 42664) ******************************************************************************** delete from ICMSTCHECKEDOUT where ITEMID=:b0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 2 22 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 2 22 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 DELETE ICMSTCHECKEDOUT (cr=2 pr=0 pw=0 time=687 us) 2 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=2 pr=0 pw=0 time=68 us)(object id 51956) ******************************************************************************** ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '-05:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '$' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 40 (recursive depth: 1) ******************************************************************************** ALTER SESSION SET CURRENT_SCHEMA=SVTLSADM call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 40 ******************************************************************************** ALTER SESSION SET EVENTS '10498 trace name context forever, level 1' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 40 (recursive depth: 2) ******************************************************************************** SELECT PRIVDEFCODE FROM SVTLSADM.ICMSTPRIVSETS WHERE PRIVSETCODE = :"SYS_B_0" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 5 0 83 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 5 0 83 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 83 INDEX RANGE SCAN ICMSXPRIVSETS1U (cr=5 pr=0 pw=0 time=238 us)(object id 42848) ******************************************************************************** SELECT LIBRARYSERVERID,LANGUAGECODE,SYSSEGMENTID,SYSSEGMENTTHRESHLD, ACLBINDINGLEVEL,LIBRARYACLCODE,PUBACCESSENABLED,DFLTACLCHOICE,SMSCHOICE, TRACELEVEL,MAXUSERS,MAXUSERACTION,CURRENTUSERS,MAXLOGONRETRY, PASSWORDDURATION,SYSADMINEVENTFLAG,DATABASETYPE,MAXTXDURATION, ALLOWTRUSTEDLOGON,DOCROUTINGUPDATE,DOCROUTINGFREQ,TIEUSERID,DATABASENAME, DBSCHEMANAME,TRACEFILENAME,SYSTIMEOUT,LSCURRENTVERSION,TRACEUSER, MULTIPLETRACEFILES,MAXTRACEFILESIZE,SYSTEMFLAG2,RECORDSMANAGERHOST FROM SVTLSADM.ICMSTSYSCONTROL WHERE LIBRARYSERVERID =:"SYS_B_0" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTSYSCONTROL (cr=2 pr=0 pw=0 time=55 us) 1 INDEX UNIQUE SCAN SYS_C004411 (cr=1 pr=0 pw=0 time=22 us)(object id 42652) ******************************************************************************** SELECT A.RMCODE, A.SMSCOLLCODE, RESOURCEFLAG, RMFLAGS FROM SVTLSADM.ICMUT02418001 A, SVTLSADM.ICMSTRESOURCEMGR B WHERE A.RMCODE = B.RMCODE AND A.ITEMID = :x AND A.VERSIONID= :x call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 98 0.01 0.00 0 0 0 0 Execute 98 0.00 0.00 0 0 0 0 Fetch 98 0.01 0.00 1 392 0 98 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 294 0.02 0.01 1 392 0 98 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=4 pr=1 pw=0 time=226 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=3 pr=0 pw=0 time=50 us) 1 INDEX UNIQUE SCAN ICMUX024180011U (cr=2 pr=0 pw=0 time=30 us)(object id 52526) 1 INDEX RANGE SCAN ICMSXRESOURCEMGR3U (cr=1 pr=1 pw=0 time=168 us)(object id 42854) ******************************************************************************** CALL ICMLSPKG.ICMLISTRESOURCEMGR(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** SELECT R.RMCODE, R.RMPLATFORM, A.PORT, RTRIM(R.USERID), R.CHANGED, R.RMFLAGS, R.RMNAME, R.INETADDR, R.TOKENDURATION, R.DOMAINID, RTRIM(R.RMUSERID), R.RMPASSWORD, A.RMACCESSTYPE, K.KEYWORDNAME, K.KEYWORDDESCRIPTION, A.ACCESSDATA, R.CURRENTVERSION, R.CACHEOBJSIZELIMIT FROM SVTLSADM.ICMSTRESOURCEMGR R, SVTLSADM.ICMSTRMACCESSTYPES A, SVTLSADM.ICMSTNLSKEYWORDS K WHERE R.RMCODE = A.RMCODE AND A.RMACCESSTYPE = K.KEYWORDCODE AND A.RMACCESSTYPE > :"SYS_B_0" AND K.LANGUAGECODE = :"SYS_B_1" AND K.KEYWORDCLASS = :"SYS_B_2" AND R.RMCODE = :"SYS_B_3" ORDER BY A.RMACCESSTYPE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 10 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS (cr=10 pr=0 pw=0 time=212 us) 2 NESTED LOOPS (cr=4 pr=0 pw=0 time=144 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTRESOURCEMGR (cr=2 pr=0 pw=0 time=68 us) 1 INDEX UNIQUE SCAN SYS_C004327 (cr=1 pr=0 pw=0 time=36 us)(object id 42642) 2 TABLE ACCESS BY INDEX ROWID ICMSTRMACCESSTYPES (cr=2 pr=0 pw=0 time=72 us) 2 INDEX RANGE SCAN SYS_C004595 (cr=1 pr=0 pw=0 time=45 us)(object id 42684) 2 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=6 pr=0 pw=0 time=59 us) 2 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=4 pr=0 pw=0 time=41 us)(object id 42872) ******************************************************************************** SELECT RMCODE, SMSCOLLCODE, USERID, CREATED, PREFETCHIND, DOMAINID, SMSCOLLNAME FROM ICMSTCOLLNAME WHERE RMCODE = :"SYS_B_0" AND SMSCOLLCODE = :"SYS_B_1" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTCOLLNAME (cr=2 pr=0 pw=0 time=52 us) 1 INDEX UNIQUE SCAN SYS_C004336 (cr=1 pr=0 pw=0 time=28 us)(object id 42644) ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQueue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID, GPSQueue_1.CREATETS AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE ((GPSQueue_1.ATTR0000002084 like :"SYS_B_2") and (GPSQueue_1.ATTR0000002086 like :"SYS_B_3")) AND (((( (:"SYS_B_4"= :"SYS_B_5") )))))) T ORDER BY Exp_1 ASC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 5 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.04 5 2 0 0 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=2 pr=5 pw=0 time=12824 us) 0 VIEW (cr=2 pr=5 pw=0 time=12786 us) 0 FILTER (cr=2 pr=5 pw=0 time=12781 us) 0 TABLE ACCESS BY INDEX ROWID ICMUT02428001 (cr=2 pr=5 pw=0 time=12775 us) 0 INDEX RANGE SCAN GPSQUEUENORMIDXNU (cr=2 pr=5 pw=0 time=12769 us)(object id 54048) ******************************************************************************** SELECT COMPONENTID FROM SVTLSADM.ICMUT02427001 WHERE ITEMID = :h1 AND VERSIONID = :h2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMUT02427001 (cr=3 pr=0 pw=0 time=66 us) 1 INDEX UNIQUE SCAN ICMUX024270011U (cr=2 pr=0 pw=0 time=42 us)(object id 54028) ******************************************************************************** SELECT COMPONENTID FROM SVTLSADM.ICMUT02419001 WHERE ITEMID = :h1 AND VERSIONID = :h2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ICMUT02419001 (cr=1 pr=1 pw=0 time=301 us) 0 INDEX SKIP SCAN ICMUX024190013X (cr=1 pr=1 pw=0 time=294 us)(object id 52532) ******************************************************************************** DELETE FROM SVTLSADM.ICMUT02427001 WHERE COMPONENTID=:h AND VERSIONID=:h call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 4 2 12 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 4 2 12 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE ICMUT02427001 (cr=2 pr=4 pw=0 time=1161 us) 1 INDEX UNIQUE SCAN SYS_C0026958 (cr=2 pr=2 pw=0 time=264 us)(object id 54027) ******************************************************************************** select count(ITEMTYPEVIEWID) into :b0 from ICMSTITVIEWDEFS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 6 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.02 6 7 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=7 pr=6 pw=0 time=11723 us) 77 INDEX FAST FULL SCAN SYS_C004477 (cr=7 pr=6 pw=0 time=11658 us)(object id 42666) ******************************************************************************** select LIBRARYSERVERID ,LANGUAGECODE ,SYSSEGMENTID ,SYSSEGMENTTHRESHLD , ACLBINDINGLEVEL ,LIBRARYACLCODE ,PUBACCESSENABLED ,DFLTACLCHOICE ,SMSCHOICE ,TRACELEVEL ,MAXUSERS ,MAXUSERACTION ,CURRENTUSERS ,MAXLOGONRETRY , PASSWORDDURATION ,SYSADMINEVENTFLAG ,SYSTEMFLAG ,DATABASETYPE , MAXTXDURATION ,MAXRESULTSETSIZE ,ALLOWTRUSTEDLOGON ,TIEUSERID ,PLATFORM , DATABASENAME ,DBSCHEMANAME ,TRACEFILENAME ,ENCRYPTIONKEY ,DOCROUTINGUPDATE , DOCROUTINGFREQ ,MAXTRACEFILESIZE ,MULTIPLETRACEFILES ,KEEPTRACEOPEN , PATHICMROOT ,PATHICMDLL ,TO_CHAR(SUSPENDSERVERTIME,:"SYS_B_0") ,TRACEUSER , SYSTEMFLAG2 ,RECORDSMANAGERHOST ,LSCURRENTVERSION into :b0,:b1,:b2,:b3,:b4, :b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14,:b15,:b16,:b17,:b18,:b19,:b20, :b21:b22,:b23,:b24,:b25,:b26:b27,:b28,:b29,:b30,:b31,:b32,:b33,:b34,:b35, :b36:b37,:b38:b39,:b40,:b41,:b42 from ICMSTSYSCONTROL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL ICMSTSYSCONTROL (cr=7 pr=0 pw=0 time=250 us) ******************************************************************************** select USER into :b0 from DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 FAST DUAL (cr=0 pr=0 pw=0 time=4 us) ******************************************************************************** select UPPER(:b0) into :b0 from DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 0 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us) ******************************************************************************** call icmlspkg.execstmtwat(:b0) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) ******************************************************************************** COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 40 (recursive depth: 2) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMSTNLSLANGUAGES where LANGUAGECODE=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 INDEX UNIQUE SCAN SYS_C004435 (cr=1 pr=0 pw=0 time=48 us)(object id 42659) ******************************************************************************** select U.UNUM ,U.USERID ,U.DOMAINID ,U.USERNAME ,U.USERPRIVSETCODE , K1.KEYWORDNAME USERPRIVSET ,U.GRANTPRIVSETCODE ,K2.KEYWORDNAME GRANTPRIVSET ,U.DFLTACLCODE ,K3.KEYWORDNAME DFLTITEMACL ,U.DFLTRMCODE ,RMNAME , U.DFLTCOLLCODE ,C.SMSCOLLNAME SMSCOLLECTION ,U.LASTACCESS ,U.PASSWORD , U.RETRYCOUNT ,TO_CHAR(PASSWORDEXPIRATION,:"SYS_B_0") ,LDAPINFO ,LOGGEDON into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12,:b13,:b14, :b15:b16,:b17,:b18:b19,:b20:b21,:b22 from ICMSTUSERS U ,ICMSTNLSKEYWORDS K1 ,ICMSTNLSKEYWORDS K2 ,ICMSTNLSKEYWORDS K3 , ICMSTCOLLNAME C ,ICMSTRESOURCEMGR R where ((((((((((((U.USERID=:b1 and K1.KEYWORDCODE=U.USERPRIVSETCODE) and K1.LANGUAGECODE=:b24) and K1.KEYWORDCLASS=:"SYS_B_1") and K2.KEYWORDCODE=U.GRANTPRIVSETCODE) and K2.LANGUAGECODE=:b24) and K2.KEYWORDCLASS=:"SYS_B_2") and K3.KEYWORDCODE= U.DFLTACLCODE) and K3.LANGUAGECODE=:b24) and K3.KEYWORDCLASS=:"SYS_B_3") and C.RMCODE=U.DFLTRMCODE) and C.SMSCOLLCODE=U.DFLTCOLLCODE) and R.RMCODE= U.DFLTRMCODE) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 16 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 16 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS (cr=16 pr=0 pw=0 time=219 us) 1 NESTED LOOPS (cr=13 pr=0 pw=0 time=195 us) 1 NESTED LOOPS (cr=10 pr=0 pw=0 time=170 us) 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=140 us) 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=118 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTUSERS (cr=3 pr=0 pw=0 time=91 us) 1 INDEX UNIQUE SCAN SYS_C004352 (cr=2 pr=0 pw=0 time=29 us)(object id 42646) 1 TABLE ACCESS BY INDEX ROWID ICMSTRESOURCEMGR (cr=2 pr=0 pw=0 time=26 us) 1 INDEX UNIQUE SCAN SYS_C004327 (cr=1 pr=0 pw=0 time=10 us)(object id 42642) 1 TABLE ACCESS BY INDEX ROWID ICMSTCOLLNAME (cr=2 pr=0 pw=0 time=19 us) 1 INDEX UNIQUE SCAN SYS_C004336 (cr=1 pr=0 pw=0 time=9 us)(object id 42644) 1 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=3 pr=0 pw=0 time=25 us) 1 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=2 pr=0 pw=0 time=18 us)(object id 42872) 1 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=3 pr=0 pw=0 time=23 us) 1 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=2 pr=0 pw=0 time=12 us)(object id 42872) 1 TABLE ACCESS BY INDEX ROWID ICMSTNLSKEYWORDS (cr=3 pr=0 pw=0 time=15 us) 1 INDEX UNIQUE SCAN ICMSXNLSKEYWORDS1U (cr=2 pr=0 pw=0 time=10 us)(object id 42872) ******************************************************************************** select count(U.UNUM) into :b0 from ICMSTUSERS U ,ICMSTCOMPILEDPERM P where ((U.UNUM=:b1 and U.UNUM=P.UNUM) and P.PRIVDEFCODE=:"SYS_B_0") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=4 pr=0 pw=0 time=192 us) 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=46 us) 1 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=2 pr=0 pw=0 time=25 us)(object id 42868) 1 INDEX UNIQUE SCAN UNIQUEUNUM (cr=2 pr=0 pw=0 time=16 us)(object id 42647) ******************************************************************************** select RMFLAGS into :b0 from ICMSTRESOURCEMGR where RMCODE=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 8 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.00 0.00 0 8 0 8 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 8 INDEX RANGE SCAN ICMSXRESOURCEMGR3U (cr=8 pr=0 pw=0 time=286 us)(object id 42854) ******************************************************************************** select count(ITEMTYPEID) into :b0 from ICMSTITEMTYPEDEFS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.04 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 6 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.04 0.02 6 7 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=7 pr=6 pw=0 time=2055 us) 77 INDEX FAST FULL SCAN ICMSXITEMTYPEDEF1U (cr=7 pr=6 pw=0 time=2037 us)(object id 42875) ******************************************************************************** select ITEMLEVELACLFLAG into :b0 from ICMSTITEMTYPEDEFS where ITEMTYPEID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 236 0.00 0.00 0 0 0 0 Fetch 236 0.01 0.00 0 472 0 236 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 473 0.01 0.01 0 472 0 236 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 236 INDEX RANGE SCAN ICMSXITEMTYPEDEF1U (cr=472 pr=0 pw=0 time=4035 us)(object id 42875) ******************************************************************************** select COMPONENTTYPEID into :b0 from ICMSTCOMPVIEWDEFS where COMPONENTVIEWID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 196 0.00 0.00 0 0 0 0 Fetch 196 0.01 0.00 0 392 0 196 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 394 0.01 0.01 0 392 0 196 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 98 INDEX RANGE SCAN ICMSXCOMPVIEWDEF2X (cr=196 pr=0 pw=0 time=2338 us)(object id 42887) ******************************************************************************** SELECT ITEMID, VERSIONID FROM ICMSTITEMS001001 WHERE ITEMID IN (:"SYS_B_0") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=60 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=42 us)(object id 42677) ******************************************************************************** select ICMMANAGEDRECORD into :b0 from ICMSTITEMS001001 where (ITEMID=:b1 and VERSIONID=:b2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=63 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=41 us)(object id 42677) ******************************************************************************** select A.ITEMTYPECLASS ,A.ITEMEVENTFLAG ,A.ITEMLEVELACLFLAG ,A.ITEMTYPEFLAG , B.ACLCODE into :b0,:b1,:b2,:b3,:b4 from ICMSTITEMTYPEDEFS A ,ICMSTITVIEWDEFS B where (A.ITEMTYPEID=B.ITEMTYPEID and B.ITEMTYPEVIEWID=:b5) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 5 48 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.01 0.00 5 48 0 8 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 8 NESTED LOOPS (cr=48 pr=5 pw=0 time=1087 us) 8 TABLE ACCESS BY INDEX ROWID ICMSTITVIEWDEFS (cr=24 pr=0 pw=0 time=391 us) 8 INDEX UNIQUE SCAN SYS_C004477 (cr=16 pr=0 pw=0 time=207 us)(object id 42666) 8 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=24 pr=5 pw=0 time=645 us) 8 INDEX UNIQUE SCAN SYS_C004469 (cr=16 pr=5 pw=0 time=552 us)(object id 42664) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMSTCOMPILEDPERM where (UNUM=:b1 and PRIVDEFCODE=:b2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 29 0.00 0.00 0 58 0 29 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.00 0.00 0 58 0 29 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 29 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=58 pr=0 pw=0 time=917 us)(object id 42868) ******************************************************************************** select TOKENDURATION ,RMPLATFORM ,CURRENTVERSION into :b0,:b1,:b2 from ICMSTRESOURCEMGR where RMCODE=:b3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 98 0.00 0.00 0 0 0 0 Fetch 98 0.00 0.00 0 196 0 98 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 197 0.00 0.00 0 196 0 98 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 98 TABLE ACCESS BY INDEX ROWID ICMSTRESOURCEMGR (cr=196 pr=0 pw=0 time=1871 us) 98 INDEX UNIQUE SCAN SYS_C004327 (cr=98 pr=0 pw=0 time=968 us)(object id 42642) ******************************************************************************** select B.ACLCODE ,C.ITEMLEVELACLFLAG into :b0,:b1 from ICMSTITEMS001001 A ,ICMSTITVIEWDEFS B ,ICMSTITEMTYPEDEFS C where (((A.ITEMID= :b2 and A.ITEMTYPEID=B.ITEMTYPEID) and B.ITEMTYPEID=C.ITEMTYPEID) and B.ITEMTYPEVIEWID=:b3) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 16 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 16 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS (cr=16 pr=0 pw=0 time=261 us) 2 NESTED LOOPS (cr=12 pr=0 pw=0 time=199 us) 2 TABLE ACCESS BY INDEX ROWID ICMSTITVIEWDEFS (cr=6 pr=0 pw=0 time=102 us) 2 INDEX UNIQUE SCAN SYS_C004477 (cr=4 pr=0 pw=0 time=65 us)(object id 42666) 2 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=6 pr=0 pw=0 time=90 us)(object id 42895) 2 INDEX RANGE SCAN ICMSXITEMTYPEDEF1U (cr=4 pr=0 pw=0 time=42 us)(object id 42875) ******************************************************************************** select ITEMTYPEID into :b0 from ICMSTITEMS001001 where ITEMID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 6 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=6 pr=0 pw=0 time=165 us)(object id 42895) ******************************************************************************** select B.ITEMTYPECLASS ,B.ITEMLEVELACLFLAG into :b0,:b1 from ICMSTITEMS001001 A ,ICMSTITEMTYPEDEFS B where (A.ITEMID=:b2 and A.ITEMTYPEID= B.ITEMTYPEID) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 12 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS (cr=12 pr=0 pw=0 time=224 us) 2 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=6 pr=0 pw=0 time=145 us)(object id 42895) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=6 pr=0 pw=0 time=64 us) 2 INDEX UNIQUE SCAN SYS_C004469 (cr=4 pr=0 pw=0 time=32 us)(object id 42664) ******************************************************************************** select USERID into :b0 from ICMSTCHECKEDOUT where ITEMID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 1 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 1 4 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX RANGE SCAN ICMSXCHECKEDOUT2U (cr=2 pr=1 pw=0 time=237 us)(object id 42909) ******************************************************************************** select ITEMEVENTFLAG into :b0 from ICMSTITEMTYPEDEFS where ITEMTYPEID=(select ITEMTYPEID from ICMSTITEMS001001 where (ITEMID=:b1 and VERSIONID=:b2)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 8 0 0 Fetch 2 0.00 0.00 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 14 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=14 pr=0 pw=0 time=160 us) 2 INDEX UNIQUE SCAN SYS_C004469 (cr=12 pr=0 pw=0 time=135 us)(object id 42664) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=8 pr=0 pw=0 time=97 us) 2 INDEX UNIQUE SCAN SYS_C004557 (cr=6 pr=0 pw=0 time=63 us)(object id 42677) ******************************************************************************** select count(*) into :b0:b1 from ICMSTLINKS001001 where TARGETITEMID=:b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 3 6 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT AGGREGATE (cr=6 pr=3 pw=0 time=527 us) 0 INDEX RANGE SCAN ICMSXLINKS0010011U (cr=6 pr=3 pw=0 time=392 us)(object id 42901) ******************************************************************************** select VERSIONID into :b0 from ICMSTITEMS001001 where ITEMID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 12 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 12 0 3 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=8 pr=0 pw=0 time=99 us) 2 INDEX UNIQUE SCAN SYS_C004557 (cr=6 pr=0 pw=0 time=65 us)(object id 42677) ******************************************************************************** select count(*) into :b0 from ICMSTITEMVER001001 where ITEMID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.00 5 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.00 5 4 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT AGGREGATE (cr=4 pr=5 pw=0 time=789 us) 0 INDEX RANGE SCAN SYS_C004571 (cr=4 pr=5 pw=0 time=720 us)(object id 42679) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMUT00204001 where (PROCESSITEMID=:b1 and ROWNUM<:"SYS_B_1") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.79 1.65 7553 15124 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.80 1.65 7553 15124 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 COUNT STOPKEY (cr=15124 pr=7553 pw=0 time=1653370 us) 0 TABLE ACCESS FULL ICMUT00204001 (cr=15124 pr=7553 pw=0 time=1653348 us) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMUT00200001 PR ,ICMUT00201001 RS ,ICMUT00202001 WN where ((((PR.ITEMID=:b1 and PR.PROCESSNAME=WN.WORKNODENAME) and (WN.ITEMID=RS.FROMWNITEMID or WN.ITEMID=RS.TOWNITEMID)) and WN.WORKNODETYPE=:"SYS_B_1") and ROWNUM<:"SYS_B_2") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.87 0.98 278 28624 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.87 0.98 278 28624 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 COUNT STOPKEY (cr=28624 pr=278 pw=0 time=983444 us) 0 NESTED LOOPS (cr=28624 pr=278 pw=0 time=983406 us) 4 NESTED LOOPS (cr=28612 pr=272 pw=0 time=63268 us) 12042 TABLE ACCESS FULL ICMUT00201001 (cr=380 pr=187 pw=0 time=39859 us) 4 TABLE ACCESS BY INDEX ROWID ICMUT00202001 (cr=28232 pr=85 pw=0 time=849708 us) 16068 BITMAP CONVERSION TO ROWIDS (cr=16190 pr=17 pw=0 time=705037 us) 12042 BITMAP OR (cr=16190 pr=17 pw=0 time=672278 us) 8036 BITMAP CONVERSION FROM ROWIDS (cr=8096 pr=0 pw=0 time=307178 us) 8036 SORT ORDER BY (cr=8096 pr=0 pw=0 time=268165 us) 8036 INDEX RANGE SCAN ICMUX002020012U (cr=8096 pr=0 pw=0 time=119886 us)(object id 42929) 8032 BITMAP CONVERSION FROM ROWIDS (cr=8094 pr=17 pw=0 time=293092 us) 8032 SORT ORDER BY (cr=8094 pr=17 pw=0 time=257273 us) 8032 INDEX RANGE SCAN ICMUX002020012U (cr=8094 pr=17 pw=0 time=135616 us)(object id 42929) 0 TABLE ACCESS BY INDEX ROWID ICMUT00200001 (cr=12 pr=6 pw=0 time=8840 us) 4 INDEX UNIQUE SCAN SYS_C004713 (cr=8 pr=5 pw=0 time=8623 us)(object id 42724) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMUT00201001 where (FROMWNITEMID=:b1 or (TOWNITEMID=:b1 and ROWNUM<:"SYS_B_1")) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.02 0.01 0 380 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.02 0.01 0 380 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 COUNT (cr=380 pr=0 pw=0 time=16318 us) 0 FILTER (cr=380 pr=0 pw=0 time=16305 us) 12042 TABLE ACCESS FULL ICMUT00201001 (cr=380 pr=0 pw=0 time=6262 us) ******************************************************************************** select SEGMENTID ,ITEMTYPEID ,COMPONENTTYPEID ,ICMMANAGEDRECORD into :b0,:b1, :b2,:b3 from ICMSTITEMS001001 where (ITEMID=:b4 and VERSIONID=:b5) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=58 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=36 us)(object id 42677) ******************************************************************************** select ITEMTYPECLASS into :b0 from ICMSTITEMTYPEDEFS where ITEMTYPEID=(select ITEMTYPEID from ICMSTITEMS001001 where (ITEMID=:b1 and VERSIONID=:b2)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 8 0 0 Fetch 2 0.00 0.00 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 14 0 2 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=14 pr=0 pw=0 time=157 us) 2 INDEX UNIQUE SCAN SYS_C004469 (cr=12 pr=0 pw=0 time=131 us)(object id 42664) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=8 pr=0 pw=0 time=89 us) 2 INDEX UNIQUE SCAN SYS_C004557 (cr=6 pr=0 pw=0 time=58 us)(object id 42677) ******************************************************************************** select COMPONENTTYPEID ,PARENTCOMPTYPEID ,CARDINALITYMIN ,CARDINALITYMAX , COMPTYPECLASS from ICMSTCOMPDEFS where ITEMTYPEID=:b0 order by COMPONENTTYPEID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.01 5 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.01 5 6 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT ORDER BY (cr=6 pr=5 pw=0 time=12432 us) 3 TABLE ACCESS BY INDEX ROWID ICMSTCOMPDEFS (cr=6 pr=5 pw=0 time=12301 us) 3 INDEX RANGE SCAN ICMSXITEMCOMPDEF3X (cr=4 pr=5 pw=0 time=12250 us)(object id 42881) ******************************************************************************** select ACCESSMODULESTATUS into :b0 from ICMSTCOMPVIEWDEFS where COMPONENTVIEWID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 TABLE ACCESS BY INDEX ROWID ICMSTCOMPVIEWDEFS (cr=9 pr=0 pw=0 time=204 us) 3 INDEX RANGE SCAN ICMSXCOMPVIEWDEF2X (cr=6 pr=0 pw=0 time=142 us)(object id 42887) ******************************************************************************** select SEGMENTID into :b0:b1 from ICMSTITEMTYPEDEFS where ITEMTYPEID=:b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=9 pr=0 pw=0 time=122 us) 3 INDEX UNIQUE SCAN SYS_C004469 (cr=6 pr=0 pw=0 time=69 us)(object id 42664) ******************************************************************************** DELETE FROM SVTLSADM.ICMUT02418001 WHERE COMPONENTID=:h AND VERSIONID=:h call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.00 0.00 5 2 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.02 0.01 5 2 11 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE ICMUT02418001 (cr=2 pr=5 pw=0 time=1039 us) 1 INDEX UNIQUE SCAN SYS_C0026814 (cr=2 pr=2 pw=0 time=258 us)(object id 52525) ******************************************************************************** select max(VERSIONID) into :b0:b1 from ICMSTITEMVER001001 where ITEMID=:b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=120 us) 0 FIRST ROW (cr=2 pr=0 pw=0 time=69 us) 0 INDEX RANGE SCAN (MIN/MAX) SYS_C004571 (cr=2 pr=0 pw=0 time=66 us)(object id 42679) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMSTLINKS001001 where (SOURCEITEMID=:b1 and ROWNUM<:"SYS_B_1") call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 3 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 3 6 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 COUNT STOPKEY (cr=6 pr=3 pw=0 time=412 us) 0 INDEX RANGE SCAN ICMSXLINKS0010013X (cr=6 pr=3 pw=0 time=395 us)(object id 42903) ******************************************************************************** select ICMMANAGEDRECORD into :b0 from ICMSTITEMS001001 where ITEMID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=65 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=43 us)(object id 42677) ******************************************************************************** select VERSIONID ,ICMMANAGEDRECORD into :b0,:b1 from ICMSTITEMS001001 where ITEMID=:b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=66 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=43 us)(object id 42677) ******************************************************************************** select SEGMENTID ,ITEMTYPEID ,COMPONENTTYPEID into :b0,:b1,:b2 from ICMSTITEMS001001 where (ITEMID=:b3 and VERSIONID=:b4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=60 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=37 us)(object id 42677) ******************************************************************************** SELECT RMCODE, SMSCOLLCODE, EXTOBJECTNAME, RESOURCEFLAG, TO_CHAR(OBJECTUPDATED, :"SYS_B_0") FROM SVTLSADM.ICMUT02418001 WHERE ITEMID = :h1 AND VERSIONID = :h2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ICMUT02418001 (cr=3 pr=0 pw=0 time=58 us) 1 INDEX UNIQUE SCAN ICMUX024180011U (cr=2 pr=0 pw=0 time=34 us)(object id 52526) ******************************************************************************** select ITEMID ,VERSIONID ,ICMMANAGEDRECORD from ICMSTITEMVER001001 where ITEMID=:b0 for update call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 16 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 16 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 FOR UPDATE (cr=16 pr=0 pw=0 time=422 us) 0 TABLE ACCESS FULL ICMSTITEMVER001001 (cr=16 pr=0 pw=0 time=416 us) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 57 0.23 0.21 0 0 0 0 Execute 57 1.18 1.49 33 1371 380 0 Fetch 399 0.20 0.86 633 2411 0 9383 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 513 1.61 2.57 666 3782 380 9383 Misses in library cache during parse: 23 Misses in library cache during execute: 16 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 740 0.23 0.13 0 0 0 0 Execute 2123 0.25 0.25 35 59 100 8 Fetch 3769 1.84 3.11 8274 51956 0 3136 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6632 2.32 3.50 8309 52015 100 3144 Misses in library cache during parse: 50 Misses in library cache during execute: 21 326 user SQL statements in session. 1260 internal SQL statements in session. 1586 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: svtlsdb_ora_28075.trc Trace file compatibility: 10.01.00 Sort options: execpu 1 session in tracefile. 326 user SQL statements in trace file. 1260 internal SQL statements in trace file. 1586 SQL statements in trace file. 123 unique SQL statements in trace file. 17669 lines in trace file. 9 elapsed seconds in trace file.