TKPROF: Release 11.2.0.3.0 - Development on Wed Nov 27 11:56:04 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: ././zabbix_ora_10295__nginx_.trc Sort options: exeela ******************************************************************************** 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 ******************************************************************************** SQL ID: 6f40tk8mdta7m Plan Hash: 4124571808 SELECT t.itemappid,t.itemid,t.applicationid FROM items_applications t WHERE (t.itemid BETWEEN :"SYS_B_00" AND :"SYS_B_01" OR t.itemid BETWEEN :"SYS_B_02" AND :"SYS_B_03" OR t.itemid BETWEEN :"SYS_B_04" AND :"SYS_B_05" OR t.itemid BETWEEN :"SYS_B_06" AND :"SYS_B_07" OR t.itemid BETWEEN :"SYS_B_08" AND :"SYS_B_09" OR t.itemid BETWEEN :"SYS_B_10" AND :"SYS_B_11" OR t.itemid BETWEEN :"SYS_B_12" AND :"SYS_B_13" OR t.itemid BETWEEN :"SYS_B_14" AND :"SYS_B_15" OR t.itemid BETWEEN :"SYS_B_16" AND :"SYS_B_17" OR t.itemid BETWEEN :"SYS_B_18" AND :"SYS_B_19" OR t.itemid BETWEEN :"SYS_B_20" AND :"SYS_B_21" OR t.itemid BETWEEN :"SYS_B_22" AND :"SYS_B_23" OR t.itemid BETWEEN :"SYS_B_24" AND :"SYS_B_25" OR t.itemid BETWEEN :"SYS_B_26" AND :"SYS_B_27" OR t.itemid BETWEEN :"SYS_B_28" AND :"SYS_B_29" OR t.itemid BETWEEN :"SYS_B_30" AND :"SYS_B_31" OR t.itemid BETWEEN :"SYS_B_32" AND :"SYS_B_33" OR t.itemid IN (:"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")) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.04 0.04 0 0 0 0 Fetch 5 0.00 0.02 2 88 0 423 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.05 0.07 2 88 0 423 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 423 423 423 CONCATENATION (cr=88 pr=2 pw=0 time=20382 us) 39 39 39 INLIST ITERATOR (cr=27 pr=2 pw=0 time=18956 us) 39 39 39 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=27 pr=2 pw=0 time=18915 us cost=40 size=600 card=40) 39 39 39 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=23 pr=1 pw=0 time=8030 us cost=39 size=0 card=40)(object id 58914) 5 5 5 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=41 us cost=3 size=60 card=4) 5 5 5 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=32 us cost=2 size=0 card=4)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=86 us cost=3 size=120 card=8) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=74 us cost=2 size=0 card=8)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=95 us cost=3 size=105 card=7) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=84 us cost=2 size=0 card=7)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=5 pr=0 pw=0 time=105 us cost=3 size=90 card=6) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=3 pr=0 pw=0 time=90 us cost=2 size=0 card=6)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=4 pr=0 pw=0 time=57 us cost=3 size=75 card=5) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=3 pr=0 pw=0 time=47 us cost=2 size=0 card=5)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=47 us cost=3 size=60 card=4) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=45 us cost=2 size=0 card=4)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=56 us cost=3 size=60 card=4) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=46 us cost=2 size=0 card=4)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=53 us cost=3 size=45 card=3) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=47 us cost=2 size=0 card=3)(object id 58914) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=5 pr=0 pw=0 time=71 us cost=3 size=45 card=3) 20 20 20 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=3 pr=0 pw=0 time=60 us cost=2 size=0 card=3)(object id 58914) 23 23 23 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=60 us cost=3 size=30 card=2) 23 23 23 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=55 us cost=2 size=0 card=2)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=69 us cost=3 size=30 card=2) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=63 us cost=2 size=0 card=2)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=76 us cost=3 size=30 card=2) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=71 us cost=2 size=0 card=2)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=5 pr=0 pw=0 time=100 us cost=3 size=30 card=2) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=3 pr=0 pw=0 time=93 us cost=2 size=0 card=2)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=93 us cost=3 size=30 card=2) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=84 us cost=2 size=0 card=2)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=4 pr=0 pw=0 time=91 us cost=3 size=15 card=1) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=82 us cost=2 size=0 card=1)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=3 pr=0 pw=0 time=96 us cost=3 size=15 card=1) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=2 pr=0 pw=0 time=89 us cost=2 size=0 card=1)(object id 58914) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEMS_APPLICATIONS (cr=5 pr=0 pw=0 time=113 us cost=3 size=15 card=1) 28 28 28 INDEX RANGE SCAN ITEMS_APPLICATIONS_2 (cr=3 pr=0 pw=0 time=101 us cost=2 size=0 card=1)(object id 58914) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 423 CONCATENATION 39 INLIST ITERATOR 39 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 39 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 5 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 5 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 23 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 23 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS_APPLICATIONS' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_APPLICATIONS_2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 Disk file operations I/O 2 0.00 0.00 db file sequential read 2 0.01 0.01 SQL*Net message from client 5 0.00 0.02 ******************************************************************************** SQL ID: 1q0vpq04xcjqz Plan Hash: 494048176 SELECT * FROM (SELECT * FROM history_uint h WHERE h.itemid=:"SYS_B_0" ORDER BY h.clock DESC) WHERE rownum BETWEEN :"SYS_B_1" AND :"SYS_B_2" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 315 0.02 0.03 0 0 0 0 Execute 315 0.04 0.04 0 0 0 0 Fetch 315 0.88 37.50 23378 76472 0 630 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 945 0.95 37.58 23378 76472 0 630 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 21 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 COUNT STOPKEY (cr=255 pr=123 pw=0 time=208742 us) 2 2 2 FILTER (cr=255 pr=123 pw=0 time=208729 us) 2 2 2 PARTITION RANGE ALL PARTITION: 1048575 1 (cr=255 pr=123 pw=0 time=208725 us cost=3674 size=182936 card=3518) 2 2 2 VIEW (cr=255 pr=123 pw=0 time=208719 us cost=3674 size=182936 card=3518) 2 2 2 SORT ORDER BY (cr=255 pr=123 pw=0 time=208717 us cost=3674 size=77396 card=3518) 238 249 478 TABLE ACCESS BY LOCAL INDEX ROWID HISTORY_UINT PARTITION: 1048575 1 (cr=255 pr=123 pw=0 time=208580 us cost=3673 size=77396 card=3518) 238 249 478 INDEX RANGE SCAN HISTORY_UINT_1 PARTITION: 1048575 1 (cr=5 pr=0 pw=0 time=77 us cost=32 size=0 card=3639)(object id 58985) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 COUNT (STOPKEY) 2 FILTER 2 PARTITION RANGE (ALL) PARTITION: START=1048575 STOP=1 2 VIEW 2 SORT (ORDER BY) 238 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'HISTORY_UINT' (TABLE) PARTITION: START=1048575 STOP=1 238 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HISTORY_UINT_1' (INDEX) PARTITION: START=1048575 STOP=1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 315 0.00 0.00 db file parallel read 1183 0.20 28.15 db file sequential read 962 0.14 8.61 SQL*Net message from client 315 0.01 0.19 ******************************************************************************** SQL ID: fd3ukhupztuqb Plan Hash: 461233743 SELECT t.itemdiscoveryid,t.ts_delete,t.itemid FROM item_discovery t WHERE (t.itemid BETWEEN :"SYS_B_00" AND :"SYS_B_01" OR t.itemid BETWEEN :"SYS_B_02" AND :"SYS_B_03" OR t.itemid BETWEEN :"SYS_B_04" AND :"SYS_B_05" OR t.itemid BETWEEN :"SYS_B_06" AND :"SYS_B_07" OR t.itemid BETWEEN :"SYS_B_08" AND :"SYS_B_09" OR t.itemid BETWEEN :"SYS_B_10" AND :"SYS_B_11" OR t.itemid BETWEEN :"SYS_B_12" AND :"SYS_B_13" OR t.itemid BETWEEN :"SYS_B_14" AND :"SYS_B_15" OR t.itemid BETWEEN :"SYS_B_16" AND :"SYS_B_17" OR t.itemid BETWEEN :"SYS_B_18" AND :"SYS_B_19" OR t.itemid BETWEEN :"SYS_B_20" AND :"SYS_B_21" OR t.itemid BETWEEN :"SYS_B_22" AND :"SYS_B_23" OR t.itemid BETWEEN :"SYS_B_24" AND :"SYS_B_25" OR t.itemid BETWEEN :"SYS_B_26" AND :"SYS_B_27" OR t.itemid BETWEEN :"SYS_B_28" AND :"SYS_B_29" OR t.itemid BETWEEN :"SYS_B_30" AND :"SYS_B_31" OR t.itemid BETWEEN :"SYS_B_32" AND :"SYS_B_33" OR t.itemid IN (:"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")) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.03 0.03 0 0 0 0 Fetch 5 0.00 0.12 7 126 0 416 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.03 0.15 7 126 0 416 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 416 416 416 CONCATENATION (cr=126 pr=7 pw=0 time=122460 us) 32 32 32 INLIST ITERATOR (cr=45 pr=6 pw=0 time=108263 us) 32 32 32 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=45 pr=6 pw=0 time=108218 us cost=41 size=520 card=40) 32 32 32 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=41 pr=3 pw=0 time=54509 us cost=40 size=0 card=40)(object id 58874) 5 5 5 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=27 us cost=4 size=52 card=4) 5 5 5 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=22 us cost=3 size=0 card=4)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=44 us cost=4 size=104 card=8) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=38 us cost=3 size=0 card=8)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=42 us cost=4 size=91 card=7) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=34 us cost=3 size=0 card=7)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=48 us cost=4 size=78 card=6) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=41 us cost=3 size=0 card=6)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=7 pr=0 pw=0 time=58 us cost=4 size=65 card=5) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=4 pr=0 pw=0 time=48 us cost=3 size=0 card=5)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=54 us cost=4 size=52 card=4) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=46 us cost=3 size=0 card=4)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=53 us cost=4 size=39 card=3) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=45 us cost=3 size=0 card=3)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=5 pr=0 pw=0 time=57 us cost=4 size=39 card=3) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=4 pr=0 pw=0 time=51 us cost=3 size=0 card=3)(object id 58874) 20 20 20 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=57 us cost=4 size=26 card=2) 20 20 20 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=51 us cost=3 size=0 card=2)(object id 58874) 23 23 23 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=7 pr=1 pw=0 time=13046 us cost=4 size=26 card=2) 23 23 23 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=5 pr=1 pw=0 time=13035 us cost=3 size=0 card=2)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=5 pr=0 pw=0 time=77 us cost=4 size=26 card=2) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=66 us cost=3 size=0 card=2)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=78 us cost=4 size=26 card=2) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=68 us cost=3 size=0 card=2)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=6 pr=0 pw=0 time=96 us cost=4 size=26 card=2) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=4 pr=0 pw=0 time=84 us cost=3 size=0 card=2)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=86 us cost=4 size=13 card=1) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=79 us cost=3 size=0 card=1)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=4 pr=0 pw=0 time=73 us cost=4 size=13 card=1) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=71 us cost=3 size=0 card=1)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=5 pr=0 pw=0 time=93 us cost=4 size=13 card=1) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=3 pr=0 pw=0 time=85 us cost=3 size=0 card=1)(object id 58874) 28 28 28 TABLE ACCESS BY INDEX ROWID ITEM_DISCOVERY (cr=6 pr=0 pw=0 time=121 us cost=4 size=13 card=1) 28 28 28 INDEX RANGE SCAN ITEM_DISCOVERY_1 (cr=4 pr=0 pw=0 time=107 us cost=3 size=0 card=1)(object id 58874) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 416 CONCATENATION 32 INLIST ITERATOR 32 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 32 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 5 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 5 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 20 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 20 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 23 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 23 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) 28 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEM_DISCOVERY' (TABLE) 28 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEM_DISCOVERY_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 db file sequential read 7 0.03 0.12 SQL*Net message from client 5 0.00 0.02 ******************************************************************************** SQL ID: 8zssuj8c2w99n Plan Hash: 1237523861 SELECT * FROM (SELECT * FROM history_str h WHERE h.itemid=:"SYS_B_0" ORDER BY h.clock DESC) WHERE rownum BETWEEN :"SYS_B_1" AND :"SYS_B_2" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 105 0.00 0.00 0 0 0 0 Execute 105 0.02 0.01 0 0 0 0 Fetch 105 0.02 0.65 134 1987 0 210 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 315 0.04 0.67 134 1987 0 210 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 21 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 COUNT STOPKEY (cr=19 pr=2 pw=0 time=8050 us) 2 2 2 FILTER (cr=19 pr=2 pw=0 time=8041 us) 2 2 2 PARTITION RANGE ALL PARTITION: 1048575 1 (cr=19 pr=2 pw=0 time=8038 us cost=132 size=49491 card=117) 2 2 2 VIEW (cr=19 pr=2 pw=0 time=8034 us cost=132 size=49491 card=117) 2 2 2 SORT ORDER BY (cr=19 pr=2 pw=0 time=8032 us cost=132 size=3276 card=117) 16 16 16 TABLE ACCESS BY LOCAL INDEX ROWID HISTORY_STR PARTITION: 1048575 1 (cr=19 pr=2 pw=0 time=8013 us cost=131 size=3276 card=117) 16 16 16 INDEX RANGE SCAN HISTORY_STR_1 PARTITION: 1048575 1 (cr=3 pr=0 pw=0 time=19 us cost=14 size=0 card=117)(object id 58979) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 COUNT (STOPKEY) 2 FILTER 2 PARTITION RANGE (ALL) PARTITION: START=1048575 STOP=1 2 VIEW 2 SORT (ORDER BY) 16 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'HISTORY_STR' (TABLE) PARTITION: START=1048575 STOP=1 16 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HISTORY_STR_1' (INDEX) PARTITION: START=1048575 STOP=1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 105 0.00 0.00 db file sequential read 49 0.02 0.35 SQL*Net message from client 105 0.00 0.05 db file parallel read 16 0.06 0.28 ******************************************************************************** SQL ID: 3hhz1ak5j4fgw Plan Hash: 2861176870 SELECT a.applicationid FROM applications a WHERE a.applicationid IN (:"SYS_B_0",:"SYS_B_1",:"SYS_B_2") 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.01 1 5 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 5 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 INLIST ITERATOR (cr=5 pr=1 pw=0 time=12148 us) 3 3 3 INDEX UNIQUE SCAN SYS_C0040986 (cr=5 pr=1 pw=0 time=12129 us cost=3 size=15 card=3)(object id 59064) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 3 INLIST ITERATOR 3 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040986' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 db file sequential read 1 0.01 0.01 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 3n8w8b8v6wwfp Plan Hash: 4101821511 SELECT at.application_templateid,at.applicationid,at.templateid FROM application_template at WHERE at.applicationid IN (:"SYS_B_0",:"SYS_B_1", :"SYS_B_2",:"SYS_B_3",:"SYS_B_4") 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 10 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 10 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 INLIST ITERATOR (cr=10 pr=1 pw=0 time=6325 us) 3 3 3 TABLE ACCESS BY INDEX ROWID APPLICATION_TEMPLATE (cr=10 pr=1 pw=0 time=6314 us cost=5 size=70 card=5) 3 3 3 INDEX RANGE SCAN APPLICATION_TEMPLATE_1 (cr=7 pr=1 pw=0 time=6305 us cost=4 size=0 card=5)(object id 59246) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 3 INLIST ITERATOR 3 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'APPLICATION_TEMPLATE' (TABLE) 3 INDEX MODE: ANALYZED (RANGE SCAN) OF 'APPLICATION_TEMPLATE_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 db file sequential read 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: gru60mstu3vsh Plan Hash: 3485503018 SELECT * FROM (SELECT * FROM history_text h WHERE h.itemid=:"SYS_B_0" ORDER BY h.clock DESC) WHERE rownum BETWEEN :"SYS_B_1" AND :"SYS_B_2" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.02 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.10 18 34 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.12 18 34 0 4 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 COUNT STOPKEY (cr=17 pr=9 pw=0 time=52160 us) 2 2 2 FILTER (cr=17 pr=9 pw=0 time=52150 us) 2 2 2 VIEW (cr=17 pr=9 pw=0 time=52144 us cost=41 size=75998 card=37) 2 2 2 SORT ORDER BY (cr=17 pr=9 pw=0 time=52142 us cost=41 size=5476 card=37) 14 14 14 TABLE ACCESS BY GLOBAL INDEX ROWID HISTORY_TEXT PARTITION: ROW LOCATION ROW LOCATION (cr=17 pr=9 pw=0 time=52080 us cost=40 size=5476 card=37) 14 14 14 INDEX RANGE SCAN HISTORY_TEXT_2 (cr=3 pr=0 pw=0 time=28 us cost=3 size=0 card=37)(object id 58973) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 COUNT (STOPKEY) 2 FILTER 2 VIEW 2 SORT (ORDER BY) 14 TABLE ACCESS MODE: ANALYZED (BY GLOBAL INDEX ROWID) OF 'HISTORY_TEXT' (TABLE) PARTITION:ROW LOCATION 14 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HISTORY_TEXT_2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ latch: shared pool 1 0.00 0.00 SQL*Net message to client 8 0.00 0.00 SQL*Net message from client 8 0.00 0.00 db file sequential read 14 0.01 0.08 db file parallel read 1 0.02 0.02 ******************************************************************************** SQL ID: 41y1mybr9f3vc Plan Hash: 2258473822 SELECT m.newvalue FROM mappings m WHERE m.valuemapid=:"SYS_B_0" AND m.value=:"SYS_B_1" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 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 8 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 8 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 4 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID MAPPINGS (cr=2 pr=0 pw=0 time=34 us cost=2 size=16 card=1) 2 5 7 INDEX RANGE SCAN MAPPINGS_1 (cr=1 pr=0 pw=0 time=20 us cost=1 size=0 card=1)(object id 58913) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'MAPPINGS' (TABLE) 2 INDEX MODE: ANALYZED (RANGE SCAN) OF 'MAPPINGS_1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 0.13 0.25 ******************************************************************************** SQL ID: by98hrtkbw3ru Plan Hash: 1992694983 UPDATE profiles SET value_id=:"SYS_B_0", type=:"SYS_B_1" WHERE userid=:"SYS_B_2" AND idx=:"SYS_B_3" 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 4 4 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 4 4 2 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE PROFILES (cr=2 pr=0 pw=0 time=46 us) 1 1 1 INDEX RANGE SCAN PROFILES_1 (cr=2 pr=0 pw=0 time=16 us cost=2 size=1024 card=32)(object id 58873) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: ALL_ROWS 0 UPDATE OF 'PROFILES' 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PROFILES_1' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: 99jz2t335pfy3 Plan Hash: 2628920147 SELECT * FROM (SELECT * FROM history h WHERE h.itemid=:"SYS_B_0" ORDER BY h.clock DESC) WHERE rownum BETWEEN :"SYS_B_1" AND :"SYS_B_2" 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.03 4 482 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.03 4 482 0 4 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 COUNT STOPKEY (cr=240 pr=2 pw=0 time=17622 us) 2 2 2 FILTER (cr=240 pr=2 pw=0 time=17608 us) 2 2 2 PARTITION RANGE ALL PARTITION: 1048575 1 (cr=240 pr=2 pw=0 time=17604 us cost=7300 size=376948 card=7249) 2 2 2 VIEW (cr=240 pr=2 pw=0 time=17593 us cost=7300 size=376948 card=7249) 2 2 2 SORT ORDER BY (cr=240 pr=2 pw=0 time=17592 us cost=7300 size=166727 card=7249) 236 236 236 TABLE ACCESS BY LOCAL INDEX ROWID HISTORY PARTITION: 1048575 1 (cr=240 pr=2 pw=0 time=17480 us cost=7299 size=166727 card=7249) 236 236 236 INDEX RANGE SCAN HISTORY_1 PARTITION: 1048575 1 (cr=4 pr=0 pw=0 time=86 us cost=55 size=0 card=7249)(object id 59320) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 2 COUNT (STOPKEY) 2 FILTER 2 PARTITION RANGE (ALL) PARTITION: START=1048575 STOP=1 2 VIEW 2 SORT (ORDER BY) 236 TABLE ACCESS MODE: ANALYZED (BY LOCAL INDEX ROWID) OF 'HISTORY' (TABLE) PARTITION: START=1048575 STOP=1 236 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HISTORY_1' (INDEX) PARTITION: START=1048575 STOP=1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 Disk file operations I/O 2 0.00 0.00 db file sequential read 4 0.01 0.03 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: adf3vtuywmax6 Plan Hash: 1584660884 UPDATE sessions SET lastaccess=:"SYS_B_0" WHERE userid=:"SYS_B_1" AND sessionid=:"SYS_B_2" 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 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 3 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE SESSIONS (cr=3 pr=0 pw=0 time=87 us) 1 1 1 TABLE ACCESS BY INDEX ROWID SESSIONS (cr=3 pr=0 pw=0 time=11 us cost=2 size=44 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0041067 (cr=2 pr=0 pw=0 time=7 us cost=1 size=0 card=1)(object id 59145) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: ALL_ROWS 0 UPDATE OF 'SESSIONS' 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SESSIONS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0041067' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: ds3816ar1dsdp Plan Hash: 3313634296 SELECT DISTINCT h.hostid,h.name,h.status FROM hosts h,hosts_groups hg WHERE h.flags IN (:"SYS_B_0",:"SYS_B_1") AND hg.groupid=:"SYS_B_2" AND hg.hostid=h.hostid AND h.status IN (:"SYS_B_3", :"SYS_B_4") AND EXISTS (SELECT NULL FROM items i WHERE h.hostid=i.hostid AND i.status=:"SYS_B_5" AND i.flags IN (:"SYS_B_6",:"SYS_B_7")) 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 165 0 34 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 165 0 34 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 34 34 34 HASH UNIQUE (cr=165 pr=0 pw=0 time=832 us cost=7 size=90 card=1) 34 34 34 NESTED LOOPS SEMI (cr=165 pr=0 pw=0 time=514 us cost=6 size=90 card=1) 34 34 34 NESTED LOOPS (cr=64 pr=0 pw=0 time=264 us cost=3 size=79 card=1) 34 34 34 TABLE ACCESS BY INDEX ROWID HOSTS_GROUPS (cr=5 pr=0 pw=0 time=51 us cost=2 size=9 card=1) 34 34 34 INDEX RANGE SCAN HOSTS_GROUPS_2 (cr=2 pr=0 pw=0 time=28 us cost=1 size=0 card=1)(object id 58918) 34 34 34 TABLE ACCESS BY INDEX ROWID HOSTS (cr=59 pr=0 pw=0 time=198 us cost=1 size=70 card=1) 34 34 34 INDEX UNIQUE SCAN SYS_C0040978 (cr=37 pr=0 pw=0 time=71 us cost=0 size=0 card=1)(object id 59056) 34 34 34 TABLE ACCESS BY INDEX ROWID ITEMS (cr=101 pr=0 pw=0 time=224 us cost=3 size=2684385 card=244035) 34 34 34 INDEX RANGE SCAN ITEMS_1 (cr=70 pr=0 pw=0 time=144 us cost=2 size=0 card=1)(object id 58950) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 34 HASH (UNIQUE) 34 NESTED LOOPS (SEMI) 34 NESTED LOOPS 34 TABLE ACCESS MODE: ANALYZED (FULL) OF 'HOSTS' (TABLE) 34 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'HOSTS_GROUPS_1' (INDEX (UNIQUE)) 34 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS' (TABLE) 34 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 1p7r7f6w38bs1 Plan Hash: 1172225302 SELECT h.hostid,h.name,h.status FROM hosts h WHERE h.flags IN (:"SYS_B_0",:"SYS_B_1") AND h.hostid=:"SYS_B_2" AND h.status IN (:"SYS_B_3",:"SYS_B_4") AND EXISTS (SELECT NULL FROM items i WHERE h.hostid=i.hostid AND i.status=:"SYS_B_5" AND i.flags IN (:"SYS_B_6", :"SYS_B_7")) 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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS SEMI (cr=7 pr=0 pw=0 time=54 us cost=6 size=81 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HOSTS (cr=3 pr=0 pw=0 time=25 us cost=2 size=70 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0040978 (cr=2 pr=0 pw=0 time=9 us cost=1 size=0 card=1)(object id 59056) 1 1 1 TABLE ACCESS BY INDEX ROWID ITEMS (cr=4 pr=0 pw=0 time=28 us cost=4 size=1188 card=108) 1 1 1 INDEX RANGE SCAN ITEMS_1 (cr=3 pr=0 pw=0 time=10 us cost=3 size=0 card=1)(object id 58950) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS (SEMI) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HOSTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040978' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 6gwp0kwk749ry Plan Hash: 2073256018 SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid= hg.hostid AND h.status IN (:"SYS_B_0",:"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 2 0.01 0.01 0 51 0 118 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.01 0 51 0 118 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 118 118 118 HASH UNIQUE (cr=51 pr=0 pw=0 time=12874 us cost=30 size=435300 card=5804) 5841 5841 5841 HASH JOIN (cr=51 pr=0 pw=0 time=10337 us cost=29 size=435300 card=5804) 2049 2049 2049 VIEW index$_join$_003 (cr=25 pr=0 pw=0 time=3555 us cost=20 size=16424 card=2053) 2049 2049 2049 HASH JOIN (cr=25 pr=0 pw=0 time=3167 us) 2049 2049 2049 INLIST ITERATOR (cr=12 pr=0 pw=0 time=604 us) 2049 2049 2049 INDEX RANGE SCAN HOSTS_2 (cr=12 pr=0 pw=0 time=337 us cost=10 size=16424 card=2053)(object id 58964) 2121 2121 2121 INDEX FAST FULL SCAN SYS_C0040978 (cr=13 pr=0 pw=0 time=271 us cost=11 size=16424 card=2053)(object id 59056) 5911 5911 5911 HASH JOIN (cr=26 pr=0 pw=0 time=3114 us cost=9 size=388868 card=5804) 133 133 133 TABLE ACCESS FULL GROUPS (cr=4 pr=0 pw=0 time=54 us cost=2 size=7482 card=129) 5911 5911 5911 TABLE ACCESS FULL HOSTS_GROUPS (cr=22 pr=0 pw=0 time=558 us cost=6 size=52236 card=5804) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 118 HASH (UNIQUE) 5841 HASH JOIN 2049 TABLE ACCESS MODE: ANALYZED (FULL) OF 'GROUPS' (TABLE) 2049 HASH JOIN 2049 VIEW OF 'index$_join$_003' (VIEW) 2049 HASH JOIN 2121 INLIST ITERATOR 5911 INDEX MODE: ANALYZED (RANGE SCAN) OF 'HOSTS_2' (INDEX) 133 INDEX MODE: ANALYZED (FAST FULL SCAN) OF 'SYS_C0040978' (INDEX (UNIQUE)) 5911 TABLE ACCESS MODE: ANALYZED (FULL) OF 'HOSTS_GROUPS' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: 2vhb49qrjc1ah Plan Hash: 3058279744 SELECT COUNT(DISTINCT h.hostid) AS rowscount FROM hosts h WHERE h.flags IN (:"SYS_B_0",:"SYS_B_1") AND h.hostid=:"SYS_B_2" AND h.status IN (:"SYS_B_3",:"SYS_B_4",:"SYS_B_5") 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: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=55 us) 1 1 1 VIEW VW_DAG_0 (cr=3 pr=0 pw=0 time=49 us cost=2 size=13 card=1) 1 1 1 SORT GROUP BY NOSORT (cr=3 pr=0 pw=0 time=46 us cost=2 size=11 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HOSTS (cr=3 pr=0 pw=0 time=41 us cost=2 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0040978 (cr=2 pr=0 pw=0 time=12 us cost=1 size=0 card=1)(object id 59056) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 1 VIEW OF 'VW_DAG_0' (VIEW) 1 SORT (GROUP BY NOSORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'HOSTS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040978' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 0xbvft0myjp47 Plan Hash: 383077306 UPDATE user_history SET url5=:"SYS_B_0" WHERE userid=:"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 1 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 3 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE USER_HISTORY (cr=1 pr=0 pw=0 time=67 us) 1 1 1 INDEX UNIQUE SCAN USER_HISTORY_1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=26 card=1)(object id 58869) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT MODE: ALL_ROWS 0 UPDATE OF 'USER_HISTORY' 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'USER_HISTORY_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ log file sync 1 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fv3yw4hj3861f Plan Hash: 971352749 SELECT COUNT(DISTINCT g.groupid) AS rowscount FROM groups g WHERE g.groupid=:"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 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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=1 pr=0 pw=0 time=66 us) 1 1 1 VIEW VW_DAG_0 (cr=1 pr=0 pw=0 time=45 us cost=0 size=13 card=1) 1 1 1 SORT GROUP BY NOSORT (cr=1 pr=0 pw=0 time=41 us cost=0 size=4 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0040979 (cr=1 pr=0 pw=0 time=20 us cost=0 size=4 card=1)(object id 59057) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 1 VIEW OF 'VW_DAG_0' (VIEW) 1 SORT (GROUP BY NOSORT) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040979' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: acp9m9w5hf199 Plan Hash: 680778392 SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid=:"SYS_B_0" AND s.status=:"SYS_B_1" AND s.userid=u.userid AND (s.lastaccess+u.autologout>:"SYS_B_2" OR u.autologout= :"SYS_B_3") 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 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 5 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=46 us cost=3 size=52 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID SESSIONS (cr=3 pr=0 pw=0 time=33 us cost=2 size=45 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0041067 (cr=2 pr=0 pw=0 time=19 us cost=1 size=0 card=1)(object id 59145) 1 1 1 TABLE ACCESS BY INDEX ROWID USERS (cr=2 pr=0 pw=0 time=8 us cost=1 size=1127 card=161) 1 1 1 INDEX UNIQUE SCAN SYS_C0040995 (cr=1 pr=0 pw=0 time=3 us cost=0 size=0 card=1)(object id 59073) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'SESSIONS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0041067' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USERS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040995' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 9fht2xc4j4bjv Plan Hash: 458849213 SELECT * FROM (SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=:"SYS_B_0" AND g.usrgrpid=ug.usrgrpid AND g.users_status=:"SYS_B_1") WHERE rownum BETWEEN :"SYS_B_2" AND :"SYS_B_3" 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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 COUNT STOPKEY (cr=3 pr=0 pw=0 time=55 us) 0 0 0 FILTER (cr=3 pr=0 pw=0 time=51 us) 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=50 us cost=2 size=13 card=1) 1 1 1 TABLE ACCESS FULL USRGRP (cr=2 pr=0 pw=0 time=40 us cost=2 size=6 card=1) 0 0 0 INDEX UNIQUE SCAN USERS_GROUPS_1 (cr=1 pr=0 pw=0 time=8 us cost=0 size=7 card=1)(object id 58943) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 COUNT (STOPKEY) 0 FILTER 0 NESTED LOOPS 1 NESTED LOOPS 0 INDEX MODE: ANALYZED (SKIP SCAN) OF 'USERS_GROUPS_1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040996' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USRGRP' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 6gv6runa9320w Plan Hash: 4220917831 SELECT i.itemid,i.name,i.type,i.value_type,i.units,i.hostid,i.state, i.valuemapid,i.status,i.error,i.trends,i.history,i.delay,i.key_,i.flags FROM items i WHERE i.flags IN (:"SYS_B_0",:"SYS_B_1") AND i.hostid=:"SYS_B_2" AND i.status=:"SYS_B_3" 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 5 0.00 0.00 0 115 0 424 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 115 0 424 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 424 424 424 TABLE ACCESS BY INDEX ROWID ITEMS (cr=115 pr=0 pw=0 time=980 us cost=58 size=10584 card=108) 434 434 434 INDEX RANGE SCAN ITEMS_1 (cr=12 pr=0 pw=0 time=209 us cost=4 size=0 card=114)(object id 58950) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 424 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ITEMS' (TABLE) 434 INDEX MODE: ANALYZED (RANGE SCAN) OF 'ITEMS_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.02 0.10 ******************************************************************************** SQL ID: 877k007a5vmgp Plan Hash: 2777635855 SELECT table_name FROM user_tables WHERE table_name=:"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 14 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 14 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS OUTER (cr=14 pr=0 pw=0 time=3210 us cost=9 size=156 card=1) 1 1 1 NESTED LOOPS OUTER (cr=13 pr=0 pw=0 time=3200 us cost=8 size=153 card=1) 1 1 1 NESTED LOOPS OUTER (cr=11 pr=0 pw=0 time=3190 us cost=7 size=145 card=1) 1 1 1 NESTED LOOPS OUTER (cr=11 pr=0 pw=0 time=3187 us cost=6 size=140 card=1) 1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=3172 us cost=5 size=129 card=1) 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=3162 us cost=4 size=126 card=1) 1 1 1 MERGE JOIN CARTESIAN (cr=3 pr=0 pw=0 time=3146 us cost=3 size=98 card=1) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=3084 us cost=1 size=68 card=1) 1 1 1 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1224 us cost=0 size=55 card=1) 2752 2752 2752 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=806 us cost=0 size=1300 card=100) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=61 us cost=3 size=30 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=40 us cost=2 size=30 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=29 us cost=1 size=0 card=1)(object id 37) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=16 us cost=1 size=28 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 3) 1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=8 us cost=1 size=3 card=1) 1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 7) 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 time=13 us cost=1 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=3 us cost=0 size=0 card=1)(object id 9) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=1 us cost=1 size=5 card=1)(object id 36) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=7 us cost=1 size=8 card=1)(object id 36) 1 1 1 INDEX RANGE SCAN I_USER2 (cr=1 pr=0 pw=0 time=7 us cost=1 size=3 card=1)(object id 47) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 NESTED LOOPS (OUTER) 1 NESTED LOOPS (OUTER) 1 NESTED LOOPS (OUTER) 1 NESTED LOOPS (OUTER) 1 NESTED LOOPS 1 NESTED LOOPS 1 MERGE JOIN (CARTESIAN) 1 HASH JOIN 1 FIXED TABLE (FULL) OF 'X$KSPPI' (TABLE (FIXED)) 2752 FIXED TABLE (FULL) OF 'X$KSPPCV' (TABLE (FIXED)) 1 BUFFER (SORT) 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'OBJ$' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ2' (INDEX (UNIQUE)) 1 TABLE ACCESS MODE: ANALYZED (CLUSTER) OF 'TAB$' (CLUSTER) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_OBJ#' (INDEX (CLUSTER)) 1 TABLE ACCESS MODE: ANALYZED (CLUSTER) OF 'TS$' (CLUSTER) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_TS#' (INDEX (CLUSTER)) 1 TABLE ACCESS MODE: ANALYZED (CLUSTER) OF 'SEG$' (CLUSTER) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'I_FILE#_BLOCK#' (INDEX (CLUSTER)) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_OBJ1' (INDEX (UNIQUE)) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'I_USER2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fjnjym0cbgvw4 Plan Hash: 3048673665 SELECT n.* FROM nodes n WHERE n.nodetype=:"SYS_B_0" ORDER BY n.nodeid 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID NODES (cr=0 pr=0 pw=0 time=6 us cost=0 size=210 card=1) 0 0 0 INDEX FULL SCAN SYS_C0041044 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 59122) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'NODES' (TABLE) 0 INDEX MODE: ANALYZED (FULL SCAN) OF 'SYS_C0041044' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.01 0.01 ******************************************************************************** SQL ID: 8h27wtajdwsah Plan Hash: 1249536092 SELECT uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=:"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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID USER_HISTORY (cr=2 pr=0 pw=0 time=18 us cost=1 size=49 card=1) 1 1 1 INDEX UNIQUE SCAN USER_HISTORY_1 (cr=1 pr=0 pw=0 time=10 us cost=0 size=0 card=1)(object id 58869) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USER_HISTORY' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'USER_HISTORY_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 68gsftsxmp28t Plan Hash: 125056112 SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=:"SYS_B_0" AND g.usrgrpid= ug.usrgrpid AND g.debug_mode=:"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: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=3 pr=0 pw=0 time=28 us cost=2 size=13 card=1) 1 1 1 TABLE ACCESS FULL USRGRP (cr=2 pr=0 pw=0 time=21 us cost=2 size=6 card=1) 0 0 0 INDEX UNIQUE SCAN USERS_GROUPS_1 (cr=1 pr=0 pw=0 time=5 us cost=0 size=7 card=1)(object id 58943) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 1 NESTED LOOPS 0 INDEX MODE: ANALYZED (SKIP SCAN) OF 'USERS_GROUPS_1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040996' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USRGRP' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: bnkrz32y453mq Plan Hash: 1249536092 SELECT uh.title1,uh.url1,uh.title2,uh.url2,uh.title3,uh.url3,uh.title4, uh.url4,uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=:"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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID USER_HISTORY (cr=2 pr=0 pw=0 time=20 us cost=1 size=238 card=1) 1 1 1 INDEX UNIQUE SCAN USER_HISTORY_1 (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 58869) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USER_HISTORY' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'USER_HISTORY_1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: bpc5nj6xvc1kh Plan Hash: 3682135940 SELECT a.* FROM applications a WHERE a.hostid=:"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.02 1 5 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 1 5 0 5 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 5 5 5 TABLE ACCESS BY INDEX ROWID APPLICATIONS (cr=5 pr=1 pw=0 time=22039 us cost=4 size=144 card=6) 5 5 5 INDEX RANGE SCAN APPLICATIONS_2 (cr=2 pr=1 pw=0 time=22023 us cost=2 size=0 card=6)(object id 58959) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 5 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'APPLICATIONS' (TABLE) 5 INDEX MODE: ANALYZED (RANGE SCAN) OF 'APPLICATIONS_2' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 db file sequential read 1 0.02 0.02 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 40zd3t7q2mkzt Plan Hash: 2938164577 SELECT p.* FROM profiles p WHERE p.userid=:"SYS_B_0" ORDER BY p.userid,p.profileid 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 40 0.00 0.00 0 113 0 4033 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 0 113 0 4033 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 4033 4033 4033 SORT ORDER BY (cr=113 pr=0 pw=0 time=3229 us cost=33 size=177452 card=4033) 4033 4033 4033 TABLE ACCESS FULL PROFILES (cr=113 pr=0 pw=0 time=914 us cost=32 size=177452 card=4033) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 4033 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PROFILES' (TABLE) 4033 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PROFILES_2' (INDEX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 40 0.00 0.00 SQL*Net message from client 40 0.01 0.61 ******************************************************************************** SQL ID: apu6sy3jfamxt Plan Hash: 4275151208 SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout, u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip, u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=:"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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID USERS (cr=2 pr=0 pw=0 time=12 us cost=1 size=114 card=1) 1 1 1 INDEX UNIQUE SCAN SYS_C0040995 (cr=1 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 59073) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USERS' (TABLE) 1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040995' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: g6u6wnqtf0sq5 Plan Hash: 3938462141 SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=:"SYS_B_0" AND g.usrgrpid= ug.usrgrpid 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 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=6 pr=0 pw=0 time=97 us) 15 15 15 NESTED LOOPS (cr=6 pr=0 pw=0 time=80 us cost=2 size=182 card=14) 44 44 44 TABLE ACCESS FULL USRGRP (cr=2 pr=0 pw=0 time=24 us cost=2 size=264 card=44) 15 15 15 INDEX UNIQUE SCAN USERS_GROUPS_1 (cr=4 pr=0 pw=0 time=39 us cost=0 size=7 card=1)(object id 58943) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 15 NESTED LOOPS 44 NESTED LOOPS 15 INDEX MODE: ANALYZED (SKIP SCAN) OF 'USERS_GROUPS_1' (INDEX (UNIQUE)) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0040996' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'USRGRP' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 84nyqdnnv826g Plan Hash: 0 ALTER SESSION SET NLS_NUMERIC_CHARACTERS='. ' 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: 44 (ZABBIX) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: g2yd9rvq16vnp Plan Hash: 2377761508 SELECT c.* FROM config c 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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL CONFIG (cr=2 pr=0 pw=0 time=50 us cost=2 size=431 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'CONFIG' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.01 0.01 ******************************************************************************** SQL ID: gw3axdtmursbp Plan Hash: 4290127207 SELECT dv.mandatory,dv.optional FROM dbversion dv 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: 44 (ZABBIX) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL DBVERSION (cr=2 pr=0 pw=0 time=24 us cost=2 size=8 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'DBVERSION' (TABLE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 456 0.03 0.07 0 0 0 0 Execute 456 0.15 0.14 0 8 10 4 Fetch 507 0.94 38.51 23546 79713 0 6322 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1419 1.12 38.73 23546 79721 10 6326 Misses in library cache during parse: 5 Misses in library cache during execute: 4 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 543 0.00 0.00 SQL*Net message from client 543 0.13 1.39 log file sync 4 0.00 0.00 Disk file operations I/O 4 0.00 0.00 db file sequential read 1041 0.14 9.26 latch: shared pool 7 0.01 0.02 db file parallel read 1200 0.20 28.45 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 45 0.01 0.00 0 0 0 0 Execute 247 0.03 0.04 0 1 2 2 Fetch 631 0.01 0.02 5 882 0 559 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 923 0.06 0.07 5 883 2 561 Misses in library cache during parse: 22 Misses in library cache during execute: 22 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 5 0.00 0.01 latch: shared pool 5 0.00 0.00 77 user SQL statements in session. 44 internal SQL statements in session. 121 SQL statements in session. 31 statements EXPLAINed in this session. ******************************************************************************** Trace file: ././zabbix_ora_10295__nginx_.trc Trace file compatibility: 11.1.0.7 Sort options: exeela 1 session in tracefile. 77 user SQL statements in trace file. 44 internal SQL statements in trace file. 121 SQL statements in trace file. 65 unique SQL statements in trace file. 31 SQL statements EXPLAINed using schema: ZABBIX.prof$plan_table Default table was used. Table was created. Table was dropped. 18103 lines in trace file. 40 elapsed seconds in trace file.