1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Why tho following SQL statement is carried 25 minutes, instead of 10 sec.:

Discussion in 'SQL PL/SQL' started by jesthr@gmail.com, Jun 6, 2012.

  1. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    Dear,

    Why tho following SQL statement is carried 25 minutes, instead of 10 sec.:


    SELECT count(*) FROM all_objects o2, all_objects o3, all_synonyms s
    WHERE o2.object_type = 'SYNONYM'
    AND o3.object_type IN ('TABLE', 'VIEW')
    AND o2.owner = s.owner
    AND o2.object_name = s.synonym_name
    AND s.table_owner = o3.owner
    AND s.table_name = o3.object_name;

    Regards!

    Hine
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Might be you are selecting Cartesian product. What about the following?

    Code (SQL):
    SELECT COUNT(*) FROM all_objects o2, all_objects o3, all_synonyms s
    WHERE o2.object_type = 'SYNONYM'
    AND o3.object_type IN ('TABLE', 'VIEW')
    AND o3.owner = o2.owner
    AND o2.owner = s.owner
    AND o2.object_name = s.synonym_name
    AND s.table_owner = o3.owner
    AND s.TABLE_NAME = o3.object_name;
     
  3. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    The same result!

    Regards!

    Hine
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    However that is not likely the case here:

    SQL>
    SQL> SELECT count(*) FROM all_objects o2, all_objects o3, all_synonyms s
    2 WHERE o2.object_type = 'SYNONYM'
    3 AND o3.object_type IN ('TABLE', 'VIEW')
    4 AND o2.owner = s.owner
    5 AND o2.object_name = s.synonym_name
    6 AND s.table_owner = o3.owner
    7 AND s.table_name = o3.object_name;
    COUNT(*)
    ----------
    3153
    Elapsed: 00:04:33.71
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 3059806241
    --------------------------------------------------------------------------------------------------------------------------------------
    | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
    --------------------------------------------------------------------------------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 1 | 244 | | 447 (2)| 00:00:06 |
    | 1 | SORT AGGREGATE | | 1 | 244 | | | |
    |* 2 | FILTER | | | | | | |
    | 3 | NESTED LOOPS | | 1 | 244 | | 444 (2)| 00:00:06 |
    |* 4 | HASH JOIN | | 1 | 222 | | 443 (2)| 00:00:06 |
    |* 5 | HASH JOIN | | 4 | 688 | | 197 (0)| 00:00:03 |
    |* 6 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 683 | 57372 | | 181 (0)| 00:00:03 |
    |* 7 | INDEX SKIP SCAN | I_OBJ2 | 273 | | | 141 (0)| 00:00:02 |
    |* 8 | TABLE ACCESS BY INDEX ROWID | SUM$ | 1 | 26 | | 1 (0)| 00:00:01 |
    |* 9 | INDEX UNIQUE SCAN | I_SUM$_1 | 1 | | | 1 (0)| 00:00:01 |
    | 10 | NESTED LOOPS | | 13652 | 1173K| | 16 (0)| 00:00:01 |
    | 11 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    | 12 | VIEW | ALL_SYNONYMS | 210 | 14700 | | 1 (0)| 00:00:01 |
    | 13 | SORT UNIQUE | | | | | | |
    | 14 | UNION-ALL PARTITION | | | | | | |
    |* 15 | FILTER | | | | | | |
    |* 16 | HASH JOIN | | 1424 | 159K| | 54 (4)| 00:00:01 |
    | 17 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |* 18 | HASH JOIN | | 1424 | 129K| | 52 (2)| 00:00:01 |
    | 19 | NESTED LOOPS | | 1440 | 83520 | | 7 (0)| 00:00:01 |
    | 20 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 21 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 22 | INDEX RANGE SCAN | I_OBJ5 | 1440 | 57600 | | 6 (0)| 00:00:01 |
    | 23 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    |* 24 | FIXED TABLE FULL | X$KZSPR | 17 | 119 | | 0 (0)| 00:00:01 |
    |* 25 | FILTER | | | | | | |
    |* 26 | FILTER | | | | | | |
    | 27 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 |
    | 28 | NESTED LOOPS | | 1 | 80 | | 3 (0)| 00:00:01 |
    | 29 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 |
    | 30 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 31 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 32 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    |* 33 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |* 34 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |* 35 | FIXED TABLE FULL | X$KZSRO | 1 | 3 | | 0 (0)| 00:00:01 |
    | 36 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 37 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 38 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    | 39 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 40 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 41 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 42 | FILTER | | | | | | |
    | 43 | NESTED LOOPS | | 1 | 128 | | 1481 (1)| 00:00:18 |
    | 44 | NESTED LOOPS | | 1 | 106 | | 1480 (1)| 00:00:18 |
    |* 45 | HASH JOIN | | 29 | 2059 | | 1474 (1)| 00:00:18 |
    | 46 | VIEW | _ALL_SYNONYMS_TREE | 555 | 7215 | | 1469 (1)| 00:00:18 |
    |* 47 | CONNECT BY WITHOUT FILTERING | | | | | | |
    |* 48 | FILTER | | | | | | |
    |* 49 | HASH JOIN | | 21 | 2415 | | 99 (3)| 00:00:02 |
    |* 50 | HASH JOIN | | 21 | 1953 | | 98 (3)| 00:00:02 |
    | 51 | MERGE JOIN | | 1368 | 79344 | | 53 (2)| 00:00:01 |
    | 52 | TABLE ACCESS CLUSTER | USER$ | 65 | 1170 | | 1 (0)| 00:00:01 |
    | 53 | INDEX FULL SCAN | I_USER# | 1 | | | 1 (0)| 00:00:01 |
    |* 54 | SORT JOIN | | 1368 | 54720 | | 52 (2)| 00:00:01 |
    | 55 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1368 | 54720 | | 51 (0)| 00:00:01 |
    |* 56 | INDEX SKIP SCAN | I_OBJ1 | 1368 | | | 47 (0)| 00:00:01 |
    |* 57 | FILTER | | | | | | |
    | 58 | TABLE ACCESS BY INDEX ROWID | SYN$ | 1 | 35 | | 1 (0)| 00:00:01 |
    |* 59 | INDEX UNIQUE SCAN | I_SYN1 | 1 | | | 1 (0)| 00:00:01 |
    |* 60 | FILTER | | | | | | |
    |* 61 | FILTER | | | | | | |
    | 62 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 |
    | 63 | NESTED LOOPS | | 1 | 80 | | 3 (0)| 00:00:01 |
    | 64 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 |
    | 65 | TABLE ACCESS BY INDEX ROWID| USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 66 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 67 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    |* 68 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |* 69 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |* 70 | FIXED TABLE FULL | X$KZSRO | 1 | 3 | | 0 (0)| 00:00:01 |
    | 71 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 72 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 73 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 74 | FIXED TABLE FULL | X$KZSPR | 17 | 119 | | 0 (0)| 00:00:01 |
    | 75 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    | 76 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    | 77 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 78 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 79 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 80 | FILTER | | | | | | |
    |* 81 | HASH JOIN | | 554 | 63710 | | 302 (1)| 00:00:04 |
    | 82 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |* 83 | HASH JOIN | | 554 | 51522 | | 301 (1)| 00:00:04 |
    | 84 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    |* 85 | HASH JOIN | | 27694 | 2028K| 1248K| 297 (1)| 00:00:04 |
    | 86 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    | 87 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 27357 | 1068K| | 124 (0)| 00:00:02 |
    |* 88 | INDEX SKIP SCAN | I_OBJ1 | 27357 | | | 47 (0)| 00:00:01 |
    | 89 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 90 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 91 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    | 92 | NESTED LOOPS | | 1440 | 83520 | | 7 (0)| 00:00:01 |
    | 93 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 94 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 95 | INDEX RANGE SCAN | I_OBJ5 | 1440 | 57600 | | 6 (0)| 00:00:01 |
    | 96 | TABLE ACCESS BY INDEX ROWID | SYN$ | 1 | 35 | | 1 (0)| 00:00:01 |
    |* 97 | INDEX UNIQUE SCAN | I_SYN1 | 1 | | | 1 (0)| 00:00:01 |
    |* 98 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    | 99 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |*100 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |*101 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*102 | VIEW | ALL_OBJECTS | 32831 | 1603K| | 245 (3)| 00:00:03 |
    |*103 | FILTER | | | | | | |
    |*104 | HASH JOIN | | 68318 | 8272K| | 245 (3)| 00:00:03 |
    | 105 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    |*106 | HASH JOIN | | 68318 | 7071K| | 241 (3)| 00:00:03 |
    | 107 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |*108 | TABLE ACCESS FULL | OBJ$ | 68318 | 5604K| | 240 (3)| 00:00:03 |
    |*109 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 8 | | 1 (0)| 00:00:01 |
    |*110 | INDEX UNIQUE SCAN | I_IND1 | 1 | | | 1 (0)| 00:00:01 |
    | 111 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 112 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*113 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*114 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*115 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 116 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 117 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*118 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 119 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 120 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*121 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*122 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 123 | NESTED LOOPS | | | | | | |
    | 124 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 125 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 126 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 127 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*128 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 129 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 130 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*131 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*132 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*133 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*134 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*135 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 136 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    | 137 | NESTED LOOPS | | 2 | 34 | | 1 (0)| 00:00:01 |
    |*138 | TABLE ACCESS BY INDEX ROWID | TRIGGER$ | 1 | 14 | | 1 (0)| 00:00:01 |
    |*139 | INDEX UNIQUE SCAN | I_TRIGGER2 | 1 | | | 1 (0)| 00:00:01 |
    | 140 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*141 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*142 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 143 | NESTED LOOPS | | 1 | 25 | | 2 (0)| 00:00:01 |
    | 144 | NESTED LOOPS | | 2 | 26 | | 1 (0)| 00:00:01 |
    | 145 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*146 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 1 | | | 1 (0)| 00:00:01 |
    | 147 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*148 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 149 | NESTED LOOPS | | | | | | |
    | 150 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 151 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 152 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 153 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*154 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 155 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 156 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*157 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*158 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*159 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*160 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*161 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*162 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*163 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*164 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*165 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*166 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*167 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*168 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*169 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*170 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 171 | VIEW | | 1 | 13 | | 2 (0)| 00:00:01 |
    | 172 | FAST DUAL | | 1 | | | 2 (0)| 00:00:01 |
    |*173 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*174 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*175 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*176 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*177 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*178 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*179 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*180 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*181 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*182 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*183 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 184 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 185 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*186 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*187 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 188 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 189 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*190 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*191 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 192 | VIEW | | 1 | 16 | | 3 (0)| 00:00:01 |
    | 193 | SORT GROUP BY | | 1 | 35 | | 3 (0)| 00:00:01 |
    | 194 | NESTED LOOPS | | 3 | 105 | | 3 (0)| 00:00:01 |
    | 195 | NESTED LOOPS | | 3 | 69 | | 2 (0)| 00:00:01 |
    |*196 | INDEX UNIQUE SCAN | I_OLAP_CUBES$ | 1 | 13 | | 1 (0)| 00:00:01 |
    | 197 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 3 | 30 | | 1 (0)| 00:00:01 |
    |*198 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*199 | INDEX RANGE SCAN | I_OBJ1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 200 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |*201 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |*202 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*203 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |*204 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 8 | | 1 (0)| 00:00:01 |
    |*205 | INDEX UNIQUE SCAN | I_IND1 | 1 | | | 1 (0)| 00:00:01 |
    | 206 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 207 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*208 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*209 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*210 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 211 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 212 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*213 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 214 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 215 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*216 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*217 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 218 | NESTED LOOPS | | | | | | |
    | 219 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 220 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 221 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 222 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*223 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 224 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 225 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*226 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*227 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*228 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*229 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*230 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 231 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    | 232 | NESTED LOOPS | | 2 | 34 | | 1 (0)| 00:00:01 |
    |*233 | TABLE ACCESS BY INDEX ROWID | TRIGGER$ | 1 | 14 | | 1 (0)| 00:00:01 |
    |*234 | INDEX UNIQUE SCAN | I_TRIGGER2 | 1 | | | 1 (0)| 00:00:01 |
    | 235 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*236 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*237 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 238 | NESTED LOOPS | | 1 | 25 | | 2 (0)| 00:00:01 |
    | 239 | NESTED LOOPS | | 2 | 26 | | 1 (0)| 00:00:01 |
    | 240 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*241 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 1 | | | 1 (0)| 00:00:01 |
    | 242 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*243 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 244 | NESTED LOOPS | | | | | | |
    | 245 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 246 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 247 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 248 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*249 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 250 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 251 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*252 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*253 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*254 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*255 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*256 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*257 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*258 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*259 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*260 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*261 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*262 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*263 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*264 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*265 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 266 | VIEW | | 1 | 13 | | 2 (0)| 00:00:01 |
    | 267 | FAST DUAL | | 1 | | | 2 (0)| 00:00:01 |
    |*268 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*269 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*270 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*271 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*272 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*273 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*274 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*275 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*276 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*277 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*278 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 279 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 280 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*281 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*282 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 283 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 284 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*285 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*286 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 287 | VIEW | | 1 | 16 | | 3 (0)| 00:00:01 |
    | 288 | SORT GROUP BY | | 1 | 35 | | 3 (0)| 00:00:01 |
    | 289 | NESTED LOOPS | | 3 | 105 | | 3 (0)| 00:00:01 |
    | 290 | NESTED LOOPS | | 3 | 69 | | 2 (0)| 00:00:01 |
    |*291 | INDEX UNIQUE SCAN | I_OLAP_CUBES$ | 1 | 13 | | 1 (0)| 00:00:01 |
    | 292 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 3 | 30 | | 1 (0)| 00:00:01 |
    |*293 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*294 | INDEX RANGE SCAN | I_OBJ1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 295 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |*296 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |*297 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    --------------------------------------------------------------------------------------------------------------------------------------
    Predicate Information (identified by operation id):
    ---------------------------------------------------
    2 - filter(("O"."TYPE#"<>1 AND "O"."TYPE#"<>10 OR "O"."TYPE#"=1 AND (SELECT 1 FROM "SYS"."IND$" "I" WHERE "I"."OBJ#"=:B1
    AND ("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=9))=1)
    AND (("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR ("O"."TYPE#"=57 OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR
    "O"."TYPE#"=74 OR "O"."TYPE#"=101) OR ("O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR
    "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OA"."OBJ#"=:B2 AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR ("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR"
    WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND
    "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"<>29 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>9 AND
    "O"."TYPE#"<>30 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>7 AND
    "O"."TYPE#"<>28 AND "O"."TYPE#"<>93 AND EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OBJ#"=:B3 AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL") OR "O"."TYPE#"=13 AND (
    EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B4 AND ("OA"."PRIVILEGE#"=12 OR
    "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=11
    AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO"
    "X$KZSRO" WHERE "O"."NAME"=:B5 AND "O"."SPARE3"=:B6 AND "O"."TYPE#"=9 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND
    "DEP"."D_OBJ#"=:B7 AND "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND
    "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-141) OR
    (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=12 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."TRIGGER$" "T",SYS."X$KZSRO" "X$KZSRO" WHERE "T"."OBJ#"=:B8 AND BITAND("T"."PROPERTY",24)=0 AND
    "OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR"
    "X$KZSPR" WHERE ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=19 AND
    EXISTS (SELECT 0 FROM SYS."TABPART$" "TABPART$","SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE "BO#"="OBJ#" AND
    "PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL" AND "OBJ#"=:B9) OR "O"."TYPE#"=14 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO" "X$KZSRO" WHERE "O"."NAME"=:B10 AND
    "O"."SPARE3"=:B11 AND "O"."TYPE#"=13 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND "DEP"."D_OBJ#"=:B12 AND
    "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS
    (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=6 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    (-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"=22 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR"
    WH)
    4 - access("S"."TABLE_OWNER"="O3"."OWNER" AND "S"."TABLE_NAME"="O3"."OBJECT_NAME")
    5 - access("O"."NAME"="S"."SYNONYM_NAME" AND "O"."SPARE3"="U"."USER#")
    6 - filter(BITAND("O"."FLAGS",128)=0)
    7 - access("O"."LINKNAME" IS NULL)
    filter("O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND
    DECODE("O"."TYPE#",0,'NEXT OBJECT',1,'INDEX',2,'TABLE',3,'CLUSTER',4,'VIEW',5,'SYNONYM',6,'SEQUENCE',7,'PROCEDURE',8,'FUNCTION
    ',9,'PACKAGE',11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY',19,'TABLE PARTITION',20,'INDEX
    PARTITION',21,'LOB',22,'LIBRARY',23,'DIRECTORY',24,'QUEUE',28,'JAVA SOURCE',29,'JAVA CLASS',30,'JAVA
    RESOURCE',32,'INDEXTYPE',33,'OPERATOR',34,'TABLE SUBPARTITION',35,'INDEX SUBPARTITION',40,'LOB PARTITION',41,'LOB
    SUBPARTITION',42,NVL( (SELECT 'REWRITE EQUIVALENCE' FROM SYS."SUM$" "S" WHERE "S"."OBJ#"=:B1 AND
    BITAND("S"."XPFLAGS",8388608)=8388608),'MATERIALIZED VIEW'),43,'DIMENSION',44,'CONTEXT',46,'RULE SET',47,'RESOURCE
    PLAN',48,'CONSUMER GROUP',55,'XML SCHEMA',56,'JAVA DATA',57,'EDITION',59,'RULE',60,'CAPTURE',61,'APPLY',62,'EVALUATION
    CONTEXT',66,'JOB',67,'PROGRAM',68,'JOB CLASS',69,'WINDOW',72,'SCHEDULER GROUP',74,'SCHEDULE',79,'CHAIN',81,'FILE
    GROUP',82,'MINING MODEL',87,'ASSEMBLY',90,'CREDENTIAL',92,'CUBE DIMENSION',93,'CUBE',94,'MEASURE FOLDER',95,'CUBE BUILD
    PROCESS',100,'FILE WATCHER',101,'DESTINATION','UNDEFINED')='SYNONYM')
    8 - filter(BITAND("S"."XPFLAGS",8388608)=8388608)
    9 - access("S"."OBJ#"=:B1)
    15 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR "S"."NODE" IS NULL AND EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE')) OR EXISTS (SELECT 0 FROM "SYS"."USER$" "BU",SYS."USER$"
    "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO"
    "X$KZSRO" WHERE "KZSROROL"=:B1)) AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND
    "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND
    "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR
    "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND
    "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0
    FROM SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND
    "BA"."OBJ#"="O"."OBJ#" AND "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5))
    AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2
    OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM
    SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B6 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))))
    16 - access("O"."OWNER#"="U"."USER#")
    18 - access("O"."OBJ#"="S"."OBJ#")
    21 - access("U"."NAME"="U"."NAME")
    22 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND "O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_')
    24 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    25 - filter(("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1))
    AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$"
    "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))))
    26 - filter:)B1 IS NULL)
    31 - access("BU"."NAME"=:B1)
    32 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
    33 - access("O"."OWNER#"="U"."USER#")
    34 - access("BA"."OBJ#"="O"."OBJ#")
    35 - filter("KZSROROL"=:B1)
    37 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    38 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    40 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    41 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    42 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2
    OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM
    SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    45 - access("O"."OBJ#"="ST"."SYN_ID")
    47 - access("O"."BASE_SYN_ID"=PRIOR "S"."SYN_ID")
    48 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2
    OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM
    SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    49 - access("O"."OWNER#"="U"."USER#")
    50 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
    54 - access("BU"."USER#"="O"."SPARE3")
    filter("BU"."USER#"="O"."SPARE3")
    56 - access("O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND EXISTS (SELECT 0 FROM "SYS"."SYN$" "S" WHERE ( EXISTS (SELECT 0 FROM "SYS"."USER$"
    "BU",SYS."USER$" "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0
    FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1)) AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND
    "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND
    "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR
    "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR
    "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND
    (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$"
    "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND "BA"."OBJ#"="O"."OBJ#" AND
    "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5) OR "S"."NODE" IS NULL AND
    EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR
    (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))) AND "S"."OBJ#"=:B6))
    57 - filter( EXISTS (SELECT 0 FROM "SYS"."USER$" "BU",SYS."USER$" "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE
    ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1)) AND
    ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$"
    "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND "BA"."OBJ#"="O"."OBJ#" AND
    "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5) OR "S"."NODE" IS NULL AND
    EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR
    (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE')))
    59 - access("S"."OBJ#"=:B1)
    60 - filter(("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1))
    AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$"
    "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))))
    61 - filter:)B1 IS NULL)
    66 - access("BU"."NAME"=:B1)
    67 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
    68 - access("O"."OWNER#"="U"."USER#")
    69 - access("BA"."OBJ#"="O"."OBJ#")
    70 - filter("KZSROROL"=:B1)
    72 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    73 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    74 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    78 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    79 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    80 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2
    OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM
    SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    81 - access("O"."OWNER#"="U"."USER#")
    83 - access("S"."OWNER"="BU"."NAME" AND "BU"."USER#"="O"."SPARE3")
    85 - access("S"."NAME"="O"."NAME")
    88 - access("O"."TYPE#"=5)
    filter("O"."TYPE#"=5)
    90 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    91 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    94 - access("U"."NAME"="U"."NAME")
    95 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND "O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_')
    97 - access("S"."OBJ#"="ST"."SYN_ID")
    filter("O"."OBJ#"="S"."OBJ#")
    98 - access("O"."OWNER#"="U"."USER#")
    100 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    101 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    102 - filter("O3"."OBJECT_TYPE"='TABLE' OR "O3"."OBJECT_TYPE"='VIEW')
    103 - filter(("O"."TYPE#"<>1 AND "O"."TYPE#"<>10 OR "O"."TYPE#"=1 AND (SELECT 1 FROM "SYS"."IND$" "I" WHERE "I"."OBJ#"=:B1
    AND ("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=9))=1)
    AND (("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR ("O"."TYPE#"=57 OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR
    "O"."TYPE#"=74 OR "O"."TYPE#"=101) OR ("O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR
    "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OA"."OBJ#"=:B2 AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR ("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR"
    WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND
    "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"<>29 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>9 AND
    "O"."TYPE#"<>30 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>7 AND
    "O"."TYPE#"<>28 AND "O"."TYPE#"<>93 AND EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OBJ#"=:B3 AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL") OR "O"."TYPE#"=13 AND (
    EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B4 AND ("OA"."PRIVILEGE#"=12 OR
    "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=11
    AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO"
    "X$KZSRO" WHERE "O"."NAME"=:B5 AND "O"."SPARE3"=:B6 AND "O"."TYPE#"=9 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND
    "DEP"."D_OBJ#"=:B7 AND "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND
    "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-141) OR
    (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=12 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."TRIGGER$" "T",SYS."X$KZSRO" "X$KZSRO" WHERE "T"."OBJ#"=:B8 AND BITAND("T"."PROPERTY",24)=0 AND
    "OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR"
    "X$KZSPR" WHERE ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=19 AND
    EXISTS (SELECT 0 FROM SYS."TABPART$" "TABPART$","SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE "BO#"="OBJ#" AND
    "PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL" AND "OBJ#"=:B9) OR "O"."TYPE#"=14 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO" "X$KZSRO" WHERE "O"."NAME"=:B10 AND
    "O"."SPARE3"=:B11 AND "O"."TYPE#"=13 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND "DEP"."D_OBJ#"=:B12 AND
    "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS
    (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=6 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    (-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"=22 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR"
    WH)
    104 - access("O"."SPARE3"="U"."USER#")
    106 - access("O"."OWNER#"="U"."USER#")
    108 - filter("O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND
    BITAND("O"."FLAGS",128)=0)
    109 - filter("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR
    "I"."TYPE#"=9)
    110 - access("I"."OBJ#"=:B1)
    113 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    114 - filter(((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    115 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    118 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
    filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL")
    121 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    122 - filter(((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    128 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
    filter("O"."TYPE#"=9 AND "O"."TYPE#"<>88)
    131 - access("O"."OWNER#"="U"."USER#")
    132 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    133 - access("DEP"."D_OBJ#"=:B1)
    134 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    135 - filter(((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    138 - filter(BITAND("T"."PROPERTY",24)=0)
    139 - access("T"."OBJ#"=:B1)
    141 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    142 - filter(((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    146 - access("OBJ#"=:B1)
    148 - access("BO#"="OBJ#" AND "GRANTEE#"="KZSROROL" AND "PRIVILEGE#"=9)
    filter("PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL")
    154 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
    filter("O"."TYPE#"=13 AND "O"."TYPE#"<>88)
    157 - access("O"."OWNER#"="U"."USER#")
    158 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    159 - access("DEP"."D_OBJ#"=:B1)
    160 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    161 - filter(((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    162 - filter((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE'))
    163 - filter(((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND
    "INST_ID"=USERENV('INSTANCE'))
    164 - filter(((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR (-"KZSPRPRV")=(-203) OR
    (-"KZSPRPRV")=(-204)) AND "INST_ID"=USERENV('INSTANCE'))
    165 - filter(((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE'))
    166 - filter((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE'))
    167 - filter(((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE'))
    168 - filter(((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND
    "INST_ID"=USERENV('INSTANCE'))
    169 - filter(((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE'))
    170 - filter(((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND
    "INST_ID"=USERENV('INSTANCE'))
    173 - filter(((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE'))
    174 - filter((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE'))
    175 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    176 - filter(((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND
    "INST_ID"=USERENV('INSTANCE'))
    177 - filter(((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND
    "INST_ID"=USERENV('INSTANCE'))
    178 - filter(((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE'))
    179 - filter(((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE'))
    180 - filter(((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND
    "INST_ID"=USERENV('INSTANCE'))
    181 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    182 - filter(((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND
    "INST_ID"=USERENV('INSTANCE'))
    183 - filter(((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE'))
    186 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    187 - filter(((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR
    (-"KZSPRPRV")=(-313)) AND "INST_ID"=USERENV('INSTANCE'))
    190 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    191 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    196 - access("C"."OBJ#"=:B1)
    198 - access("D"."D_OBJ#"=:B1)
    199 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)
    filter("DO"."TYPE#"=92)
    201 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    202 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    203 - access("O"."OWNER#"="U"."USER#")
    204 - filter("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR
    "I"."TYPE#"=9)
    205 - access("I"."OBJ#"=:B1)
    208 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    209 - filter(((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    210 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    213 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
    filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL")
    216 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    217 - filter(((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    223 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
    filter("O"."TYPE#"=9 AND "O"."TYPE#"<>88)
    226 - access("O"."OWNER#"="U"."USER#")
    227 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    228 - access("DEP"."D_OBJ#"=:B1)
    229 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    230 - filter(((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    233 - filter(BITAND("T"."PROPERTY",24)=0)
    234 - access("T"."OBJ#"=:B1)
    236 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    237 - filter(((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    241 - access("OBJ#"=:B1)
    243 - access("BO#"="OBJ#" AND "GRANTEE#"="KZSROROL" AND "PRIVILEGE#"=9)
    filter("PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL")
    249 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
    filter("O"."TYPE#"=13 AND "O"."TYPE#"<>88)
    252 - access("O"."OWNER#"="U"."USER#")
    253 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    254 - access("DEP"."D_OBJ#"=:B1)
    255 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    256 - filter(((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    257 - filter((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE'))
    258 - filter(((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND
    "INST_ID"=USERENV('INSTANCE'))
    259 - filter(((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR (-"KZSPRPRV")=(-203) OR
    (-"KZSPRPRV")=(-204)) AND "INST_ID"=USERENV('INSTANCE'))
    260 - filter(((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE'))
    261 - filter((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE'))
    262 - filter(((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE'))
    263 - filter(((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND
    "INST_ID"=USERENV('INSTANCE'))
    264 - filter(((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE'))
    265 - filter(((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND
    "INST_ID"=USERENV('INSTANCE'))
    268 - filter(((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE'))
    269 - filter((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE'))
    270 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    271 - filter(((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND
    "INST_ID"=USERENV('INSTANCE'))
    272 - filter(((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND
    "INST_ID"=USERENV('INSTANCE'))
    273 - filter(((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE'))
    274 - filter(((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE'))
    275 - filter(((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND
    "INST_ID"=USERENV('INSTANCE'))
    276 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    277 - filter(((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND
    "INST_ID"=USERENV('INSTANCE'))
    278 - filter(((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE'))
    281 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    282 - filter(((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR
    (-"KZSPRPRV")=(-313)) AND "INST_ID"=USERENV('INSTANCE'))
    285 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    286 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    291 - access("C"."OBJ#"=:B1)
    293 - access("D"."D_OBJ#"=:B1)
    294 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)
    filter("DO"."TYPE#"=92)
    296 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    297 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")

    Statistics
    ----------------------------------------------------------
    1200 recursive calls
    0 db block gets
    14723502 consistent gets
    17427 physical reads
    0 redo size
    423 bytes sent via SQL*Net to client
    419 bytes received via SQL*Net from client
    2 SQL*Net roundtrips to/from client
    646 sorts (memory)
    0 sorts (disk)
    1 rows processed
    SQL>
    SQL> SELECT COUNT(*) FROM all_objects o2, all_objects o3, all_synonyms s
    2 WHERE o2.object_type = 'SYNONYM'
    3 AND o3.object_type IN ('TABLE', 'VIEW')
    4 AND o3.owner = o2.owner
    5 AND o2.owner = s.owner
    6 AND o2.object_name = s.synonym_name
    7 AND s.table_owner = o3.owner
    8 AND s.TABLE_NAME = o3.object_name;
    COUNT(*)
    ----------
    15
    Elapsed: 00:03:51.18
    Execution Plan
    ----------------------------------------------------------
    Plan hash value: 2016935392
    ---------------------------------------------------------------------------------------------------------------------------------------
    | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
    ---------------------------------------------------------------------------------------------------------------------------------------
    | 0 | SELECT STATEMENT | | 1 | 244 | | 427 (2)| 00:00:06 |
    | 1 | SORT AGGREGATE | | 1 | 244 | | | |
    |* 2 | FILTER | | | | | | |
    | 3 | NESTED LOOPS | | 1 | 244 | | 426 (2)| 00:00:06 |
    | 4 | NESTED LOOPS | | 1 | 222 | | 425 (2)| 00:00:06 |
    |* 5 | HASH JOIN | | 3 | 414 | 1336K| 424 (2)| 00:00:06 |
    | 6 | JOIN FILTER CREATE | :BF0000 | 13652 | 1173K| | 16 (0)| 00:00:01 |
    | 7 | NESTED LOOPS | | 13652 | 1173K| | 16 (0)| 00:00:01 |
    | 8 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    | 9 | VIEW | ALL_SYNONYMS | 210 | 14700 | | 1 (0)| 00:00:01 |
    | 10 | SORT UNIQUE | | | | | | |
    | 11 | UNION-ALL PARTITION | | | | | | |
    |* 12 | FILTER | | | | | | |
    |* 13 | HASH JOIN | | 1424 | 159K| | 54 (4)| 00:00:01 |
    | 14 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |* 15 | HASH JOIN | | 1424 | 129K| | 52 (2)| 00:00:01 |
    | 16 | NESTED LOOPS | | 1440 | 83520 | | 7 (0)| 00:00:01 |
    | 17 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 18 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 19 | INDEX RANGE SCAN | I_OBJ5 | 1440 | 57600 | | 6 (0)| 00:00:01 |
    | 20 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    |* 21 | FIXED TABLE FULL | X$KZSPR | 17 | 119 | | 0 (0)| 00:00:01 |
    |* 22 | FILTER | | | | | | |
    |* 23 | FILTER | | | | | | |
    | 24 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 |
    | 25 | NESTED LOOPS | | 1 | 80 | | 3 (0)| 00:00:01 |
    | 26 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 |
    | 27 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 28 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 29 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    |* 30 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |* 31 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |* 32 | FIXED TABLE FULL | X$KZSRO | 1 | 3 | | 0 (0)| 00:00:01 |
    | 33 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 34 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 35 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    | 36 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 37 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 38 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 39 | FILTER | | | | | | |
    | 40 | NESTED LOOPS | | 1 | 128 | | 1481 (1)| 00:00:18 |
    | 41 | NESTED LOOPS | | 1 | 106 | | 1480 (1)| 00:00:18 |
    |* 42 | HASH JOIN | | 29 | 2059 | | 1474 (1)| 00:00:18 |
    | 43 | VIEW | _ALL_SYNONYMS_TREE | 555 | 7215 | | 1469 (1)| 00:00:18 |
    |* 44 | CONNECT BY WITHOUT FILTERING | | | | | | |
    |* 45 | FILTER | | | | | | |
    |* 46 | HASH JOIN | | 21 | 2415 | | 99 (3)| 00:00:02 |
    |* 47 | HASH JOIN | | 21 | 1953 | | 98 (3)| 00:00:02 |
    | 48 | MERGE JOIN | | 1368 | 79344 | | 53 (2)| 00:00:01 |
    | 49 | TABLE ACCESS CLUSTER | USER$ | 65 | 1170 | | 1 (0)| 00:00:01 |
    | 50 | INDEX FULL SCAN | I_USER# | 1 | | | 1 (0)| 00:00:01 |
    |* 51 | SORT JOIN | | 1368 | 54720 | | 52 (2)| 00:00:01 |
    | 52 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1368 | 54720 | | 51 (0)| 00:00:01 |
    |* 53 | INDEX SKIP SCAN | I_OBJ1 | 1368 | | | 47 (0)| 00:00:01 |
    |* 54 | FILTER | | | | | | |
    | 55 | TABLE ACCESS BY INDEX ROWID | SYN$ | 1 | 35 | | 1 (0)| 00:00:01 |
    |* 56 | INDEX UNIQUE SCAN | I_SYN1 | 1 | | | 1 (0)| 00:00:01 |
    |* 57 | FILTER | | | | | | |
    |* 58 | FILTER | | | | | | |
    | 59 | NESTED LOOPS | | 1 | 92 | | 4 (0)| 00:00:01 |
    | 60 | NESTED LOOPS | | 1 | 80 | | 3 (0)| 00:00:01 |
    | 61 | NESTED LOOPS | | 1 | 58 | | 2 (0)| 00:00:01 |
    | 62 | TABLE ACCESS BY INDEX ROWID| USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 63 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 64 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    |* 65 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |* 66 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |* 67 | FIXED TABLE FULL | X$KZSRO | 1 | 3 | | 0 (0)| 00:00:01 |
    | 68 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 69 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 70 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 71 | FIXED TABLE FULL | X$KZSPR | 17 | 119 | | 0 (0)| 00:00:01 |
    | 72 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    | 73 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    | 74 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 75 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 76 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 77 | FILTER | | | | | | |
    |* 78 | HASH JOIN | | 554 | 63710 | | 302 (1)| 00:00:04 |
    | 79 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |* 80 | HASH JOIN | | 554 | 51522 | | 301 (1)| 00:00:04 |
    | 81 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    |* 82 | HASH JOIN | | 27694 | 2028K| 1248K| 297 (1)| 00:00:04 |
    | 83 | TABLE ACCESS FULL | SYN$ | 27057 | 924K| | 44 (0)| 00:00:01 |
    | 84 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 27357 | 1068K| | 124 (0)| 00:00:02 |
    |* 85 | INDEX SKIP SCAN | I_OBJ1 | 27357 | | | 47 (0)| 00:00:01 |
    | 86 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 87 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 88 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    | 89 | NESTED LOOPS | | 1440 | 83520 | | 7 (0)| 00:00:01 |
    | 90 | TABLE ACCESS BY INDEX ROWID | USER$ | 1 | 18 | | 1 (0)| 00:00:01 |
    |* 91 | INDEX UNIQUE SCAN | I_USER1 | 1 | | | 1 (0)| 00:00:01 |
    |* 92 | INDEX RANGE SCAN | I_OBJ5 | 1440 | 57600 | | 6 (0)| 00:00:01 |
    | 93 | TABLE ACCESS BY INDEX ROWID | SYN$ | 1 | 35 | | 1 (0)| 00:00:01 |
    |* 94 | INDEX UNIQUE SCAN | I_SYN1 | 1 | | | 1 (0)| 00:00:01 |
    |* 95 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    | 96 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |* 97 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |* 98 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |* 99 | VIEW | ALL_OBJECTS | 32831 | 1603K| | 245 (3)| 00:00:03 |
    |*100 | FILTER | | | | | | |
    | 101 | JOIN FILTER USE | :BF0000 | 68318 | 8272K| | 245 (3)| 00:00:03 |
    |*102 | HASH JOIN | | 68318 | 8272K| | 245 (3)| 00:00:03 |
    | 103 | TABLE ACCESS FULL | USER$ | 65 | 1170 | | 3 (0)| 00:00:01 |
    |*104 | HASH JOIN | | 68318 | 7071K| | 241 (3)| 00:00:03 |
    | 105 | INDEX FULL SCAN | I_USER2 | 65 | 1430 | | 1 (0)| 00:00:01 |
    |*106 | TABLE ACCESS FULL | OBJ$ | 68318 | 5604K| | 240 (3)| 00:00:03 |
    |*107 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 8 | | 1 (0)| 00:00:01 |
    |*108 | INDEX UNIQUE SCAN | I_IND1 | 1 | | | 1 (0)| 00:00:01 |
    | 109 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 110 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*111 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*112 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*113 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 114 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 115 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*116 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 117 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 118 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*119 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*120 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 121 | NESTED LOOPS | | | | | | |
    | 122 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 123 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 124 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 125 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*126 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 127 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 128 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*129 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*130 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*131 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*132 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*133 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 134 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    | 135 | NESTED LOOPS | | 2 | 34 | | 1 (0)| 00:00:01 |
    |*136 | TABLE ACCESS BY INDEX ROWID | TRIGGER$ | 1 | 14 | | 1 (0)| 00:00:01 |
    |*137 | INDEX UNIQUE SCAN | I_TRIGGER2 | 1 | | | 1 (0)| 00:00:01 |
    | 138 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*139 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*140 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 141 | NESTED LOOPS | | 1 | 25 | | 2 (0)| 00:00:01 |
    | 142 | NESTED LOOPS | | 2 | 26 | | 1 (0)| 00:00:01 |
    | 143 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*144 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 1 | | | 1 (0)| 00:00:01 |
    | 145 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*146 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 147 | NESTED LOOPS | | | | | | |
    | 148 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 149 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 150 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 151 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*152 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 153 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 154 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*155 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*156 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*157 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*158 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*159 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*160 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*161 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*162 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*163 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*164 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*165 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*166 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*167 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*168 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 169 | VIEW | | 1 | 13 | | 2 (0)| 00:00:01 |
    | 170 | FAST DUAL | | 1 | | | 2 (0)| 00:00:01 |
    |*171 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*172 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*173 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*174 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*175 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*176 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*177 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*178 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*179 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*180 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*181 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 182 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 183 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*184 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*185 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 186 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 187 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*188 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*189 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 190 | VIEW | | 1 | 16 | | 3 (0)| 00:00:01 |
    | 191 | SORT GROUP BY | | 1 | 35 | | 3 (0)| 00:00:01 |
    | 192 | NESTED LOOPS | | 3 | 105 | | 3 (0)| 00:00:01 |
    | 193 | NESTED LOOPS | | 3 | 69 | | 2 (0)| 00:00:01 |
    |*194 | INDEX UNIQUE SCAN | I_OLAP_CUBES$ | 1 | 13 | | 1 (0)| 00:00:01 |
    | 195 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 3 | 30 | | 1 (0)| 00:00:01 |
    |*196 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*197 | INDEX RANGE SCAN | I_OBJ1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 198 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |*199 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |*200 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*201 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 84 | | 1 (0)| 00:00:01 |
    |*202 | INDEX RANGE SCAN | I_OBJ5 | 1 | | | 1 (0)| 00:00:01 |
    |*203 | TABLE ACCESS BY INDEX ROWID | SUM$ | 1 | 26 | | 1 (0)| 00:00:01 |
    |*204 | INDEX UNIQUE SCAN | I_SUM$_1 | 1 | | | 1 (0)| 00:00:01 |
    |*205 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | | 1 (0)| 00:00:01 |
    |*206 | TABLE ACCESS BY INDEX ROWID | IND$ | 1 | 8 | | 1 (0)| 00:00:01 |
    |*207 | INDEX UNIQUE SCAN | I_IND1 | 1 | | | 1 (0)| 00:00:01 |
    | 208 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 209 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*210 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*211 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*212 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 213 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 214 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*215 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 216 | NESTED LOOPS | | 1 | 15 | | 1 (0)| 00:00:01 |
    | 217 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*218 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*219 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 220 | NESTED LOOPS | | | | | | |
    | 221 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 222 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 223 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 224 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*225 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 226 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 227 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*228 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*229 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*230 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*231 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*232 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 233 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    | 234 | NESTED LOOPS | | 2 | 34 | | 1 (0)| 00:00:01 |
    |*235 | TABLE ACCESS BY INDEX ROWID | TRIGGER$ | 1 | 14 | | 1 (0)| 00:00:01 |
    |*236 | INDEX UNIQUE SCAN | I_TRIGGER2 | 1 | | | 1 (0)| 00:00:01 |
    | 237 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*238 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*239 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 240 | NESTED LOOPS | | 1 | 25 | | 2 (0)| 00:00:01 |
    | 241 | NESTED LOOPS | | 2 | 26 | | 1 (0)| 00:00:01 |
    | 242 | TABLE ACCESS BY INDEX ROWID | TABPART$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*243 | INDEX UNIQUE SCAN | I_TABPART_OBJ$ | 1 | | | 1 (0)| 00:00:01 |
    | 244 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*245 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 246 | NESTED LOOPS | | | | | | |
    | 247 | NESTED LOOPS | | 1 | 69 | | 4 (0)| 00:00:01 |
    | 248 | NESTED LOOPS | | 1 | 59 | | 3 (0)| 00:00:01 |
    | 249 | NESTED LOOPS | | 1 | 47 | | 2 (0)| 00:00:01 |
    | 250 | MERGE JOIN CARTESIAN | | 1 | 43 | | 1 (0)| 00:00:01 |
    |*251 | INDEX RANGE SCAN | I_OBJ5 | 1 | 40 | | 1 (0)| 00:00:01 |
    | 252 | BUFFER SORT | | 2 | 6 | | 0 (0)| 00:00:01 |
    | 253 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*254 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | | 1 (0)| 00:00:01 |
    |*255 | INDEX RANGE SCAN | I_OBJAUTH1 | 1 | 12 | | 1 (0)| 00:00:01 |
    |*256 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*257 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 1 | 10 | | 1 (0)| 00:00:01 |
    |*258 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*259 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*260 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*261 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*262 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*263 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*264 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*265 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*266 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*267 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    | 268 | VIEW | | 1 | 13 | | 2 (0)| 00:00:01 |
    | 269 | FAST DUAL | | 1 | | | 2 (0)| 00:00:01 |
    |*270 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*271 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*272 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*273 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*274 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*275 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*276 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*277 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*278 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    |*279 | FIXED TABLE FULL | X$KZSPR | 1 | 7 | | 0 (0)| 00:00:01 |
    |*280 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 281 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 282 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*283 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*284 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 285 | NESTED LOOPS | | 1 | 12 | | 1 (0)| 00:00:01 |
    | 286 | FIXED TABLE FULL | X$KZSRO | 2 | 6 | | 0 (0)| 00:00:01 |
    |*287 | INDEX RANGE SCAN | I_OBJAUTH2 | 1 | 9 | | 1 (0)| 00:00:01 |
    |*288 | FIXED TABLE FULL | X$KZSPR | 2 | 14 | | 0 (0)| 00:00:01 |
    | 289 | VIEW | | 1 | 16 | | 3 (0)| 00:00:01 |
    | 290 | SORT GROUP BY | | 1 | 35 | | 3 (0)| 00:00:01 |
    | 291 | NESTED LOOPS | | 3 | 105 | | 3 (0)| 00:00:01 |
    | 292 | NESTED LOOPS | | 3 | 69 | | 2 (0)| 00:00:01 |
    |*293 | INDEX UNIQUE SCAN | I_OLAP_CUBES$ | 1 | 13 | | 1 (0)| 00:00:01 |
    | 294 | TABLE ACCESS BY INDEX ROWID | DEPENDENCY$ | 3 | 30 | | 1 (0)| 00:00:01 |
    |*295 | INDEX RANGE SCAN | I_DEPENDENCY1 | 3 | | | 1 (0)| 00:00:01 |
    |*296 | INDEX RANGE SCAN | I_OBJ1 | 1 | 12 | | 1 (0)| 00:00:01 |
    | 297 | NESTED LOOPS | | 1 | 29 | | 2 (0)| 00:00:01 |
    |*298 | INDEX SKIP SCAN | I_USER2 | 1 | 20 | | 1 (0)| 00:00:01 |
    |*299 | INDEX RANGE SCAN | I_OBJ4 | 1 | 9 | | 1 (0)| 00:00:01 |
    ---------------------------------------------------------------------------------------------------------------------------------------
    Predicate Information (identified by operation id):
    ---------------------------------------------------
    2 - filter(("O"."TYPE#"<>1 AND "O"."TYPE#"<>10 OR "O"."TYPE#"=1 AND (SELECT 1 FROM "SYS"."IND$" "I" WHERE "I"."OBJ#"=:B1
    AND ("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=9))=1)
    AND (("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR ("O"."TYPE#"=57 OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR
    "O"."TYPE#"=74 OR "O"."TYPE#"=101) OR ("O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR
    "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OA"."OBJ#"=:B2 AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR ("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND
    "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"<>29 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>9 AND
    "O"."TYPE#"<>30 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>7 AND
    "O"."TYPE#"<>28 AND "O"."TYPE#"<>93 AND EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OBJ#"=:B3 AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL") OR "O"."TYPE#"=13 AND (
    EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B4 AND ("OA"."PRIVILEGE#"=12 OR
    "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=11
    AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO"
    "X$KZSRO" WHERE "O"."NAME"=:B5 AND "O"."SPARE3"=:B6 AND "O"."TYPE#"=9 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND
    "DEP"."D_OBJ#"=:B7 AND "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND
    "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-141) OR
    (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=12 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."TRIGGER$" "T",SYS."X$KZSRO" "X$KZSRO" WHERE "T"."OBJ#"=:B8 AND BITAND("T"."PROPERTY",24)=0 AND
    "OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR"
    "X$KZSPR" WHERE ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=19 AND
    EXISTS (SELECT 0 FROM SYS."TABPART$" "TABPART$","SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE "BO#"="OBJ#" AND
    "PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL" AND "OBJ#"=:B9) OR "O"."TYPE#"=14 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO" "X$KZSRO" WHERE "O"."NAME"=:B10 AND
    "O"."SPARE3"=:B11 AND "O"."TYPE#"=13 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND "DEP"."D_OBJ#"=:B12 AND
    "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS
    (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=6 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE (-"KZSPRPRV")=(-109)
    AND "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"=22 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WH)
    5 - access("O3"."OWNER"="U"."NAME" AND "S"."TABLE_OWNER"="O3"."OWNER" AND "S"."TABLE_NAME"="O3"."OBJECT_NAME")
    12 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR "S"."NODE" IS NULL AND EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE')) OR EXISTS (SELECT 0 FROM "SYS"."USER$" "BU",SYS."USER$"
    "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO"
    "X$KZSRO" WHERE "KZSROROL"=:B1)) AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND
    "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND
    "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR
    "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND
    "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0
    FROM SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND
    "BA"."OBJ#"="O"."OBJ#" AND "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5)) AND
    ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR
    "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$"
    "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B6 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))))
    13 - access("O"."OWNER#"="U"."USER#")
    15 - access("O"."OBJ#"="S"."OBJ#")
    18 - access("U"."NAME"="U"."NAME")
    19 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND "O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_')
    21 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    22 - filter(("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1))
    AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$" "O2"
    WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))))
    23 - filter:)B1 IS NULL)
    28 - access("BU"."NAME"=:B1)
    29 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
    30 - access("O"."OWNER#"="U"."USER#")
    31 - access("BA"."OBJ#"="O"."OBJ#")
    32 - filter("KZSROROL"=:B1)
    34 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    35 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    37 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    38 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    39 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR
    "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$"
    "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    42 - access("O"."OBJ#"="ST"."SYN_ID")
    44 - access("O"."BASE_SYN_ID"=PRIOR "S"."SYN_ID")
    45 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR
    "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$"
    "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    46 - access("O"."OWNER#"="U"."USER#")
    47 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
    51 - access("BU"."USER#"="O"."SPARE3")
    filter("BU"."USER#"="O"."SPARE3")
    53 - access("O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND EXISTS (SELECT 0 FROM "SYS"."SYN$" "S" WHERE ( EXISTS (SELECT 0 FROM "SYS"."USER$"
    "BU",SYS."USER$" "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM
    SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1)) AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8
    AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND
    "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR
    "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND
    "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0
    FROM SYS."USER$" "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND
    "U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND
    "BA"."OBJ#"="O"."OBJ#" AND "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5) OR
    "S"."NODE" IS NULL AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR
    (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))) AND "S"."OBJ#"=:B6))
    54 - filter( EXISTS (SELECT 0 FROM "SYS"."USER$" "BU",SYS."USER$" "U",SYS."OBJ$" "O","SYS"."OBJAUTH$" "BA" WHERE
    ("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1)) AND
    ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$" "O2"
    WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))) AND :B3 IS NULL AND "BA"."OBJ#"="O"."OBJ#" AND
    "O"."NAME"=:B4 AND "BU"."USER#"="O"."SPARE3" AND "O"."OWNER#"="U"."USER#" AND "BU"."NAME"=:B5) OR "S"."NODE" IS NULL AND
    EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR
    (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE')))
    56 - access("S"."OBJ#"=:B1)
    57 - filter(("BA"."GRANTOR#"=USERENV('SCHEMAID') OR EXISTS (SELECT 0 FROM SYS."X$KZSRO" "X$KZSRO" WHERE "KZSROROL"=:B1))
    AND ("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10 AND
    "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR ("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR
    "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR
    "O"."TYPE#"=87) AND (SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR "U"."TYPE#"=2 AND
    "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$" "U2",SYS."OBJ$" "O2"
    WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B2 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))))
    58 - filter:)B1 IS NULL)
    63 - access("BU"."NAME"=:B1)
    64 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
    65 - access("O"."OWNER#"="U"."USER#")
    66 - access("BA"."OBJ#"="O"."OBJ#")
    67 - filter("KZSROROL"=:B1)
    69 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    70 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    71 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    75 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    76 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    77 - filter("O"."TYPE#"<>4 AND "O"."TYPE#"<>5 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>10
    AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>22 AND "O"."TYPE#"<>87 AND
    "O"."TYPE#"<>88 OR BITAND("U"."SPARE1",16)=0 OR SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE' AND "U"."TYPE#"<>2 OR
    "U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) OR EXISTS (SELECT 0 FROM SYS."USER$"
    "U2",SYS."OBJ$" "O2" WHERE "O2"."OWNER#"="U2"."USER#" AND "O2"."TYPE#"=88 AND "O2"."DATAOBJ#"=:B1 AND "U2"."TYPE#"=2 AND
    "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))))
    78 - access("O"."OWNER#"="U"."USER#")
    80 - access("S"."OWNER"="BU"."NAME" AND "BU"."USER#"="O"."SPARE3")
    82 - access("S"."NAME"="O"."NAME")
    85 - access("O"."TYPE#"=5)
    filter("O"."TYPE#"=5)
    87 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    88 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    91 - access("U"."NAME"="U"."NAME")
    92 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)
    filter("O"."TYPE#"=5 AND "O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_')
    94 - access("S"."OBJ#"="ST"."SYN_ID")
    filter("O"."OBJ#"="S"."OBJ#")
    95 - access("O"."OWNER#"="U"."USER#")
    97 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    98 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    99 - filter("O3"."OBJECT_TYPE"='TABLE' OR "O3"."OBJECT_TYPE"='VIEW')
    100 - filter(("O"."TYPE#"<>1 AND "O"."TYPE#"<>10 OR "O"."TYPE#"=1 AND (SELECT 1 FROM "SYS"."IND$" "I" WHERE "I"."OBJ#"=:B1
    AND ("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR "I"."TYPE#"=9))=1)
    AND (("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1) OR ("O"."TYPE#"=57 OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR
    "O"."TYPE#"=74 OR "O"."TYPE#"=101) OR ("O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR
    "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OA"."OBJ#"=:B2 AND ("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM
    SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR ("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR
    "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND
    "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"<>29 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>11 AND "O"."TYPE#"<>9 AND
    "O"."TYPE#"<>30 AND "O"."TYPE#"<>12 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>7 AND
    "O"."TYPE#"<>28 AND "O"."TYPE#"<>93 AND EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE
    "OBJ#"=:B3 AND ("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL") OR "O"."TYPE#"=13 AND (
    EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA",SYS."X$KZSRO" "X$KZSRO" WHERE "OA"."OBJ#"=:B4 AND ("OA"."PRIVILEGE#"=12 OR
    "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE
    ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=11
    AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$" "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO"
    "X$KZSRO" WHERE "O"."NAME"=:B5 AND "O"."SPARE3"=:B6 AND "O"."TYPE#"=9 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND
    "DEP"."D_OBJ#"=:B7 AND "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND
    "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-141) OR
    (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=12 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."TRIGGER$" "T",SYS."X$KZSRO" "X$KZSRO" WHERE "T"."OBJ#"=:B8 AND BITAND("T"."PROPERTY",24)=0 AND
    "OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS (SELECT 0 FROM SYS."X$KZSPR"
    "X$KZSPR" WHERE ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=19 AND
    EXISTS (SELECT 0 FROM SYS."TABPART$" "TABPART$","SYS"."OBJAUTH$" "OBJAUTH$",SYS."X$KZSRO" "X$KZSRO" WHERE "BO#"="OBJ#" AND
    "PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL" AND "OBJ#"=:B9) OR "O"."TYPE#"=14 AND ( EXISTS (SELECT 0 FROM "SYS"."OBJAUTH$"
    "OA","SYS"."DEPENDENCY$" "DEP",SYS."USER$" "U",SYS."OBJ$" "O",SYS."X$KZSRO" "X$KZSRO" WHERE "O"."NAME"=:B10 AND
    "O"."SPARE3"=:B11 AND "O"."TYPE#"=13 AND "O"."TYPE#"<>88 AND "O"."OWNER#"="U"."USER#" AND "DEP"."D_OBJ#"=:B12 AND
    "DEP"."P_OBJ#"="O"."OBJ#" AND "OA"."OBJ#"="O"."OBJ#" AND "OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL") OR EXISTS
    (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND
    "INST_ID"=USERENV('INSTANCE'))) OR "O"."TYPE#"=6 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WHERE (-"KZSPRPRV")=(-109)
    AND "INST_ID"=USERENV('INSTANCE')) OR "O"."TYPE#"=22 AND EXISTS (SELECT 0 FROM SYS."X$KZSPR" "X$KZSPR" WH)
    102 - access("O"."SPARE3"="U"."USER#")
    104 - access("O"."OWNER#"="U"."USER#")
    106 - filter("O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND
    BITAND("O"."FLAGS",128)=0)
    107 - filter("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR
    "I"."TYPE#"=9)
    108 - access("I"."OBJ#"=:B1)
    111 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    112 - filter(((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    113 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    116 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
    filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL")
    119 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    120 - filter(((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    126 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
    filter("O"."TYPE#"=9 AND "O"."TYPE#"<>88)
    129 - access("O"."OWNER#"="U"."USER#")
    130 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    131 - access("DEP"."D_OBJ#"=:B1)
    132 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    133 - filter(((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    136 - filter(BITAND("T"."PROPERTY",24)=0)
    137 - access("T"."OBJ#"=:B1)
    139 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    140 - filter(((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    144 - access("OBJ#"=:B1)
    146 - access("BO#"="OBJ#" AND "GRANTEE#"="KZSROROL" AND "PRIVILEGE#"=9)
    filter("PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL")
    152 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
    filter("O"."TYPE#"=13 AND "O"."TYPE#"<>88)
    155 - access("O"."OWNER#"="U"."USER#")
    156 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    157 - access("DEP"."D_OBJ#"=:B1)
    158 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    159 - filter(((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    160 - filter((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE'))
    161 - filter(((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND
    "INST_ID"=USERENV('INSTANCE'))
    162 - filter(((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR (-"KZSPRPRV")=(-203) OR
    (-"KZSPRPRV")=(-204)) AND "INST_ID"=USERENV('INSTANCE'))
    163 - filter(((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE'))
    164 - filter((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE'))
    165 - filter(((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE'))
    166 - filter(((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND
    "INST_ID"=USERENV('INSTANCE'))
    167 - filter(((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE'))
    168 - filter(((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND
    "INST_ID"=USERENV('INSTANCE'))
    171 - filter(((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE'))
    172 - filter((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE'))
    173 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    174 - filter(((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND
    "INST_ID"=USERENV('INSTANCE'))
    175 - filter(((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND
    "INST_ID"=USERENV('INSTANCE'))
    176 - filter(((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE'))
    177 - filter(((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE'))
    178 - filter(((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND
    "INST_ID"=USERENV('INSTANCE'))
    179 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    180 - filter(((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND
    "INST_ID"=USERENV('INSTANCE'))
    181 - filter(((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE'))
    184 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    185 - filter(((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR
    (-"KZSPRPRV")=(-313)) AND "INST_ID"=USERENV('INSTANCE'))
    188 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    189 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    194 - access("C"."OBJ#"=:B1)
    196 - access("D"."D_OBJ#"=:B1)
    197 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)
    filter("DO"."TYPE#"=92)
    199 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    200 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
    201 - filter(BITAND("O"."FLAGS",128)=0)
    202 - access("O"."SPARE3"="U"."USER#" AND "O"."NAME"="S"."SYNONYM_NAME" AND "O"."LINKNAME" IS NULL)
    filter("O"."NAME"<>'_NEXT_OBJECT' AND "O"."NAME"<>'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND
    DECODE("O"."TYPE#",0,'NEXT OBJECT',1,'INDEX',2,'TABLE',3,'CLUSTER',4,'VIEW',5,'SYNONYM',6,'SEQUENCE',7,'PROCEDURE',8,'FUNCTION'
    ,9,'PACKAGE',11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY',19,'TABLE PARTITION',20,'INDEX
    PARTITION',21,'LOB',22,'LIBRARY',23,'DIRECTORY',24,'QUEUE',28,'JAVA SOURCE',29,'JAVA CLASS',30,'JAVA
    RESOURCE',32,'INDEXTYPE',33,'OPERATOR',34,'TABLE SUBPARTITION',35,'INDEX SUBPARTITION',40,'LOB PARTITION',41,'LOB
    SUBPARTITION',42,NVL( (SELECT 'REWRITE EQUIVALENCE' FROM SYS."SUM$" "S" WHERE "S"."OBJ#"=:B1 AND
    BITAND("S"."XPFLAGS",8388608)=8388608),'MATERIALIZED VIEW'),43,'DIMENSION',44,'CONTEXT',46,'RULE SET',47,'RESOURCE
    PLAN',48,'CONSUMER GROUP',55,'XML SCHEMA',56,'JAVA DATA',57,'EDITION',59,'RULE',60,'CAPTURE',61,'APPLY',62,'EVALUATION
    CONTEXT',66,'JOB',67,'PROGRAM',68,'JOB CLASS',69,'WINDOW',72,'SCHEDULER GROUP',74,'SCHEDULE',79,'CHAIN',81,'FILE
    GROUP',82,'MINING MODEL',87,'ASSEMBLY',90,'CREDENTIAL',92,'CUBE DIMENSION',93,'CUBE',94,'MEASURE FOLDER',95,'CUBE BUILD
    PROCESS',100,'FILE WATCHER',101,'DESTINATION','UNDEFINED')='SYNONYM')
    203 - filter(BITAND("S"."XPFLAGS",8388608)=8388608)
    204 - access("S"."OBJ#"=:B1)
    205 - access("O"."OWNER#"="U"."USER#")
    206 - filter("I"."TYPE#"=1 OR "I"."TYPE#"=2 OR "I"."TYPE#"=3 OR "I"."TYPE#"=4 OR "I"."TYPE#"=6 OR "I"."TYPE#"=7 OR
    "I"."TYPE#"=9)
    207 - access("I"."OBJ#"=:B1)
    210 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    211 - filter(((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    212 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    215 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
    filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=11 OR
    "PRIVILEGE#"=12 OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18) AND "GRANTEE#"="KZSROROL")
    218 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
    filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26) AND "OA"."GRANTEE#"="KZSROROL")
    219 - filter(((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    225 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
    filter("O"."TYPE#"=9 AND "O"."TYPE#"<>88)
    228 - access("O"."OWNER#"="U"."USER#")
    229 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    230 - access("DEP"."D_OBJ#"=:B1)
    231 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    232 - filter(((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    235 - filter(BITAND("T"."PROPERTY",24)=0)
    236 - access("T"."OBJ#"=:B1)
    238 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    239 - filter(((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    243 - access("OBJ#"=:B1)
    245 - access("BO#"="OBJ#" AND "GRANTEE#"="KZSROROL" AND "PRIVILEGE#"=9)
    filter("PRIVILEGE#"=9 AND "GRANTEE#"="KZSROROL")
    251 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
    filter("O"."TYPE#"=13 AND "O"."TYPE#"<>88)
    254 - access("O"."OWNER#"="U"."USER#")
    255 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
    filter("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL")
    256 - access("DEP"."D_OBJ#"=:B1)
    257 - filter("DEP"."P_OBJ#"="O"."OBJ#")
    258 - filter(((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE'))
    259 - filter((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE'))
    260 - filter(((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND
    "INST_ID"=USERENV('INSTANCE'))
    261 - filter(((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR (-"KZSPRPRV")=(-203) OR
    (-"KZSPRPRV")=(-204)) AND "INST_ID"=USERENV('INSTANCE'))
    262 - filter(((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE'))
    263 - filter((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE'))
    264 - filter(((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE'))
    265 - filter(((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND
    "INST_ID"=USERENV('INSTANCE'))
    266 - filter(((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE'))
    267 - filter(((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND
    "INST_ID"=USERENV('INSTANCE'))
    270 - filter(((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE'))
    271 - filter((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE'))
    272 - filter(((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR
    (-"KZSPRPRV")=(-50)) AND "INST_ID"=USERENV('INSTANCE'))
    273 - filter(((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND
    "INST_ID"=USERENV('INSTANCE'))
    274 - filter(((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND
    "INST_ID"=USERENV('INSTANCE'))
    275 - filter(((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE'))
    276 - filter(((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE'))
    277 - filter(((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND
    "INST_ID"=USERENV('INSTANCE'))
    278 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    279 - filter(((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND
    "INST_ID"=USERENV('INSTANCE'))
    280 - filter(((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE'))
    283 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    284 - filter(((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR
    (-"KZSPRPRV")=(-313)) AND "INST_ID"=USERENV('INSTANCE'))
    287 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
    288 - filter(((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR
    (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE'))
    293 - access("C"."OBJ#"=:B1)
    295 - access("D"."D_OBJ#"=:B1)
    296 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)
    filter("DO"."TYPE#"=92)
    298 - access("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    filter("U2"."TYPE#"=2 AND "U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')))
    299 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")

    Statistics
    ----------------------------------------------------------
    597 recursive calls
    0 db block gets
    14683904 consistent gets
    17427 physical reads
    0 redo size
    422 bytes sent via SQL*Net to client
    419 bytes received via SQL*Net from client
    2 SQL*Net roundtrips to/from client
    289 sorts (memory)
    0 sorts (disk)
    1 rows processed
    SQL>


    Both are inefficient queries -- the first has 1200 recursive calls, the second 597 and both require almost 15 million consistent gets and over 17000 physical reads. I cannot understand how anyone could think these queries would execute in 10 seconds -- on my system they consumed roughly 5 minutes each to run, with fixed objects stats computed to assist the optimizer in making more intelligent choices when choosing paths. And the queries are not equivalent since the first returns a count of 3153 and the second a count of 15.

    What, exactly, is this query supposed to report?