TKPROF: Release 10.2.0.3.0 - Production on Tue Nov 25 10:54:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: svtlsdb_ora_28152.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: system/pass4svt ORA-12162: TNS:net service name is incorrectly specified EXPLAIN PLAN option disabled. ******************************************************************************** CALL ICMLSPKG.ICMDELETEDOC(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15, :16,:17) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.08 0.15 30 56 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.08 0.15 30 56 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 4 0.00 0.00 0 0 0 0 Execute 4 0.06 0.05 0 85 176 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.06 0.05 0 85 176 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 5 0.04 0.12 0 23 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.04 0.12 0 23 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 LC_DOC_1.ITEMID, LC_DOC_1.COMPONENTID, LC_DOC_1.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID FROM ICMUT02350001 LC_DOC_1 WHERE (LC_DOC_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.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 5 0.00 0.00 0 389 0 125 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.02 0.02 0 389 0 125 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 125 NESTED LOOPS (cr=389 pr=0 pw=0 time=4583 us) 125 VIEW (cr=8 pr=0 pw=0 time=890 us) 125 FILTER (cr=8 pr=0 pw=0 time=638 us) 125 INDEX RANGE SCAN LC_DOC_INDEXNU (cr=8 pr=0 pw=0 time=134 us)(object id 54056) 125 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=381 pr=0 pw=0 time=2334 us) 125 INDEX UNIQUE SCAN SYS_C004557 (cr=256 pr=0 pw=0 time=1485 us)(object id 42677) ******************************************************************************** SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT GPSCpDocs1535_5.ITEMID, GPSCpDocs1535_5.COMPONENTID, GPSCpDocs1535_5.VERSIONID, :"SYS_B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID FROM ICMUT02350001 LC_DOC_1, ICMUT02352001 GPSCpDocs1535_5 WHERE ((LC_DOC_1.ITEMID = :"SYS_B_2") AND ((LC_DOC_1.COMPONENTID = GPSCpDocs1535_5.PARENTCOMPID) AND (LC_DOC_1.VERSIONID = GPSCpDocs1535_5.VERSIONID))) AND (((( (:"SYS_B_3"=:"SYS_B_4") ))))) T call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.01 0.01 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.01 6 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.02 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=15156 us) 0 HASH UNIQUE (cr=3 pr=6 pw=0 time=15149 us) 0 FILTER (cr=3 pr=6 pw=0 time=14789 us) 0 NESTED LOOPS (cr=3 pr=6 pw=0 time=14784 us) 0 VIEW index$_join$_003 (cr=3 pr=6 pw=0 time=14777 us) 0 HASH JOIN (cr=3 pr=6 pw=0 time=14771 us) 0 HASH JOIN (cr=3 pr=6 pw=0 time=14015 us) 0 INDEX FAST FULL SCAN ICMUX023520012X (cr=3 pr=6 pw=0 time=12675 us)(object id 52048) 0 INDEX FAST FULL SCAN ICMUX023520013X (cr=0 pr=0 pw=0 time=0 us)(object id 52049) 0 INDEX FAST FULL SCAN SYS_C0025854 (cr=0 pr=0 pw=0 time=0 us)(object id 52047) 0 TABLE ACCESS BY INDEX ROWID ICMUT02350001 (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN SYS_C0025827 (cr=0 pr=0 pw=0 time=0 us)(object id 52033) ******************************************************************************** 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 ICMUT02350001 LC_DOC_1, ICMSTRI001001 References_5 WHERE (((LC_DOC_1.ITEMID = :"SYS_B_00") AND ((LC_DOC_1.ITEMID = References_5.TARGETITEMID) AND (LC_DOC_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.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.01 0.00 2 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 2 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=2 pw=0 time=646 us) 0 HASH UNIQUE (cr=3 pr=2 pw=0 time=641 us) 0 FILTER (cr=3 pr=2 pw=0 time=465 us) 0 NESTED LOOPS (cr=3 pr=2 pw=0 time=461 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=3 pr=2 pw=0 time=457 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=2 pw=0 time=446 us)(object id 42916) 0 INDEX UNIQUE SCAN ICMUX023500011U (cr=0 pr=0 pw=0 time=0 us)(object id 52034) ******************************************************************************** SELECT DISTINCT COMPONENTID FROM SVTLSADM.ICMUT02351001 WHERE ITEMID = :x call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.02 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.04 3 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 HASH UNIQUE (cr=3 pr=3 pw=0 time=13138 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02351001 (cr=3 pr=3 pw=0 time=12220 us) 1 INDEX RANGE SCAN ICMUX023510012X (cr=2 pr=2 pw=0 time=7567 us)(object id 52039) ******************************************************************************** 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 1 0.01 0.00 4 1 12 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 4 1 12 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) ******************************************************************************** select TARGETITEMID ,TARGETCOMPID ,TARGETCOMPTYPEID ,TARGETITEMTYPEID , TARGETVERSIONID from ICMSTRI001001 where (SOURCEITEMID=:b0 and SOURCECOMPTYPEID=:b1) order by TARGETITEMID,TARGETVERSIONID 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 1 0.00 0.00 1 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 1 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 SORT ORDER BY (cr=4 pr=1 pw=0 time=4511 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=4 pr=1 pw=0 time=4452 us) 1 INDEX RANGE SCAN ICMSTRI001001S (cr=3 pr=0 pw=0 time=124 us)(object id 42915) ******************************************************************************** delete from ICMSTRI001001 where ((SOURCEITEMID=:b0 and SOURCECOMPTYPEID=:b1) and SOURCECOMPID=:b2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.01 3 6 12 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 3 6 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 ------- --------------------------------------------------- 0 DELETE ICMSTRI001001 (cr=6 pr=3 pw=0 time=9356 us) 1 INDEX RANGE SCAN ICMSTRI001001S (cr=6 pr=0 pw=0 time=191 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 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 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 3 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=3 pr=0 pw=0 time=96 us) 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=91 us) 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=90 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=3 pr=0 pw=0 time=86 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=0 pw=0 time=79 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 ICMSTITEMVER001001 where ITEMID=:b0 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 2 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 2 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 ICMSTITEMVER001001 (cr=2 pr=0 pw=0 time=53 us) 0 INDEX RANGE SCAN SYS_C004571 (cr=2 pr=0 pw=0 time=46 us)(object id 42679) ******************************************************************************** SELECT RMCODE, SMSCOLLCODE, EXTOBJECTNAME, RESOURCEFLAG, TO_CHAR(OBJECTUPDATED, :"SYS_B_0") FROM SVTLSADM.ICMUT00301001 WHERE ITEMID = :x AND VERSIONID = :x call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.02 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.01 4 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.04 4 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 ICMUT00301001 (cr=4 pr=4 pw=0 time=15906 us) 1 INDEX UNIQUE SCAN ICMUX003010011U (cr=3 pr=3 pw=0 time=8741 us)(object id 42962) ******************************************************************************** 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 ******************************************************************************** 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 7 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 2 22 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.01 2 22 0 7 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 BY INDEX ROWID ICMSTVIEWACCESS (cr=3 pr=0 pw=0 time=95 us) 1 INDEX UNIQUE SCAN SYS_C004661 (cr=2 pr=0 pw=0 time=33 us)(object id 42708) ******************************************************************************** SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTYPE, A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS, A.LASTCHANGEDUSERID,A.ATTR0000002124,A.ATTR0000002123,A.ATTR0000002191, A.ATTR0000002155,A.ATTR0000002170,A.ATTR0000002112,A.ATTR0000002160, A.ATTR0000002171,A.ATTR0000001067,A.ATTR0000001043,A.ATTR0000001066, A.ATTR0000002200,A.ATTR0000002111,A.ATTR0000002132,A.ATTR0000002137, A.ATTR0000002135,A.ATTR0000002163,A.ICMMANAGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02350001 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",:"SYS_B_095", :"SYS_B_096",:"SYS_B_097",:"SYS_B_098",:"SYS_B_099",:"SYS_B_100", :"SYS_B_101"))) AND ((EXISTS (SELECT :"SYS_B_102" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_103" OR ICMC.ACL=-:"SYS_B_104") AND ICMC.UNUM = :"SYS_B_105" AND ICMC.RPRIV = :"SYS_B_106")) OR (EXISTS (SELECT :"SYS_B_107" FROM SVTLSADM.ICMSTCOMPILEDACL ICMC WHERE (ICMC.ACL=:"SYS_B_108" OR ICMC.ACL=-:"SYS_B_109") AND ICMC.UNUM = :"SYS_B_110" AND ICMC.RPRIV = :"SYS_B_111") AND EXISTS (SELECT :"SYS_B_112" FROM SVTLSADM.ICMSTCOMPILEDPERM ICMP WHERE ICMP.UNUM = :"SYS_B_113" AND ICMP.PRIVDEFCODE = :"SYS_B_114"))) 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 2 0 0 Fetch 5 0.00 0.00 0 313 0 101 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 315 0 101 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 101 FILTER (cr=315 pr=0 pw=0 time=5463 us) 101 NESTED LOOPS OUTER (cr=313 pr=0 pw=0 time=5291 us) 101 INLIST ITERATOR (cr=307 pr=0 pw=0 time=4060 us) 101 TABLE ACCESS BY INDEX ROWID ICMUT02350001 (cr=307 pr=0 pw=0 time=2365 us) 101 INDEX RANGE SCAN ICMUX023500011U (cr=206 pr=0 pw=0 time=1477 us)(object id 52034) 0 TABLE ACCESS BY INDEX ROWID ICMSTCHECKEDOUT (cr=6 pr=0 pw=0 time=504 us) 0 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=6 pr=0 pw=0 time=351 us)(object id 51956) 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=110 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=0 pw=0 time=68 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 A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTYPE, A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS, A.LASTCHANGEDUSERID,A.ATTR0000002124,A.ATTR0000002123,A.ATTR0000002191, A.ATTR0000002155,A.ATTR0000002170,A.ATTR0000002112,A.ATTR0000002160, A.ATTR0000002171,A.ATTR0000001067,A.ATTR0000001043,A.ATTR0000001066, A.ATTR0000002200,A.ATTR0000002111,A.ATTR0000002132,A.ATTR0000002137, A.ATTR0000002135,A.ATTR0000002163,A.ICMMANAGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02350001 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.00 0.00 0 6 0 0 Fetch 3 0.00 0.00 0 12 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 18 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 Rows Row Source Operation ------- --------------------------------------------------- 1 FILTER (cr=6 pr=0 pw=0 time=164 us) 1 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=79 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02350001 (cr=3 pr=0 pw=0 time=57 us) 1 INDEX UNIQUE SCAN ICMUX023500011U (cr=2 pr=0 pw=0 time=27 us)(object id 52034) 0 TABLE ACCESS BY INDEX ROWID ICMSTCHECKEDOUT (cr=1 pr=0 pw=0 time=15 us) 0 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=1 pr=0 pw=0 time=10 us)(object id 51956) 1 INLIST ITERATOR (cr=2 pr=0 pw=0 time=69 us) 1 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=2 pr=0 pw=0 time=42 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_000",:"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",:"SYS_B_095",:"SYS_B_096",:"SYS_B_097", :"SYS_B_098",:"SYS_B_099",:"SYS_B_100") 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 52 0.02 0.00 0 456 0 101 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 54 0.02 0.00 0 456 0 101 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 101 INLIST ITERATOR (cr=456 pr=0 pw=0 time=397 us) 101 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=456 pr=0 pw=0 time=3419 us) 101 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=355 pr=0 pw=0 time=3369 us)(object id 42895) ******************************************************************************** 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.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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 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=0 pw=0 time=230 us) 0 VIEW (cr=2 pr=0 pw=0 time=107 us) 0 FILTER (cr=2 pr=0 pw=0 time=100 us) 0 TABLE ACCESS BY INDEX ROWID ICMUT02428001 (cr=2 pr=0 pw=0 time=95 us) 0 INDEX RANGE SCAN GPSQUEUENORMIDXNU (cr=2 pr=0 pw=0 time=85 us)(object id 54048) ******************************************************************************** SELECT DISTINCT COMPONENTID FROM SVTLSADM.ICMUT02352001 WHERE ITEMID = :x 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 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 HASH UNIQUE (cr=1 pr=0 pw=0 time=188 us) 0 TABLE ACCESS BY INDEX ROWID ICMUT02352001 (cr=1 pr=0 pw=0 time=53 us) 0 INDEX RANGE SCAN ICMUX023520012X (cr=1 pr=0 pw=0 time=45 us)(object id 52048) ******************************************************************************** DELETE FROM SVTLSADM.ICMUT02351001 WHERE COMPONENTID=:h call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.03 24 2 15 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.03 24 2 15 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 ------- --------------------------------------------------- 0 DELETE ICMUT02351001 (cr=2 pr=24 pw=0 time=25617 us) 1 INDEX RANGE SCAN ICMUX02351001RX (cr=2 pr=5 pw=0 time=12111 us)(object id 52041) ******************************************************************************** DELETE FROM SVTLSADM.ICMUT02350001 WHERE COMPONENTID=:h call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 11 2 12 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.02 11 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 ------- --------------------------------------------------- 0 DELETE ICMUT02350001 (cr=2 pr=11 pw=0 time=14792 us) 1 INDEX RANGE SCAN SYS_C0025827 (cr=2 pr=5 pw=0 time=13685 us)(object id 52033) ******************************************************************************** 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: 0 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=246 us) 2 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=6 pr=0 pw=0 time=153 us)(object id 42895) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=6 pr=0 pw=0 time=78 us) 2 INDEX UNIQUE SCAN SYS_C004469 (cr=4 pr=0 pw=0 time=34 us)(object id 42664) ******************************************************************************** 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=254 us) ******************************************************************************** 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 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 28 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29 0.00 0.00 0 28 0 14 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 14 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=28 pr=0 pw=0 time=450 us)(object id 42868) ******************************************************************************** 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 81 0.00 0.00 0 0 0 0 Fetch 81 0.01 0.00 0 162 0 81 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 163 0.01 0.00 0 162 0 81 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 81 INDEX RANGE SCAN ICMSXITEMTYPEDEF1U (cr=162 pr=0 pw=0 time=1445 us)(object id 42875) ******************************************************************************** select VERSIONID ,ITEMTYPEID ,COMPONENTTYPEID ,COMPONENTID ,ICMMANAGEDRECORD , SEGMENTID into :b0,:b1,:b2,:b3,:b4,:b5 from ICMSTITEMS001001 where ITEMID=:b6 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=77 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=51 us)(object id 42677) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 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=8 pr=0 pw=0 time=99 us) 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=74 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTITVIEWDEFS (cr=3 pr=0 pw=0 time=39 us) 1 INDEX UNIQUE SCAN SYS_C004477 (cr=2 pr=0 pw=0 time=22 us)(object id 42666) 1 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=3 pr=0 pw=0 time=34 us)(object id 42895) 1 INDEX RANGE SCAN ICMSXITEMTYPEDEF1U (cr=2 pr=0 pw=0 time=21 us)(object id 42875) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 24 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 24 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 4 NESTED LOOPS (cr=24 pr=0 pw=0 time=296 us) 4 TABLE ACCESS BY INDEX ROWID ICMSTITVIEWDEFS (cr=12 pr=0 pw=0 time=169 us) 4 INDEX UNIQUE SCAN SYS_C004477 (cr=8 pr=0 pw=0 time=82 us)(object id 42666) 4 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=12 pr=0 pw=0 time=96 us) 4 INDEX UNIQUE SCAN SYS_C004469 (cr=8 pr=0 pw=0 time=58 us)(object id 42664) ******************************************************************************** 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: 0 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=50 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=35 us)(object id 42677) ******************************************************************************** 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 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 4 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 4 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 4 INDEX RANGE SCAN ICMSXRESOURCEMGR3U (cr=4 pr=0 pw=0 time=140 us)(object id 42854) ******************************************************************************** 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.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: 0 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=383 us) 2 UNION-ALL (cr=12 pr=0 pw=0 time=272 us) 2 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=4 pr=0 pw=0 time=138 us)(object id 42867) 0 FILTER (cr=8 pr=0 pw=0 time=114 us) 0 INDEX RANGE SCAN ICMSXCOMPILEDACL1X (cr=4 pr=0 pw=0 time=64 us)(object id 42867) 2 INDEX UNIQUE SCAN ICMSXCOMPILEDPRM1U (cr=4 pr=0 pw=0 time=39 us)(object id 42868) ******************************************************************************** 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 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 INDEX RANGE SCAN ICMSXCHECKEDOUT2U (cr=1 pr=0 pw=0 time=27 us)(object id 42909) ******************************************************************************** select ITEMTYPECLASS ,ACLCODE ,ITEMLEVELACLFLAG ,VERSIONCONTROL ,VERSIONMAX , DFLTPREFCHCOLLCODE ,DFLTXDOCLASSID ,AUTOLINKENABLE ,AUTOLINKSMS , ITEMEVENTFLAG ,PROCESSNAME ,DFLTPRIORITY ,DFLTRETENTIONUNIT , DFLTITEMRETENTION into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10:b11, :b12:b13,:b14,:b15 from ICMSTITEMTYPEDEFS IT ,ICMSTITVIEWDEFS IV where (IT.ITEMTYPEID=:b16 and IV.ITEMTYPEVIEWID=:b16) 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=175 us) 2 TABLE ACCESS BY INDEX ROWID ICMSTITVIEWDEFS (cr=6 pr=0 pw=0 time=107 us) 2 INDEX UNIQUE SCAN SYS_C004477 (cr=4 pr=0 pw=0 time=63 us)(object id 42666) 2 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEDEFS (cr=6 pr=0 pw=0 time=52 us) 2 INDEX UNIQUE SCAN SYS_C004469 (cr=4 pr=0 pw=0 time=27 us)(object id 42664) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 3 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT ORDER BY (cr=3 pr=0 pw=0 time=167 us) 3 TABLE ACCESS BY INDEX ROWID ICMSTCOMPDEFS (cr=3 pr=0 pw=0 time=84 us) 3 INDEX RANGE SCAN ICMSXITEMCOMPDEF3X (cr=2 pr=0 pw=0 time=57 us)(object id 42881) ******************************************************************************** select count(*) into :b0 from ICMSTRI001001 where (SOURCEITEMID=:b1 and SOURCECOMPTYPEID=: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 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 3 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=3 pr=2 pw=0 time=442 us) 1 INDEX RANGE SCAN ICMSTRI001001S (cr=3 pr=2 pw=0 time=410 us)(object id 42915) ******************************************************************************** select distinct B.DFLTACLCODE into :b0 from ICMSTRI001001 A ,ICMSTITEMTYPEREL B where ((A.TARGETITEMID=:b1 and A.TARGETITEMTYPEID=B.TARGETITEMTYPEID) and A.SOURCEITEMTYPEID= B.SOURCEITEMTYPEID) 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 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 6 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 HASH UNIQUE (cr=6 pr=1 pw=0 time=938 us) 1 NESTED LOOPS (cr=6 pr=1 pw=0 time=381 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=4 pr=0 pw=0 time=105 us) 1 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=0 pw=0 time=79 us)(object id 42916) 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMTYPEREL (cr=2 pr=1 pw=0 time=268 us) 1 INDEX UNIQUE SCAN ICMSXITEMRELATIO1U (cr=1 pr=1 pw=0 time=247 us)(object id 42904) ******************************************************************************** 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 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 12 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID ICMSTCOMPVIEWDEFS (cr=12 pr=0 pw=0 time=303 us) 4 INDEX RANGE SCAN ICMSXCOMPVIEWDEF2X (cr=8 pr=0 pw=0 time=208 us)(object id 42887) ******************************************************************************** SELECT DISTINCT COMPONENTID FROM SVTLSADM.ICMUT02350001 WHERE ITEMID = :x 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 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 HASH UNIQUE (cr=3 pr=0 pw=0 time=770 us) 1 TABLE ACCESS BY INDEX ROWID ICMUT02350001 (cr=3 pr=0 pw=0 time=92 us) 1 INDEX RANGE SCAN ICMUX023500011U (cr=2 pr=0 pw=0 time=70 us)(object id 52034) ******************************************************************************** DELETE FROM SVTLSADM.ICMUT00301001 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.04 11 3 15 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.04 11 3 15 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 ICMUT00301001 (cr=3 pr=11 pw=0 time=42745 us) 1 INDEX UNIQUE SCAN SYS_C004901 (cr=3 pr=3 pw=0 time=9827 us)(object id 42770) ******************************************************************************** select count(distinct SOURCEITEMTYPEID) into :b0 from ICMSTITEMAUTOLINK where TARGETITEMTYPEID=(select ITEMTYPEID 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 1 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 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 GROUP BY (cr=4 pr=0 pw=0 time=198 us) 0 INDEX RANGE SCAN ICMSXITEMAUTOLNK1X (cr=4 pr=0 pw=0 time=111 us)(object id 42894) 1 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=3 pr=0 pw=0 time=79 us)(object id 42895) ******************************************************************************** select AUTOLINKENABLE into :b0 from ICMSTITEMTYPEDEFS where ITEMTYPEID=(select ITEMTYPEID 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 3 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 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 ICMSTITEMTYPEDEFS (cr=6 pr=0 pw=0 time=130 us) 1 INDEX UNIQUE SCAN SYS_C004469 (cr=5 pr=0 pw=0 time=104 us)(object id 42664) 1 INDEX RANGE SCAN ICMSXITEMS0010011U (cr=3 pr=0 pw=0 time=78 us)(object id 42895) ******************************************************************************** delete from ICMSTITEMS001001 where ITEMID=:b0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 6 5 16 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 6 5 16 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 ICMSTITEMS001001 (cr=5 pr=6 pw=0 time=13149 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=45 us)(object id 42677) ******************************************************************************** delete from ICMSTLINKS001001 where (TARGETITEMID=:b0 or SOURCEITEMID=:b0) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 9 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 9 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 ICMSTLINKS001001 (cr=6 pr=9 pw=0 time=11166 us) 0 CONCATENATION (cr=6 pr=9 pw=0 time=11159 us) 0 INDEX RANGE SCAN ICMSXLINKS0010011U (cr=3 pr=0 pw=0 time=67 us)(object id 42901) 0 INDEX RANGE SCAN ICMSXLINKS0010012U (cr=3 pr=9 pw=0 time=11086 us)(object id 42902) ******************************************************************************** select :"SYS_B_0" into :b0 from ICMSTRI001001 where (((SOURCEITEMID=:b1 and TARGETITEMID=:b2) and TARGETVERSIONID=:b3) and ROWNUM<:"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 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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=3 pr=0 pw=0 time=90 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=3 pr=0 pw=0 time=83 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=0 pw=0 time=75 us)(object id 42916) ******************************************************************************** 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 1 0.00 0.00 0 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE ICMSTRI001001 (cr=3 pr=0 pw=0 time=86 us) 0 INDEX RANGE SCAN ICMSTRI001001S (cr=3 pr=0 pw=0 time=80 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 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=77 us) 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=72 us) 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=69 us) 0 TABLE ACCESS BY INDEX ROWID ICMSTRI001001 (cr=3 pr=0 pw=0 time=68 us) 0 INDEX RANGE SCAN ICMSTRI001001T (cr=3 pr=0 pw=0 time=60 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 ICMSTITEMS001001 where (ITEMID=:b0 and VERSIONID=: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 3 4 17 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 3 4 17 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE ICMSTITEMS001001 (cr=4 pr=3 pw=0 time=2963 us) 1 TABLE ACCESS BY INDEX ROWID ICMSTITEMS001001 (cr=4 pr=0 pw=0 time=69 us) 1 INDEX UNIQUE SCAN SYS_C004557 (cr=3 pr=0 pw=0 time=48 us)(object id 42677) ******************************************************************************** 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: 0 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=183 us) 0 FIRST ROW (cr=2 pr=0 pw=0 time=52 us) 0 INDEX RANGE SCAN (MIN/MAX) SYS_C004571 (cr=2 pr=0 pw=0 time=49 us)(object id 42679) ******************************************************************************** insert into ICMSTITEMSTODELETE (ITEMID,VERSIONID,RMCODE,RMACCESSTYPE, SMSCOLLCODE,REPTYPE,USERID,CREATED,URLADDRESS) values (:b0,:b1,:b2,:b3,:b4,:b5,:b6,TO_TIMESTAMP(RTRIM(:b7),:"SYS_B_0"),:b8) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 4 1 6 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 4 1 6 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) ******************************************************************************** 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 1 0.00 0.00 0 1 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 11 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 40 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 DELETE ICMSTCHECKEDOUT (cr=1 pr=0 pw=0 time=440 us) 1 INDEX UNIQUE SCAN ICMSXCHECKEDOUT3U (cr=1 pr=0 pw=0 time=29 us)(object id 51956) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 20 0.01 0.03 0 0 0 0 Execute 20 0.22 0.38 30 172 176 0 Fetch 17 0.01 0.02 8 725 0 229 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 57 0.24 0.43 38 897 176 229 Misses in library cache during parse: 5 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 124 0.04 0.07 0 0 0 0 Execute 330 0.08 0.19 75 39 116 9 Fetch 599 0.08 0.07 15 1532 0 541 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1053 0.20 0.34 90 1571 116 550 Misses in library cache during parse: 20 Misses in library cache during execute: 13 69 user SQL statements in session. 175 internal SQL statements in session. 244 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: svtlsdb_ora_28152.trc Trace file compatibility: 10.01.00 Sort options: execpu 1 session in tracefile. 69 user SQL statements in trace file. 175 internal SQL statements in trace file. 244 SQL statements in trace file. 71 unique SQL statements in trace file. 2780 lines in trace file. 3 elapsed seconds in trace file.