Statistics ----------------------------------------------------------- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 0 total read fandles 0 read fandles in use 0 fandle allocation failures 0 parse count (hard) 0 parse count (failures) COUNT(*) ---------------------- 216 1 rows selected Plan hash value: 1483622391 --------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 13 | 2 (0)| 00:00:01 | | 1 | SORT AGGREGATE | | 1 | 13 | | | |* 2 | FILTER | | | | | | | 3 | INDEX FAST FULL SCAN | UNQ_ORGANIZATOR_1 | 613 | 7969 | 2 (0)| 00:00:01 | |* 4 | FILTER | | | | | | | 5 | HASH GROUP BY | | 492 | 19188 | 15 (7)| 00:00:01 | | 6 | NESTED LOOPS | | 492 | 19188 | 14 (0)| 00:00:01 | | 7 | TABLE ACCESS FULL | UDALOST | 953 | 24778 | 14 (0)| 00:00:01 | |* 8 | INDEX UNIQUE SCAN | PK_PROMITANI | 1 | 13 | 0 (0)| 00:00:01 | |* 9 | FILTER | | | | | | | 10 | HASH GROUP BY | | 461 | 17979 | 15 (7)| 00:00:01 | | 11 | NESTED LOOPS | | 461 | 17979 | 14 (0)| 00:00:01 | | 12 | TABLE ACCESS FULL| UDALOST | 953 | 24778 | 14 (0)| 00:00:01 | |* 13 | INDEX UNIQUE SCAN| PK_PREDNASKA | 1 | 13 | 0 (0)| 00:00:01 | --------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter( EXISTS (SELECT 0 FROM "UDALOST" "U","PROMITANI" "P" WHERE "P"."UDALOST_ID"="U"."UDALOST_ID" GROUP BY "U"."ORGANIZATOR_ID" HAVING "U"."ORGANIZATOR_ID"=:B1 AND COUNT(*)>1) OR EXISTS (SELECT 0 FROM "UDALOST" "U","PREDNASKA" "P" WHERE "P"."UDALOST_ID"="U"."UDALOST_ID" GROUP BY "U"."ORGANIZATOR_ID" HAVING "U"."ORGANIZATOR_ID"=:B2 AND COUNT(*)>1)) 4 - filter("U"."ORGANIZATOR_ID"=:B1 AND COUNT(*)>1) 8 - access("P"."UDALOST_ID"="U"."UDALOST_ID") 9 - filter("U"."ORGANIZATOR_ID"=:B1 AND COUNT(*)>1) 13 - access("P"."UDALOST_ID"="U"."UDALOST_ID") Note ----- - dynamic sampling used for this statement Statistics ----------------------------------------------------------- 0 recursive calls 0 db block gets 69748 consistent gets 0 physical reads 0 redo size 0 total read fandles 0 read fandles in use 0 fandle allocation failures 0 parse count (hard) 0 parse count (failures) COUNT(*) ---------------------- 216 1 rows selected Plan hash value: 345052780 ----------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 26 | 33 (16)| 00:00:01 | | 1 | SORT AGGREGATE | | 1 | 26 | | | | 2 | NESTED LOOPS | | 953 | 24778 | 33 (16)| 00:00:01 | | 3 | VIEW | VW_NSO_1 | 953 | 12389 | 33 (16)| 00:00:01 | | 4 | SORT UNIQUE | | 953 | 37167 | 33 (58)| 00:00:01 | | 5 | UNION-ALL | | | | | | |* 6 | FILTER | | | | | | | 7 | HASH GROUP BY | | 492 | 19188 | 16 (13)| 00:00:01 | | 8 | NESTED LOOPS | | 492 | 19188 | 14 (0)| 00:00:01 | | 9 | TABLE ACCESS FULL| UDALOST | 953 | 24778 | 14 (0)| 00:00:01 | |* 10 | INDEX UNIQUE SCAN| PK_PROMITANI | 1 | 13 | 0 (0)| 00:00:01 | |* 11 | FILTER | | | | | | | 12 | HASH GROUP BY | | 461 | 17979 | 16 (13)| 00:00:01 | | 13 | NESTED LOOPS | | 461 | 17979 | 14 (0)| 00:00:01 | | 14 | TABLE ACCESS FULL| UDALOST | 953 | 24778 | 14 (0)| 00:00:01 | |* 15 | INDEX UNIQUE SCAN| PK_PREDNASKA | 1 | 13 | 0 (0)| 00:00:01 | |* 16 | INDEX UNIQUE SCAN | UNQ_ORGANIZATOR_1 | 1 | 13 | 0 (0)| 00:00:01 | ----------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 6 - filter(COUNT(*)>1) 10 - access("P"."UDALOST_ID"="U"."UDALOST_ID") 11 - filter(COUNT(*)>1) 15 - access("P"."UDALOST_ID"="U"."UDALOST_ID") 16 - access("ORGANIZATOR_ID"="$nso_col_1") Note ----- - dynamic sampling used for this statement Statistics ----------------------------------------------------------- 0 recursive calls 0 db block gets 346 consistent gets 0 physical reads 0 redo size 0 total read fandles 0 read fandles in use 0 fandle allocation failures 0 parse count (hard) 0 parse count (failures)