6 Replies Latest reply: Jul 1, 2014 9:45 AM by Dom Brooks RSS

    SQL Profile stopped working - new one doesn't work

    R o b

      Hi,

       

       

      I'm looking for some general hints and ideas.

       

      A 3rd party application creates a long running Insert statement. The software vendor recommended to work around the issue but setting up a SQL profile and provided a few screenshots on how to do it.

      We created a SQL Profile (EM 12c, Oracle 11.2.0.3, 64bit AIX) and it did the trick (for about 2 months).

      Suddenly (last week) the issue reappaered. We tried to implent the SQL profile again but it has no effect. We tried a couple of times - INSERT still long running (> 5-20min). It should be executed in less than 1 min.

       

      We can see that the INSERT in question is executed with the SQL profile.

      We do not know why the issue is back (no software update, no (obvoius) changes in database) nor do we know why reimplementing the SQL profile doesn't help.

       

      On a different Oracle database (11.2.0.1, W2008R2 - but with less schemas) the issue does not occur at all.

       

      Additional information:

      When we implented the SQL profile the first time we had some issues getting it done. Somehow my colleague mentioned to set it up. Unfortunately he can't remeber in detail what he did differently.

       

      The SQL statement in question is:

       

      insert into mdsys.sdo_geom_metadata_table(sdo_OWNER, sdo_table_name, sdo_column_name, sdo_DIMINFO, sdo_SRID) select 'ROBERT_TEST2', s.synonym_name, m.column_name, m.DIMINFO, m.SRID from all_sdo_geom_metadata m, all_synonyms s where m.owner=s.table_owner and m.TABLE_NAME = s.TABLE_NAME and s.owner='ROBERT_TEST2'

       

      Many thanks, Rob

        • 1. Re: SQL Profile stopped working - new one doesn't work
          xavi.morera

          Hi,

           

          Could you please provide the explain plan for this statement?

           

          Xavi

          • 2. Re: SQL Profile stopped working - new one doesn't work
            MahmoudHa

            Hi,

             

            Can you check if the execution plan have changed, using an sql profiles doesn't guarantee that the execution plan will not change.If these is the case than check why else check wait events and stats for these statement and where is most of the time is spent.

            • 3. Re: SQL Profile stopped working - new one doesn't work
              Dom Brooks

              For SQL Profile usage, V$SQL has important columns EXACT_MATCHING_SIGNATURE (and/or FORCE_MATCHING_SIGNATURE) and SQL_PROFILE.

              SQL_PROFILE column tells you whether profile is being used.

              EXACT_MATCHING_SIGNATURE /FORCE_MATCHING_SIGNATURE are the columns which map to DBA_SQL_PROFILES.SIGNATURE depending on whether the profile was set up as force match or not.

               

              These columns are in DBA_HIST_SQLSTAT so if you statement regularly features in your top N, you can see whether it was using the sql profile.

               

              You can also see in DBA_SQL_PROFILE when the profile was created, check it's still enabled, etc.

               

              If a profile stopped working, then this suggests the INSERT statement has materially changed and therefore a new profile is required for the new signature.

               

              If the profile is still in place and still used, then this suggests that the problem is not one of execution plan, but one of either increased resource consumption which will be reflected in some of the metrics in V$SQL/DBA_HIST_SQLSTAT - e.g. more logical IO or more physical IO, or one of contention.

               

              In summary, much more information required.

              • 4. Re: SQL Profile stopped working - new one doesn't work
                R o b

                Hi,

                many thanks for your suggestions.

                Our DBA claims that the database has not changed.
                The SQL statement has not changed either (application has not changed - here I'm 100% sure as I'm responsible for the app and I compared older screenshots and the new sql statement as well).
                SQL profile is active and is being used (checked that via OEM and as per suggestions by Dom).

                When I create a new profile it says - "it is recommended to implement the profile. Advantage: 99.9%'
                It is implemented with "force" option - but it doesn't change the execution speed.

                When I use the "compare the two explain plans" (original explain plan and explain plan with sql profile) - there are slightly different (I'm not familiar with explain plans - but most ovbvoiusly the number of rows is slightly different) - but when I look at column "cpu cost" ist is almost identical for both.

                 

                The explain plans (with / without profile) are quite long - 220 rows each.

                 

                Rob

                 

                Here is the explain plan with SQL profile enabled:

                 

                --aix, 11.2.0.3 -  performance issue, with profile
                PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          
                ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                SQL_ID  2rm18m17grh5r, child number 0                                                                                                                                                                                                                                                                        
                -------------------------------------                                                                                                                                                                                                                                                                        
                insert into mdsys.sdo_geom_metadata_table(sdo_OWNER, sdo_table_name,                                                                                                                                                                                                                                         
                sdo_column_name, sdo_DIMINFO, sdo_SRID) select 'ROBERT_TEST2',                                                                                                                                                                                                                                               
                s.synonym_name, m.column_name, m.DIMINFO, m.SRID from                                                                                                                                                                                                                                                        
                all_sdo_geom_metadata m, all_synonyms s where m.owner=s.table_owner and                                                                                                                                                                                                                                      
                m.TABLE_NAME = s.TABLE_NAME and s.owner='ROBERT_TEST2'                                                                                                                                                                                                                                                       
                
                Plan hash value: 822358568                                                                                                                                                                                                                                                                                   
                
                ------------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                         
                | Id  | Operation                                        | Name                    | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |                                                                                                                                                                         
                ------------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                         
                |   0 | INSERT STATEMENT                                 |                         |       |       |       |    52 (100)|          |                                                                                                                                                                         
                |   1 |  LOAD TABLE CONVENTIONAL                         |                         |       |       |       |            |          |                                                                                                                                                                         
                |   2 |   NESTED LOOPS                                   |                         |     1 |   409 |       |    52   (0)| 00:00:01 |                                                                                                                                                                         
                |   3 |    VIEW                                          | ALL_SYNONYMS            |    28 |  1876 |       |    16   (0)| 00:00:01 |                                                                                                                                                                         
                |   4 |     SORT UNIQUE                                  |                         |       |       |       |            |          |                                                                                                                                                                         
                |   5 |      UNION-ALL                                   |                         |       |       |       |            |          |                                                                                                                                                                         
                |*  6 |       FILTER                                     |                         |       |       |       |            |          |                                                                                                                                                                         
                |*  7 |        HASH JOIN                                 |                         |  1179 |   132K|       |   101   (2)| 00:00:02 |                                                                                                                                                                         
                |*  8 |         HASH JOIN                                |                         |  1179 | 96678 |       |    24   (5)| 00:00:01 |                                                                                                                                                                         
                |   9 |          INDEX FULL SCAN                         | I_USER2                 |   319 |  7018 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |  10 |          NESTED LOOPS                            |                         |  1179 | 70740 |       |    22   (0)| 00:00:01 |                                                                                                                                                                         
                |  11 |           TABLE ACCESS BY INDEX ROWID            | USER$                   |     1 |    19 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 12 |            INDEX UNIQUE SCAN                     | I_USER1                 |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 13 |           INDEX RANGE SCAN                       | I_OBJ5                  |  1179 | 48339 |       |    21   (0)| 00:00:01 |                                                                                                                                                                         
                |  14 |         TABLE ACCESS FULL                        | SYN$                    | 48217 |  1553K|       |    77   (2)| 00:00:01 |                                                                                                                                                                         
                |* 15 |        FIXED TABLE FULL                          | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |* 16 |        FILTER                                    |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 17 |         FILTER                                   |                         |       |       |       |            |          |                                                                                                                                                                         
                |  18 |          NESTED LOOPS                            |                         |     1 |    96 |       |     5   (0)| 00:00:01 |                                                                                                                                                                         
                |  19 |           NESTED LOOPS                           |                         |     1 |    82 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                |  20 |            NESTED LOOPS                          |                         |     1 |    60 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |  21 |             TABLE ACCESS BY INDEX ROWID          | USER$                   |     1 |    19 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 22 |              INDEX UNIQUE SCAN                   | I_USER1                 |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 23 |             INDEX RANGE SCAN                     | I_OBJ5                  |     1 |    41 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 24 |            INDEX RANGE SCAN                      | I_USER2                 |     1 |    22 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 25 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |     2 |    28 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 26 |         FIXED TABLE FULL                         | X$KZSRO                 |     1 |    13 |       |     0   (0)|          |                                                                                                                                                                         
                |  27 |         NESTED LOOPS                             |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 28 |          INDEX SKIP SCAN                         | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 29 |          INDEX RANGE SCAN                        | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |  30 |        NESTED LOOPS                              |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 31 |         INDEX SKIP SCAN                          | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 32 |         INDEX RANGE SCAN                         | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 33 |       FILTER                                     |                         |       |       |       |            |          |                                                                                                                                                                         
                |  34 |        NESTED LOOPS                              |                         |     1 |   128 |       |  4089   (1)| 00:00:50 |                                                                                                                                                                         
                |  35 |         NESTED LOOPS                             |                         |     1 |   106 |       |  4088   (1)| 00:00:50 |                                                                                                                                                                         
                |* 36 |          HASH JOIN                               |                         |    12 |   876 |       |  4086   (1)| 00:00:50 |                                                                                                                                                                         
                |  37 |           VIEW                                   | _ALL_SYNONYMS_TREE      |   488 |  6344 |       |  4066   (1)| 00:00:49 |                                                                                                                                                                         
                |* 38 |            CONNECT BY WITHOUT FILTERING          |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 39 |             FILTER                               |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 40 |              HASH JOIN                           |                         |   483 | 55545 |       |  1182   (1)| 00:00:15 |                                                                                                                                                                         
                |  41 |               INDEX FULL SCAN                    | I_USER2                 |   319 |  7018 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 42 |               HASH JOIN                          |                         |   162 | 15066 |       |  1181   (1)| 00:00:15 |                                                                                                                                                                         
                |  43 |                TABLE ACCESS FULL                 | USER$                   |   319 |  6061 |       |     7   (0)| 00:00:01 |                                                                                                                                                                         
                |* 44 |                HASH JOIN                         |                         | 51738 |  3738K|  2120K|  1173   (1)| 00:00:15 |                                                                                                                                                                         
                |  45 |                 TABLE ACCESS FULL                | SYN$                    | 48217 |  1553K|       |    77   (2)| 00:00:01 |                                                                                                                                                                         
                |* 46 |                 INDEX FAST FULL SCAN             | I_OBJ2                  | 47967 |  1920K|       |   870   (1)| 00:00:11 |                                                                                                                                                                         
                |* 47 |              FILTER                              |                         |       |       |       |            |          |                                                                                                                                                                         
                |  48 |               TABLE ACCESS BY INDEX ROWID        | SYN$                    |     1 |    33 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 49 |                INDEX UNIQUE SCAN                 | I_SYN1                  |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 50 |               FILTER                             |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 51 |                FILTER                            |                         |       |       |       |            |          |                                                                                                                                                                         
                |  52 |                 NESTED LOOPS                     |                         |     1 |    96 |       |     5   (0)| 00:00:01 |                                                                                                                                                                         
                |  53 |                  NESTED LOOPS                    |                         |     1 |    82 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                |  54 |                   NESTED LOOPS                   |                         |     1 |    60 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |  55 |                    TABLE ACCESS BY INDEX ROWID   | USER$                   |     1 |    19 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 56 |                     INDEX UNIQUE SCAN            | I_USER1                 |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 57 |                    INDEX RANGE SCAN              | I_OBJ5                  |     1 |    41 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 58 |                   INDEX RANGE SCAN               | I_USER2                 |     1 |    22 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 59 |                  INDEX RANGE SCAN                | I_OBJAUTH1              |     2 |    28 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 60 |                FIXED TABLE FULL                  | X$KZSRO                 |     1 |    13 |       |     0   (0)|          |                                                                                                                                                                         
                |  61 |                NESTED LOOPS                      |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 62 |                 INDEX SKIP SCAN                  | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 63 |                 INDEX RANGE SCAN                 | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 64 |               FIXED TABLE FULL                   | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |  65 |              NESTED LOOPS                        |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 66 |               INDEX SKIP SCAN                    | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 67 |               INDEX RANGE SCAN                   | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 68 |             FILTER                               |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 69 |              HASH JOIN                           |                         |   487 | 56005 |       |  1190   (2)| 00:00:15 |                                                                                                                                                                         
                |  70 |               INDEX FULL SCAN                    | I_USER2                 |   319 |  7018 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 71 |               HASH JOIN                          |                         |   487 | 45291 |       |  1188   (2)| 00:00:15 |                                                                                                                                                                         
                |  72 |                TABLE ACCESS FULL                 | USER$                   |   319 |  6061 |       |     7   (0)| 00:00:01 |                                                                                                                                                                         
                |* 73 |                HASH JOIN                         |                         |   651K|    45M|  2120K|  1177   (1)| 00:00:15 |                                                                                                                                                                         
                |  74 |                 TABLE ACCESS FULL                | SYN$                    | 48217 |  1553K|       |    77   (2)| 00:00:01 |                                                                                                                                                                         
                |* 75 |                 INDEX FAST FULL SCAN             | I_OBJ2                  | 47967 |  1920K|       |   870   (1)| 00:00:11 |                                                                                                                                                                         
                |  76 |              NESTED LOOPS                        |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 77 |               INDEX SKIP SCAN                    | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 78 |               INDEX RANGE SCAN                   | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |  79 |           NESTED LOOPS                           |                         |  1179 | 70740 |       |    22   (0)| 00:00:01 |                                                                                                                                                                         
                |  80 |            TABLE ACCESS BY INDEX ROWID           | USER$                   |     1 |    19 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 81 |             INDEX UNIQUE SCAN                    | I_USER1                 |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 82 |            INDEX RANGE SCAN                      | I_OBJ5                  |  1179 | 48339 |       |    21   (0)| 00:00:01 |                                                                                                                                                                         
                |  83 |          TABLE ACCESS BY INDEX ROWID             | SYN$                    |     1 |    33 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 84 |           INDEX UNIQUE SCAN                      | I_SYN1                  |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 85 |         INDEX RANGE SCAN                         | I_USER2                 |     1 |    22 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |  86 |        NESTED LOOPS                              |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |* 87 |         INDEX SKIP SCAN                          | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 88 |         INDEX RANGE SCAN                         | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |  89 |    VIEW                                          | ALL_SDO_GEOM_METADATA   |     1 |   342 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |  90 |     UNION-ALL PARTITION                          |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 91 |      HASH JOIN                                   |                         |     1 |    85 |       |  1163   (5)| 00:00:14 |                                                                                                                                                                         
                |  92 |       TABLE ACCESS BY INDEX ROWID                | SDO_GEOM_METADATA_TABLE |     1 |    40 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |* 93 |        INDEX RANGE SCAN                          | SDO_GEOM_IDX            |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 94 |       TABLE ACCESS BY INDEX ROWID                | SUM$                    |     1 |    10 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |* 95 |        INDEX UNIQUE SCAN                         | I_SUM$_1                |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |* 96 |       VIEW                                       | ALL_OBJECTS             | 32655 |  1435K|       |  1160   (5)| 00:00:14 |                                                                                                                                                                         
                |* 97 |        FILTER                                    |                         |       |       |       |            |          |                                                                                                                                                                         
                |* 98 |         HASH JOIN                                |                         |   272K|    22M|       |  1160   (5)| 00:00:14 |                                                                                                                                                                         
                |  99 |          TABLE ACCESS FULL                       | USER$                   |   319 |  6061 |       |     7   (0)| 00:00:01 |                                                                                                                                                                         
                |*100 |          HASH JOIN                               |                         |   272K|    17M|       |  1151   (5)| 00:00:14 |                                                                                                                                                                         
                | 101 |           INDEX FULL SCAN                        | I_USER2                 |   319 |  7018 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*102 |           TABLE ACCESS FULL                      | OBJ$                    |   272K|    11M|       |  1148   (4)| 00:00:14 |                                                                                                                                                                         
                |*103 |         TABLE ACCESS BY INDEX ROWID              | IND$                    |     1 |     9 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*104 |          INDEX UNIQUE SCAN                       | I_IND1                  |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*105 |         HASH JOIN                                |                         |     1 |    42 |       |     4  (25)| 00:00:01 |                                                                                                                                                                         
                | 106 |          NESTED LOOPS                            |                         |     1 |    29 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*107 |           TABLE ACCESS BY INDEX ROWID            | TRIGGER$                |     1 |    16 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*108 |            INDEX UNIQUE SCAN                     | I_TRIGGER2              |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*109 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |     1 |    13 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                | 110 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*111 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*112 |         FIXED TABLE FULL                         | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |*113 |         HASH JOIN                                |                         |     1 |    26 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*114 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |     2 |    26 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 115 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*116 |         FIXED TABLE FULL                         | X$KZSPR                 |     1 |    26 |       |     0   (0)|          |                                                                                                                                                                         
                |*117 |         HASH JOIN                                |                         |     1 |    26 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*118 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |     1 |    13 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 119 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*120 |         FIXED TABLE FULL                         | X$KZSPR                 |     3 |    78 |       |     0   (0)|          |                                                                                                                                                                         
                |*121 |         HASH JOIN                                |                         |     1 |    26 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*122 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |     1 |    13 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 123 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*124 |         FIXED TABLE FULL                         | X$KZSPR                 |     3 |    78 |       |     0   (0)|          |                                                                                                                                                                         
                | 125 |         NESTED LOOPS                             |                         |       |       |       |            |          |                                                                                                                                                                         
                | 126 |          NESTED LOOPS                            |                         |     1 |    95 |       |     8   (0)| 00:00:01 |                                                                                                                                                                         
                | 127 |           NESTED LOOPS                           |                         |     1 |    84 |       |     5   (0)| 00:00:01 |                                                                                                                                                                         
                | 128 |            NESTED LOOPS                          |                         |     1 |    71 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                | 129 |             MERGE JOIN CARTESIAN                 |                         |     1 |    54 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*130 |              INDEX RANGE SCAN                    | I_OBJ5                  |     1 |    41 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                | 131 |              BUFFER SORT                         |                         |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                | 132 |               FIXED TABLE FULL                   | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*133 |             INDEX RANGE SCAN                     | I_USER2                 |     1 |    17 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*134 |            INDEX RANGE SCAN                      | I_OBJAUTH1              |     1 |    13 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*135 |           INDEX RANGE SCAN                       | I_DEPENDENCY1           |     3 |       |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*136 |          TABLE ACCESS BY INDEX ROWID             | DEPENDENCY$             |     1 |    11 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*137 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                | 138 |         NESTED LOOPS                             |                         |       |       |       |            |          |                                                                                                                                                                         
                | 139 |          NESTED LOOPS                            |                         |     1 |    95 |       |     8   (0)| 00:00:01 |                                                                                                                                                                         
                | 140 |           NESTED LOOPS                           |                         |     1 |    84 |       |     5   (0)| 00:00:01 |                                                                                                                                                                         
                | 141 |            NESTED LOOPS                          |                         |     1 |    71 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                | 142 |             MERGE JOIN CARTESIAN                 |                         |     1 |    54 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*143 |              INDEX RANGE SCAN                    | I_OBJ5                  |     1 |    41 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                | 144 |              BUFFER SORT                         |                         |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                | 145 |               FIXED TABLE FULL                   | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*146 |             INDEX RANGE SCAN                     | I_USER2                 |     1 |    17 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*147 |            INDEX RANGE SCAN                      | I_OBJAUTH1              |     1 |    13 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*148 |           INDEX RANGE SCAN                       | I_DEPENDENCY1           |     3 |       |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*149 |          TABLE ACCESS BY INDEX ROWID             | DEPENDENCY$             |     1 |    11 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*150 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*151 |         HASH JOIN                                |                         |     1 |    36 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                | 152 |          NESTED LOOPS                            |                         |     1 |    23 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 153 |           TABLE ACCESS BY INDEX ROWID            | TABPART$                |     1 |    10 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*154 |            INDEX UNIQUE SCAN                     | I_TABPART_OBJ$          |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |*155 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |     1 |    13 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                | 156 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*157 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*158 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*159 |         FIXED TABLE FULL                         | X$KZSPR                 |     1 |    26 |       |     0   (0)|          |                                                                                                                                                                         
                |*160 |         FIXED TABLE FULL                         | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |*161 |         FIXED TABLE FULL                         | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |*162 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*163 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*164 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*165 |         FIXED TABLE FULL                         | X$KZSPR                 |     1 |    26 |       |     0   (0)|          |                                                                                                                                                                         
                |*166 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*167 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*168 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*169 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*170 |         FIXED TABLE FULL                         | X$KZSPR                 |     2 |    52 |       |     0   (0)|          |                                                                                                                                                                         
                |*171 |         FIXED TABLE FULL                         | X$KZSPR                 |     3 |    78 |       |     0   (0)|          |                                                                                                                                                                         
                |*172 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*173 |         FIXED TABLE FULL                         | X$KZSPR                 |     6 |   156 |       |     0   (0)|          |                                                                                                                                                                         
                |*174 |         FIXED TABLE FULL                         | X$KZSPR                 |     4 |   104 |       |     0   (0)|          |                                                                                                                                                                         
                |*175 |         FIXED TABLE FULL                         | X$KZSPR                 |     3 |    78 |       |     0   (0)|          |                                                                                                                                                                         
                | 176 |         FAST DUAL                                |                         |     1 |       |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*177 |         HASH JOIN                                |                         |     1 |    23 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*178 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |     2 |    20 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 179 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*180 |         FIXED TABLE FULL                         | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                |*181 |         HASH JOIN                                |                         |     1 |    23 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*182 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |     2 |    20 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 183 |          FIXED TABLE FULL                        | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*184 |          FIXED TABLE FULL                        | X$KZSPR                 |     6 |   156 |       |     0   (0)|          |                                                                                                                                                                         
                |*185 |         VIEW                                     |                         |     1 |    16 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                | 186 |          SORT GROUP BY                           |                         |     1 |    38 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                | 187 |           NESTED LOOPS                           |                         |     1 |    38 |       |     4   (0)| 00:00:01 |                                                                                                                                                                         
                | 188 |            NESTED LOOPS                          |                         |     1 |    24 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 189 |             INDEX FULL SCAN                      | I_OLAP_CUBES$           |     1 |    13 |       |     0   (0)|          |                                                                                                                                                                         
                | 190 |             TABLE ACCESS BY INDEX ROWID          | DEPENDENCY$             |     1 |    11 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*191 |              INDEX RANGE SCAN                    | I_DEPENDENCY1           |     3 |       |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*192 |            INDEX RANGE SCAN                      | I_OBJ1                  |     1 |    14 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 193 |         NESTED LOOPS                             |                         |     1 |    32 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*194 |          INDEX SKIP SCAN                         | I_USER2                 |     1 |    20 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*195 |          INDEX RANGE SCAN                        | I_OBJ4                  |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*196 |      FILTER                                      |                         |       |       |       |            |          |                                                                                                                                                                         
                |*197 |       HASH JOIN                                  |                         |     1 |   309 |       |    24   (5)| 00:00:01 |                                                                                                                                                                         
                | 198 |        MERGE JOIN CARTESIAN                      |                         |     1 |   254 |       |    23   (0)| 00:00:01 |                                                                                                                                                                         
                | 199 |         NESTED LOOPS OUTER                       |                         |     1 |   241 |       |    23   (0)| 00:00:01 |                                                                                                                                                                         
                | 200 |          NESTED LOOPS OUTER                      |                         |     1 |   237 |       |    22   (0)| 00:00:01 |                                                                                                                                                                         
                | 201 |           NESTED LOOPS OUTER                     |                         |     1 |   227 |       |    20   (0)| 00:00:01 |                                                                                                                                                                         
                | 202 |            NESTED LOOPS OUTER                    |                         |     1 |   223 |       |    19   (0)| 00:00:01 |                                                                                                                                                                         
                | 203 |             NESTED LOOPS OUTER                   |                         |     1 |   213 |       |    17   (0)| 00:00:01 |                                                                                                                                                                         
                | 204 |              NESTED LOOPS OUTER                  |                         |     1 |   207 |       |    15   (0)| 00:00:01 |                                                                                                                                                                         
                | 205 |               NESTED LOOPS                       |                         |     1 |   195 |       |    13   (0)| 00:00:01 |                                                                                                                                                                         
                | 206 |                NESTED LOOPS                      |                         |     1 |   191 |       |    12   (0)| 00:00:01 |                                                                                                                                                                         
                | 207 |                 NESTED LOOPS                     |                         |     1 |   181 |       |    10   (0)| 00:00:01 |                                                                                                                                                                         
                | 208 |                  NESTED LOOPS                    |                         |     1 |   152 |       |     9   (0)| 00:00:01 |                                                                                                                                                                         
                | 209 |                   NESTED LOOPS                   |                         |     1 |   131 |       |     8   (0)| 00:00:01 |                                                                                                                                                                         
                | 210 |                    NESTED LOOPS                  |                         |     1 |   128 |       |     7   (0)| 00:00:01 |                                                                                                                                                                         
                | 211 |                     NESTED LOOPS                 |                         |     1 |    95 |       |     6   (0)| 00:00:01 |                                                                                                                                                                         
                | 212 |                      NESTED LOOPS                |                         |     1 |    59 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                | 213 |                       TABLE ACCESS BY INDEX ROWID| USER$                   |     1 |    19 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*214 |                        INDEX UNIQUE SCAN         | I_USER1                 |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                | 215 |                       TABLE ACCESS BY INDEX ROWID| SDO_GEOM_METADATA_TABLE |     1 |    40 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*216 |                        INDEX RANGE SCAN          | SDO_GEOM_IDX            |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*217 |                      TABLE ACCESS BY INDEX ROWID | OBJ$                    |     1 |    36 |       |     3   (0)| 00:00:01 |                                                                                                                                                                         
                |*218 |                       INDEX RANGE SCAN           | I_OBJ2                  |     1 |       |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*219 |                     TABLE ACCESS CLUSTER         | TAB$                    |     1 |    33 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*220 |                      INDEX UNIQUE SCAN           | I_OBJ#                  |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                | 221 |                    TABLE ACCESS CLUSTER          | TS$                     |     1 |     3 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*222 |                     INDEX UNIQUE SCAN            | I_TS#                   |     1 |       |       |     0   (0)|          |                                                                                                                                                                         
                |*223 |                   TABLE ACCESS CLUSTER           | COL$                    |     1 |    21 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*224 |                  TABLE ACCESS CLUSTER            | COLTYPE$                |     1 |    29 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*225 |                 TABLE ACCESS BY INDEX ROWID      | OBJ$                    |     1 |    10 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*226 |                  INDEX RANGE SCAN                | I_OBJ3                  |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*227 |                INDEX RANGE SCAN                  | I_USER2                 |     1 |     4 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                | 228 |               TABLE ACCESS CLUSTER               | SEG$                    |     1 |    12 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*229 |                INDEX UNIQUE SCAN                 | I_FILE#_BLOCK#          |     1 |       |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*230 |              INDEX RANGE SCAN                    | I_OBJ1                  |     1 |     6 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*231 |             INDEX RANGE SCAN                     | I_OBJ1                  |     1 |    10 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*232 |            INDEX RANGE SCAN                      | I_USER2                 |     1 |     4 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                |*233 |           INDEX RANGE SCAN                       | I_OBJ1                  |     1 |    10 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                |*234 |          INDEX RANGE SCAN                        | I_USER2                 |     1 |     4 |       |     1   (0)| 00:00:01 |                                                                                                                                                                         
                | 235 |         BUFFER SORT                              |                         |   100 |  1300 |       |    22   (0)| 00:00:01 |                                                                                                                                                                         
                | 236 |          FIXED TABLE FULL                        | X$KSPPCV                |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*237 |        FIXED TABLE FULL                          | X$KSPPI                 |     1 |    55 |       |     0   (0)|          |                                                                                                                                                                         
                |*238 |       HASH JOIN                                  |                         |     1 |    23 |       |     3  (34)| 00:00:01 |                                                                                                                                                                         
                |*239 |        INDEX RANGE SCAN                          | I_OBJAUTH1              |     2 |    20 |       |     2   (0)| 00:00:01 |                                                                                                                                                                         
                | 240 |        FIXED TABLE FULL                          | X$KZSRO                 |   100 |  1300 |       |     0   (0)|          |                                                                                                                                                                         
                |*241 |       FIXED TABLE FULL                           | X$KZSPR                 |     5 |   130 |       |     0   (0)|          |                                                                                                                                                                         
                ------------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                         
                
                Predicate Information (identified by operation id):                                                                                                                                                                                                                                                          
                ---------------------------------------------------                                                                                                                                                                                                                                                          
                
                   6 - filter(((INTERNAL_FUNCTION("O"."SPARE3") OR ("S"."NODE" IS NULL AND  IS NOT NULL) OR  IS NOT NULL) 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  IS NOT                                                                                                                                                                          
                              NULL)))                                                                                                                                                                                                                                                                                        
                   7 - access("O"."OBJ#"="S"."OBJ#")                                                                                                                                                                                                                                                                         
                   8 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  12 - access("U"."NAME"='ROBERT_TEST2')                                                                                                                                                                                                                                                                     
                  13 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)                                                                                                                                                                                                                                                    
                       filter("O"."TYPE#"=5)                                                                                                                                                                                                                                                                                 
                  15 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR                                                                                                                                                                                       
                              (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50))))                                                                                                                                                                                                                                                  
                  16 - filter((("BA"."GRANTOR#"=USERENV('SCHEMAID') OR  IS NOT NULL) 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 (INTERNAL_FUNCTION("O"."TYPE#") 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  IS NOT                                                                                                                                                                      
                              NULL)))))                                                                                                                                                                                                                                                                                      
                  17 - filter(:B1 IS NULL)                                                                                                                                                                                                                                                                                   
                  22 - access("BU"."NAME"=:B1)                                                                                                                                                                                                                                                                               
                  23 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)                                                                                                                                                                                                                                                  
                  24 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  25 - access("BA"."OBJ#"="O"."OBJ#")                                                                                                                                                                                                                                                                        
                  26 - filter("KZSROROL"=:B1)                                                                                                                                                                                                                                                                                
                  28 - 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'))))                                                                                                                                                                                                     
                  29 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                  31 - 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'))))                                                                                                                                                                                                     
                  32 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                  33 - 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  IS NOT NULL))                                                                                                                                                                                                         
                  36 - access("O"."OBJ#"="ST"."SYN_ID")                                                                                                                                                                                                                                                                      
                  38 - access("S"."BASE_SYN_ID"=PRIOR NULL)                                                                                                                                                                                                                                                                  
                  39 - filter(( IS NOT NULL 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  IS NOT NULL)))                                                                                                                                                                                                        
                  40 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  42 - access("S"."OWNER"="BU"."NAME" AND "BU"."USER#"="O"."SPARE3")                                                                                                                                                                                                                                         
                  44 - access("S"."NAME"="O"."NAME")                                                                                                                                                                                                                                                                         
                  46 - filter("O"."TYPE#"=5)                                                                                                                                                                                                                                                                                 
                  47 - filter(( IS NOT NULL OR ("S"."NODE" IS NULL AND  IS NOT NULL)))                                                                                                                                                                                                                                       
                  49 - access("S"."OBJ#"=:B1)                                                                                                                                                                                                                                                                                
                  50 - filter((("BA"."GRANTOR#"=USERENV('SCHEMAID') OR  IS NOT NULL) 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 (INTERNAL_FUNCTION("O"."TYPE#") 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  IS NOT                                                                                                                                                                      
                              NULL)))))                                                                                                                                                                                                                                                                                      
                  51 - filter(:B1 IS NULL)                                                                                                                                                                                                                                                                                   
                  56 - access("BU"."NAME"=:B1)                                                                                                                                                                                                                                                                               
                  57 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)                                                                                                                                                                                                                                                  
                  58 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  59 - access("BA"."OBJ#"="O"."OBJ#")                                                                                                                                                                                                                                                                        
                  60 - filter("KZSROROL"=:B1)                                                                                                                                                                                                                                                                                
                  62 - 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'))))                                                                                                                                                                                                     
                  63 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                  64 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR                                                                                                                                                                                       
                              (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50))))                                                                                                                                                                                                                                                  
                  66 - 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'))))                                                                                                                                                                                                     
                  67 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                  68 - 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  IS NOT NULL))                                                                                                                                                                                                         
                  69 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  71 - access("S"."OWNER"="BU"."NAME" AND "BU"."USER#"="O"."SPARE3")                                                                                                                                                                                                                                         
                  73 - access("S"."NAME"="O"."NAME")                                                                                                                                                                                                                                                                         
                  75 - filter("O"."TYPE#"=5)                                                                                                                                                                                                                                                                                 
                  77 - 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'))))                                                                                                                                                                                                     
                  78 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                  81 - access("U"."NAME"='ROBERT_TEST2')                                                                                                                                                                                                                                                                     
                  82 - access("O"."SPARE3"="U"."USER#" AND "O"."TYPE#"=5)                                                                                                                                                                                                                                                    
                       filter("O"."TYPE#"=5)                                                                                                                                                                                                                                                                                 
                  84 - access("S"."OBJ#"="ST"."SYN_ID")                                                                                                                                                                                                                                                                      
                       filter("O"."OBJ#"="S"."OBJ#")                                                                                                                                                                                                                                                                         
                  85 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                  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("B"."SDO_TABLE_NAME"="A"."OBJECT_NAME" AND "B"."SDO_OWNER"="A"."OWNER")                                                                                                                                                                                                                        
                  93 - access("B"."SDO_OWNER"="S"."TABLE_OWNER" AND "B"."SDO_TABLE_NAME"="S"."TABLE_NAME")                                                                                                                                                                                                                   
                  94 - filter(BITAND("S"."XPFLAGS",8388608)=8388608)                                                                                                                                                                                                                                                         
                  95 - access("S"."OBJ#"=:B1)                                                                                                                                                                                                                                                                                
                  96 - filter((INTERNAL_FUNCTION("A"."OBJECT_TYPE") AND "A"."OBJECT_NAME"="S"."TABLE_NAME" AND                                                                                                                                                                                                               
                              "A"."OWNER"="S"."TABLE_OWNER"))                                                                                                                                                                                                                                                                
                  97 - filter(((("O"."TYPE#"<>1 AND "O"."TYPE#"<>10) OR ("O"."TYPE#"=1 AND =1)) AND (INTERNAL_FUNCTION("O"."SPARE3") OR                                                                                                                                                                                      
                              INTERNAL_FUNCTION("O"."TYPE#") OR ("O"."TYPE#"=12 AND ( IS NOT NULL OR  IS NOT NULL)) OR (INTERNAL_FUNCTION("O"."TYPE#")                                                                                                                                                                       
                              AND  IS NOT NULL) OR ("O"."TYPE#"<>12 AND "O"."TYPE#"<>29 AND "O"."TYPE#"<>9 AND "O"."TYPE#"<>13 AND "O"."TYPE#"<>11 AND                                                                                                                                                                       
                              "O"."TYPE#"<>30 AND "O"."TYPE#"<>8 AND "O"."TYPE#"<>7 AND "O"."TYPE#"<>14 AND "O"."TYPE#"<>56 AND "O"."TYPE#"<>28 AND                                                                                                                                                                          
                              "O"."TYPE#"<>93 AND  IS NOT NULL) OR ("O"."TYPE#"=6 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") AND ( IS NOT NULL                                                                                                                                                                     
                              OR  IS NOT NULL)) OR ("O"."TYPE#"=13 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=11 AND ( IS NOT NULL OR  IS NOT                                                                                                                                                                       
                              NULL)) OR ("O"."TYPE#"=14 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=19 AND  IS NOT NULL) OR ("O"."TYPE#"=44 AND                                                                                                                                                                      
                              IS NOT NULL) OR ("O"."TYPE#"=22 AND  IS NOT NULL) OR ("O"."TYPE#"=48 AND  IS NOT NULL) OR ("O"."TYPE#"=33 AND  IS NOT NULL)                                                                                                                                                                    
                              OR ("O"."TYPE#"=42 AND  IS NOT NULL) OR ("O"."TYPE#"=46 AND  IS NOT NULL) OR ("O"."TYPE#"=62 AND  IS NOT NULL) OR                                                                                                                                                                              
                              ("O"."TYPE#"=68 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#")                                                                                                                                                                      
                              AND  IS NOT NULL) OR ("O"."TYPE#"=23 AND  IS NOT NULL) OR ("O"."TYPE#"=32 AND  IS NOT NULL) OR ("O"."TYPE#"=59 AND  IS NOT                                                                                                                                                                     
                              NULL) OR ("O"."TYPE#"=81 AND  IS NOT NULL) OR ("O"."TYPE#"=82 AND  IS NOT NULL) OR ("O"."TYPE#"=87 AND  IS NOT NULL) OR                                                                                                                                                                        
                              ("O"."TYPE#"=92 AND  IS NOT NULL) OR ("O"."TYPE#"=94 AND  IS NOT NULL) OR ("O"."TYPE#"=95 AND  IS NOT NULL) OR                                                                                                                                                                                 
                              ("O"."TYPE#"=55 AND =1) OR ("O"."TYPE#"=93 AND ( IS NOT NULL OR  IS NOT NULL) AND =1)) 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 (INTERNAL_FUNCTION("O"."TYPE#") 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  IS NOT                                                                                                                                                                      
                              NULL)))))                                                                                                                                                                                                                                                                                      
                  98 - access("O"."SPARE3"="U"."USER#")                                                                                                                                                                                                                                                                      
                 100 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                 102 - filter((BITAND("O"."FLAGS",128)=0 AND "O"."LINKNAME" IS NULL AND "O"."NAME"<>'_NEXT_OBJECT' AND                                                                                                                                                                                                       
                              "O"."NAME"<>'_default_auditing_options_'))                                                                                                                                                                                                                                                     
                 103 - 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))                                                                                                                                                                                                                                                                                
                 104 - access("I"."OBJ#"=:B1)                                                                                                                                                                                                                                                                                
                 105 - access("OA"."GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                    
                 107 - filter(BITAND("T"."PROPERTY",24)=0)                                                                                                                                                                                                                                                                   
                 108 - access("T"."OBJ#"=:B1)                                                                                                                                                                                                                                                                                
                 109 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26)                                                                                                                                                                                                                                         
                       filter("OA"."PRIVILEGE#"=26)                                                                                                                                                                                                                                                                          
                 111 - filter((((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 112 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR                                                                                                                                                                                       
                              (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50))))                                                                                                                                                                                                                                                  
                 113 - access("GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                         
                 114 - access("OBJ#"=:B1)                                                                                                                                                                                                                                                                                    
                       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))                                                                                                                                                                                                                  
                 116 - filter(((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                                                      
                 117 - access("OA"."GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                    
                 118 - access("OA"."OBJ#"=:B1)                                                                                                                                                                                                                                                                               
                       filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))                                                                                                                                                                                                                                                
                 120 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241))))                                                                                                                                                                                    
                 121 - access("OA"."GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                    
                 122 - access("OA"."OBJ#"=:B1)                                                                                                                                                                                                                                                                               
                       filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))                                                                                                                                                                                                                                                
                 124 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241))))                                                                                                                                                                                    
                 130 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)                                                                                                                                                                                                                                         
                       filter(("O"."TYPE#"=9 AND "O"."TYPE#"<>88))                                                                                                                                                                                                                                                           
                 133 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                 134 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)                                                                                                                                                                                                                
                       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))                                                                                                                                                                                                                                         
                 135 - access("DEP"."D_OBJ#"=:B1)                                                                                                                                                                                                                                                                            
                 136 - filter("DEP"."P_OBJ#"="O"."OBJ#")                                                                                                                                                                                                                                                                     
                 137 - filter((((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 143 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)                                                                                                                                                                                                                                        
                       filter(("O"."TYPE#"=13 AND "O"."TYPE#"<>88))                                                                                                                                                                                                                                                          
                 146 - access("O"."OWNER#"="U"."USER#")                                                                                                                                                                                                                                                                      
                 147 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)                                                                                                                                                                                                                
                       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))                                                                                                                                                                                                                                         
                 148 - access("DEP"."D_OBJ#"=:B1)                                                                                                                                                                                                                                                                            
                 149 - filter("DEP"."P_OBJ#"="O"."OBJ#")                                                                                                                                                                                                                                                                     
                 150 - filter((((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 151 - access("GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                         
                 154 - access("OBJ#"=:B1)                                                                                                                                                                                                                                                                                    
                 155 - access("BO#"="OBJ#" AND "PRIVILEGE#"=9)                                                                                                                                                                                                                                                               
                       filter("PRIVILEGE#"=9)                                                                                                                                                                                                                                                                                
                 157 - filter((((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 158 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-192))))                                                                                                                                                                                                                                                                        
                 159 - filter(((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                                                          
                 160 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-203) OR (-"KZSPRPRV")=(-204))))                                                                                                                                                                                                                                                
                 161 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR                                                                                                                                                                                       
                              (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50))))                                                                                                                                                                                                                                                  
                 162 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-254))))                                                                                                                                                                                                                                                                        
                 163 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-249))))                                                                                                                                                                                                                                                                        
                 164 - filter((((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 165 - filter(((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                                                      
                 166 - filter((((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 167 - filter((((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 168 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-208))))                                                                                                                                                                                                                                                                        
                 169 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-261))))                                                                                                                                                                                                                                                                        
                 170 - filter((((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE')))                                                                                                                                                                                                            
                 171 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294))))                                                                                                                                                                                    
                 172 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-285))))                                                                                                                                                                                                                                                                        
                 173 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))                                                                                                                                                                                                                        
                 174 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-318))))                                                                                                                                                                                                                                                                        
                 175 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322))))                                                                                                                                                                                    
                 177 - access("GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                         
                 178 - access("OBJ#"=:B1)                                                                                                                                                                                                                                                                                    
                 180 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-312) OR (-"KZSPRPRV")=(-313))))                                                                                                                                                                                                                                                
                 181 - access("GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                         
                 182 - access("OBJ#"=:B1)                                                                                                                                                                                                                                                                                    
                 184 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR                                                                                                                                                                                    
                              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))                                                                                                                                                                                                                        
                 185 - filter("DA"."OBJ#"=:B1)                                                                                                                                                                                                                                                                               
                 191 - access("C"."OBJ#"="D"."D_OBJ#")                                                                                                                                                                                                                                                                       
                 192 - access("DO"."OBJ#"="D"."P_OBJ#" AND "DO"."TYPE#"=92)                                                                                                                                                                                                                                                  
                       filter("DO"."TYPE#"=92)                                                                                                                                                                                                                                                                               
                 194 - 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'))))                                                                                                                                                                                                     
                 195 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")                                                                                                                                                                                                                        
                 196 - filter(("O"."OWNER#"=USERENV('SCHEMAID') OR  IS NOT NULL OR  IS NOT NULL))                                                                                                                                                                                                                            
                 197 - access("KSPPI"."INDX"="KSPPCV"."INDX")                                                                                                                                                                                                                                                                
                 214 - access("U"."NAME"="S"."TABLE_OWNER")                                                                                                                                                                                                                                                                  
                 216 - access("B"."SDO_OWNER"="U"."NAME" AND "B"."SDO_TABLE_NAME"="S"."TABLE_NAME")                                                                                                                                                                                                                          
                       filter("B"."SDO_OWNER"="S"."TABLE_OWNER")                                                                                                                                                                                                                                                             
                 217 - filter(BITAND("O"."FLAGS",128)=0)                                                                                                                                                                                                                                                                     
                 218 - access("O"."OWNER#"="U"."USER#" AND "O"."NAME"="S"."TABLE_NAME")                                                                                                                                                                                                                                      
                       filter("B"."SDO_TABLE_NAME"="O"."NAME")                                                                                                                                                                                                                                                               
                 219 - filter(BITAND("T"."PROPERTY",1)=1)                                                                                                                                                                                                                                                                    
                 220 - access("O"."OBJ#"="T"."OBJ#")                                                                                                                                                                                                                                                                         
                 222 - access("T"."TS#"="TS"."TS#")                                                                                                                                                                                                                                                                          
                 223 - filter(("TC"."NAME"='SYS_NC_ROWINFO$' AND "T"."OBJ#"="TC"."OBJ#"))                                                                                                                                                                                                                                    
                 224 - filter(("TC"."OBJ#"="AC"."OBJ#" AND "TC"."INTCOL#"="AC"."INTCOL#"))                                                                                                                                                                                                                                   
                 225 - filter("TY"."TYPE#"<>10)                                                                                                                                                                                                                                                                              
                 226 - access("AC"."TOID"="TY"."OID$")                                                                                                                                                                                                                                                                       
                       filter("TY"."OID$" IS NOT NULL)                                                                                                                                                                                                                                                                       
                 227 - access("TY"."OWNER#"="USER#")                                                                                                                                                                                                                                                                         
                 229 - access("T"."TS#"="S"."TS#" AND "T"."FILE#"="S"."FILE#" AND "T"."BLOCK#"="S"."BLOCK#")                                                                                                                                                                                                                 
                 230 - access("T"."BOBJ#"="CO"."OBJ#")                                                                                                                                                                                                                                                                       
                 231 - access("T"."DATAOBJ#"="CX"."OBJ#")                                                                                                                                                                                                                                                                    
                 232 - access("CX"."OWNER#"="CU"."USER#")                                                                                                                                                                                                                                                                    
                 233 - access("AC"."SYNOBJ#"="SO"."OBJ#")                                                                                                                                                                                                                                                                    
                 234 - access("SO"."OWNER#"="USER#")                                                                                                                                                                                                                                                                         
                 237 - filter("KSPPI"."KSPPINM"='_dml_monitoring_enabled')                                                                                                                                                                                                                                                   
                 238 - access("GRANTEE#"="KZSROROL")                                                                                                                                                                                                                                                                         
                 239 - access("OA"."OBJ#"=:B1)                                                                                                                                                                                                                                                                               
                 241 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR                                                                                                                                                                                       
                              (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50))))                                                                                                                                                                                                                                                  
                
                Note                                                                                                                                                                                                                                                                                                         
                -----                                                                                                                                                                                                                                                                                                        
                   - SQL profile SYS_SQLPROF_0146d74a40920007 used for this statement                                                                                                                                                                                                                                        
                
                • 5. Re: SQL Profile stopped working - new one doesn't work
                  R o b

                  Hi there,

                   

                  unfortunatly we haven't been able to solve the issue and for the time being we have to live with (maybe the issue disappears one day as sudden as it apperead).

                  When we run the application now it does most things *before* it tries to exectue the problematic INSERT. We then have to kill it - not nice, but can't see a solution right now.

                   

                  A bit disappointing that we have a hight end database system but it let us down with such a simple issue (Select fast - INSERT INTO SELECT extremly slow - doesn't seem so uncommon).

                   

                  Another idea - if someone faces a similar issue - is to make use of DBMS_ADVANCED_REWRITE to prevent execution of the INSERT statement. (But no time to follow up on this right now),

                   

                  Rob.

                  • 6. Re: SQL Profile stopped working - new one doesn't work
                    Dom Brooks

                    I presume you created the SQL Profile via SQL Tuning Advisor?

                    In which case it's just a bunch of cardinality adjustments which may or may not be effective.

                     

                    I would follow the SQL tuning advice from:

                    https://community.oracle.com/thread/865295

                    and

                    When your query takes too long ...

                     

                    Basically follow the tuning by cardinality feedback principle by getting the actual execution plan and the actual rowsource cardinality metrics from the problem execution (see real-time sql monitoring perhaps?)

                     

                    Then you could find out which estimates are the problematic ones, influence the plan manually and then manually apply the hints to the embedded SQL via baseline or COE SQL profile.

                     

                    The likely suspect/s is/are one or more of the many rowsources estimates of 1 row, particularly when that one row estimate results in a MERGE JOIN CARTESIAN/BUFFER SORT or an INDEX SKIP SCAN.

                    This should be obvious from the RTSM output.

                     

                    You might also want to check if your fixed stats  need gathering.

                    https://blogs.oracle.com/optimizer/entry/fixed_objects_statistics_and_why