1º- Query PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 739499689 ----------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ----------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 5018 | 1511 (10)| 00:00:22 | | | |* 1 | COUNT STOPKEY | | | | | | | | |* 2 | FILTER | | | | | | | | | 3 | VIEW | | 1 | 5018 | 1511 (10)| 00:00:22 | | | | 4 | SORT ORDER BY | | 1 | 135 | 1511 (10)| 00:00:22 | | | | 5 | NESTED LOOPS ANTI | | 7 | 945 | 275 (0)| 00:00:04 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 6 | INLIST ITERATOR | | | | | | | | |* 7 | TABLE ACCESS BY GLOBAL INDEX ROWID | TRIGGERS | 12 | 1596 | 179 (0)| 00:00:03 | ROWID | ROWID | |* 8 | INDEX RANGE SCAN | TRIGGERS_IDX$$_46BE0008 | 476 | | 42 (0)| 00:00:01 | | | |* 9 | FILTER | | | | | | | | | 10 | HASH GROUP BY | | 2 | 78 | 17 (12)| 00:00:01 | | | |* 11 | HASH JOIN OUTER | | 16 | 624 | 16 (7)| 00:00:01 | | | |* 12 | HASH JOIN | | 8 | 232 | 12 (9)| 00:00:01 | | | | 13 | NESTED LOOPS | | | | | | | | | 14 | NESTED LOOPS | | 5 | 100 | 7 (0)| 00:00:01 | | | |* 15 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 5 | 50 | 2 (0)| 00:00:01 | | | |* 16 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 17 | TABLE ACCESS BY GLOBAL INDEX ROWID| ITEMS | 1 | 10 | 1 (0)| 00:00:01 | ROWID | ROWID | | 18 | INDEX FAST FULL SCAN | HOSTS_GROUPS_IDX$$_46BE000B | 3722 | 33498 | 4 (0)| 00:00:01 | | | |* 19 | TABLE ACCESS FULL | RIGHTS | 317 | 3170 | 4 (0)| 00:00:01 | | | | 20 | VIEW PUSHED PREDICATE | VW_SQ_1 | 1 | 2 | 8 (0)| 00:00:01 | | | | 21 | NESTED LOOPS | | | | | | | | | 22 | NESTED LOOPS | | 1 | 31 | 8 (0)| 00:00:01 | | | | 23 | NESTED LOOPS | | 3 | 69 | 5 (0)| 00:00:01 | | | |* 24 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 5 | 50 | 2 (0)| 00:00:01 | | | | 25 | TABLE ACCESS BY GLOBAL INDEX ROWID | ITEMS | 1 | 13 | 1 (0)| 00:00:01 | ROWID | ROWID | |* 26 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | |* 27 | INDEX UNIQUE SCAN | SYS_C008336 | 1 | | 0 (0)| 00:00:01 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |* 28 | TABLE ACCESS BY INDEX ROWID | HOSTS | 1 | 8 | 1 (0)| 00:00:01 | | | ----------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=40) 2 - filter(ROWNUM>=0) 7 - filter("T"."VALUE"=1) 8 - access("T"."STATUS"=0 AND ("T"."FLAGS"=0 OR "T"."FLAGS"=4) AND ("T"."PRIORITY"=2 OR "T"."PRIORITY"=3 OR "T"."PRIORITY"=4 OR "T"."PRIORITY"=5)) PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ filter( NOT EXISTS (SELECT 0 FROM "RIGHTS" "R","HOSTS_GROUPS" "HGG","ITEMS" "I","FUNCTIONS" "F" WHERE "F"."TRIGGERID"=:B1 AND "F"."ITEMID"="I"."ITEMID" AND "I"."HOSTID"="HGG"."HOSTID" AND "R"."ID"(+)="HGG"."GROUPID" AND ("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) GROUP BY "I"."HOSTID" HAVING MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0)) 9 - filter(MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0) 11 - access("R"."ID"(+)="HGG"."GROUPID") 12 - access("I"."HOSTID"="HGG"."HOSTID") 15 - access("F"."TRIGGERID"=:B1) 16 - access("F"."ITEMID"="I"."ITEMID") 19 - filter("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) 24 - access("F"."TRIGGERID"="T"."TRIGGERID") 26 - access("F"."ITEMID"="I"."ITEMID") PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 27 - access("I"."HOSTID"="H"."HOSTID") 28 - filter("I"."STATUS"<>0 OR "H"."STATUS"<>0) _____________________________________________________________________________________________________________________________________________ 2º Query PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 1145031185 ------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 17 | 3043 (9)| 00:00:43 | | | | 1 | SORT GROUP BY | | 1 | 17 | | | | | | 2 | INLIST ITERATOR | | | | | | | | |* 3 | TABLE ACCESS BY GLOBAL INDEX ROWID | TRIGGERS | 1 | 17 | 49 (0)| 00:00:01 | ROWID | ROWID | |* 4 | INDEX RANGE SCAN | TRIGGERS_IDX$$_46BE0008 | 24 | | 42 (0)| 00:00:01 | | | |* 5 | FILTER | | | | | | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 6 | HASH GROUP BY | | 2 | 78 | 17 (12)| 00:00:01 | | | |* 7 | HASH JOIN OUTER | | 16 | 624 | 16 (7)| 00:00:01 | | | |* 8 | HASH JOIN | | 8 | 232 | 12 (9)| 00:00:01 | | | | 9 | NESTED LOOPS | | | | | | | | | 10 | NESTED LOOPS | | 5 | 100 | 7 (0)| 00:00:01 | | | |* 11 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 5 | 50 | 2 (0)| 00:00:01 | | | |* 12 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | | 13 | TABLE ACCESS BY GLOBAL INDEX ROWID| ITEMS | 1 | 10 | 1 (0)| 00:00:01 | ROWID | ROWID | | 14 | INDEX FAST FULL SCAN | HOSTS_GROUPS_IDX$$_46BE000B | 3722 | 33498 | 4 (0)| 00:00:01 | | | |* 15 | TABLE ACCESS FULL | RIGHTS | 317 | 3170 | 4 (0)| 00:00:01 | | | | 16 | NESTED LOOPS | | | | | | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 17 | NESTED LOOPS | | 1 | 31 | 8 (0)| 00:00:01 | | | | 18 | NESTED LOOPS | | 3 | 69 | 5 (0)| 00:00:01 | | | |* 19 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 5 | 50 | 2 (0)| 00:00:01 | | | | 20 | TABLE ACCESS BY GLOBAL INDEX ROWID | ITEMS | 1 | 13 | 1 (0)| 00:00:01 | ROWID | ROWID | |* 21 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | |* 22 | INDEX UNIQUE SCAN | SYS_C008336 | 1 | | 0 (0)| 00:00:01 | | | |* 23 | TABLE ACCESS BY INDEX ROWID | HOSTS | 1 | 8 | 1 (0)| 00:00:01 | | | ------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 3 - filter("T"."VALUE"=1) 4 - access("T"."STATUS"=0 AND ("T"."FLAGS"=0 OR "T"."FLAGS"=4) AND ("T"."PRIORITY"=2 OR "T"."PRIORITY"=3 OR "T"."PRIORITY"=4 OR "T"."PRIORITY"=5)) filter( NOT EXISTS (SELECT 0 FROM "RIGHTS" "R","HOSTS_GROUPS" "HGG","ITEMS" "I","FUNCTIONS" "F" WHERE "F"."TRIGGERID"=:B1 AND "F"."ITEMID"="I"."ITEMID" AND "I"."HOSTID"="HGG"."HOSTID" AND "R"."ID"(+)="HGG"."GROUPID" AND ("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) GROUP BY "I"."HOSTID" HAVING MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0) AND NOT EXISTS (SELECT 0 FROM "HOSTS" "H","ITEMS" "I","FUNCTIONS" "F" WHERE "F"."TRIGGERID"=:B2 AND "F"."ITEMID"="I"."ITEMID" AND "I"."HOSTID"="H"."HOSTID" AND ("I"."STATUS"<>0 OR "H"."STATUS"<>0))) 5 - filter(MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0) 7 - access("R"."ID"(+)="HGG"."GROUPID") PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 8 - access("I"."HOSTID"="HGG"."HOSTID") 11 - access("F"."TRIGGERID"=:B1) 12 - access("F"."ITEMID"="I"."ITEMID") 15 - filter("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) 19 - access("F"."TRIGGERID"=:B1) 21 - access("F"."ITEMID"="I"."ITEMID") 22 - access("I"."HOSTID"="H"."HOSTID") 23 - filter("I"."STATUS"<>0 OR "H"."STATUS"<>0) _____________________________________________________________________________________________________________________________________________ 3º -Query PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 2760635976 ------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 20 | 2080 | 140K (1)| 00:32:41 | | | |* 1 | COUNT STOPKEY | | | | | | | | |* 2 | FILTER | | | | | | | | | 3 | VIEW | | 205 | 21320 | 140K (1)| 00:32:41 | | | |* 4 | TABLE ACCESS BY GLOBAL INDEX ROWID| EVENTS | 205 | 6355 | 140K (1)| 00:32:41 | ROWID | ROWID | |* 5 | INDEX RANGE SCAN DESCENDING | IDX$$_00010001 | 173K| | 1124 (1)| 00:00:16 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=20) 2 - filter(ROWNUM>=0) 4 - filter("E"."OBJECTID"=88450) 5 - access("E"."OBJECT"=0 AND "E"."SOURCE"=0 AND "E"."EVENTID"<=59311430) filter("E"."EVENTID"<=59311430) PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Note ----- - SQL profile "SYS_SQLPROF_0152ef8a8773000b" used for this statement _____________________________________________________________________________________________________________________________________________ 4º Query PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 2760635976 ------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 20 | 2080 | 136K (1)| 00:31:53 | | | |* 1 | COUNT STOPKEY | | | | | | | | |* 2 | FILTER | | | | | | | | | 3 | VIEW | | 200 | 20800 | 136K (1)| 00:31:53 | | | |* 4 | TABLE ACCESS BY GLOBAL INDEX ROWID| EVENTS | 200 | 6200 | 136K (1)| 00:31:53 | ROWID | ROWID | |* 5 | INDEX RANGE SCAN DESCENDING | IDX$$_00010001 | 169K| | 1124 (1)| 00:00:16 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=20) 2 - filter(ROWNUM>=0) 4 - filter("E"."OBJECTID"=88352) 5 - access("E"."OBJECT"=0 AND "E"."SOURCE"=0 AND "E"."EVENTID"<=58345108) filter("E"."EVENTID"<=58345108) PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Note ----- - SQL profile "SYS_SQLPROF_0152ef8a8773000b" used for this statement 25 rows selected. _____________________________________________________________________________________________________________________________________________ 5º Query PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 2760635976 ------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 20 | 2080 | 134K (1)| 00:31:20 | | | |* 1 | COUNT STOPKEY | | | | | | | | |* 2 | FILTER | | | | | | | | | 3 | VIEW | | 196 | 20384 | 134K (1)| 00:31:20 | | | |* 4 | TABLE ACCESS BY GLOBAL INDEX ROWID| EVENTS | 196 | 6076 | 134K (1)| 00:31:20 | ROWID | ROWID | |* 5 | INDEX RANGE SCAN DESCENDING | IDX$$_00010001 | 166K| | 1124 (1)| 00:00:16 | | | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=20) 2 - filter(ROWNUM>=0) 4 - filter("E"."OBJECTID"=30149) 5 - access("E"."OBJECT"=0 AND "E"."SOURCE"=0 AND "E"."EVENTID"<=57804982) filter("E"."EVENTID"<=57804982) PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Note ----- - SQL profile "SYS_SQLPROF_0152ef8a8773000b" used for this statement 25 rows selected.