How to Collect Statistics

4 05 2011

May 4, 2011

In a previous article I shared a couple of the slides that I put together for an Oracle Database presentation for a specific ERP group – a presentation that as designed was far too long to fit into the permitted time slot.  I thought that in today’s blog article I would share a couple of “light-weight” slides from the presentation on the topic of statistics collection.

The notes that go along with the above slide are as follows:

Starting with Oracle Database 10.1 the query optimizer uses system statistics by default.  These statistics tell the optimizer characteristics about the server’s performance.  If you do not collect system statistics, Oracle will automatically use standardized system statistics, which are called NOWORKLOAD statistics.  When your server is under a typical to heavy load, you should gather the system statistics, which may be accomplished using a SQL*Plus command similar to the command at the top of this slide – this command will collect the statistics for a 60 minute time period and then set the statistic values. You can check the current system statistics using the SQL statement at the left.  If you see statistics like those at the right, that means your database is still using NOWORKLOAD statistics.

There is a bug in Oracle Database 11.2.0.1 and 11.2.0.2 related to the calculation of the SREADTIM – the average single-block read time expressed in milliseconds, and the MREADTIM – the average multi-block read time expressed in milliseconds.

The notes that go along with the above slide are as follows:

This slide shows an example of the statistics collection bug in Oracle Database 11.2.0.1 and Oracle Database 11.2.0.2.  Notice the large values for SREADTIM and MREADTIM.  These values are typically in the range of 4 to 12 milliseconds, and would normally appear as one or two digit values.  Watch out for cases where the SREADTIM value is greater than the MREADTIM value – that is almost certainly an error in the statistics collecting process and could be due to SAN read-ahead caching.

The calculated value of 78 for the MBRC, which is the average number of blocks read from disk during multi-block reads, might be a little high.  A high value for this parameter could cause the optimizer to use full table scans a little too frequently, and could lead to excessive CPU consumption problems – an example of this problem appears when Visual no longer uses the index on the PART_ID column when querying the INVENTORY_TRANS table when the PART_ID column is specified in the WHERE clause of a SQL statement.

The notes that go along with the above slide are as follows:

If you find that the System statistics were collected incorrectly, or if you need to set the system statistics of a test server to match the collected statistics of the production server, you can manually set the statistic values as shown at the top of this slide.

The notes that go along with the above slide are as follows:

It is important to make certain that the fixed object statistics are collected.  If the statistics are not collected, there is a strong chance that some queries of Oracle Database views will be slow, or even result in the crashing of the user’s session – see the link at the bottom of this slide for an example that shows what might happen if these statistics are not collected.  You can verify that the statistics were collected by executing the SQL statement at the left – if the SQL statement returns no rows, then the statistics have not been collected.

The notes that go along with the above slide are as follows:

Once you have collected the fixed object statistics, the query at the left will return output like you see on the right side of this slide.

The notes that go along with the above slide are as follows:

You should collect statistics weekly for the objects in the SYSADM schema (where the ERP data is located), typically when the database experiences little activity.  You can collect those statistics using the SQL*Plus command shown at the top of this slide.  Starting with Oracle Database 10.1 it is also a good idea to collect statistics for the objects in the SYS schema, and that can be done using the second command. 

Starting with Oracle Database 10.1 a stale statistics collecting process collects missing and out of date statistics for objects, typically starting around 10PM.  Even though the statistics collection is now partially automated in recent Oracle Database releases, it is still a good practice to collect statistics weekly.  You can verify that statistics were recently collected using the SQL statements at the bottom of this slide.

The notes that go along with the above slide are as follows:

I have been mentioning this warning for the last couple of years in the ERP mailing list – do not use the Update Database Statistics menu item in Visual to collect statistics.  Even in Visual 7.0, this menu command issues ANALYZE commands to collect the statistics, rather than the DBMS_STATS package which became the correct approach when Oracle 8i was introduced a decade ago.  The ANALYZE command does not collect all of the statistics needed by the Oracle query optimizer, and collects some statistics that potentially cause problems for the query optimizer.  You can execute the SQL statement shown on this slide to see if any tables in the SYSADM schema contain remnants from ANALYZE that need to be fixed.  If the query returns any rows, execute the SQL statements that are returned.

—–

Any comments about the above?  How would you do things differently?


Actions

Information

30 responses

4 05 2011
Mark W. Farnham

On slide 18, regarding making a test db behave like a production db, it might be useful to mention the behavior you are talking about is plan generation.
While I’m certain it is obvious to you, some of your readers might misinterpret your remark as an outlandish claim that you can magically make a test server of presumably less horsepower and likely with less speedy storage media actually perform better. Of course you’re making no such claim and you’re just pointing out that if you feed the CBO the same data on two drastically different machines, you can get it to produce the same plans. Since you’re not interested in the optimal plan for the test server, but rather in seeing what plans will be generated on the production machine, this is entirely correct.

4 05 2011
Charles Hooper

Mark,

Excellent points, and I agree that I should have been more clear with the description – in this case to indicate that the goal was to produce the same execution plans on test and production. Your comment also reminded me of this 4 part series:

http://hoopercharles.wordpress.com/2010/11/21/different-performance-from-standard-edition-and-enterprise-edition-1/

Thank you for taking the time to help clarify the meaning of the blog article contents.

4 05 2011
Damir

Nice work!
THX for sharing this info.
Damir Vadas

5 05 2011
Martin Preiss

Charles,
would it add something to mention that there are two flavour of NOWORKLOAD system statistics (default and gathered)? – perhaps not …

5 05 2011
Martin Preiss

the (small) difference between the two modes is described in Randolf Geists Blog: http://oracle-randolf.blogspot.com/2009/04/understanding-different-modes-of-system.html

5 05 2011
Charles Hooper

Thank you for referencing Randolf’s article. Either I forgot, or I was unaware that it was possible to gather NOWORKLOAD system statistics.

In retrospect, I should have referenced Randolf’s blog article series about system statistics on slides 16-18.

5 05 2011
Sokrates

Charles,

“…There is a bug in Oracle Database 11.2.0.1 and 11.2.0.2 related to the calculation of the SREADTIM…”

are you talking about bug 11794684 ?
or the related one bug 9842771 ?
for the latter one, there is a patch available
We applied it and started to work with gathered system stats, which resulted on really bad overall performance.

So we decided to work with the system stats of 10.2, which resulted in much better performance.
Would be interesting to here if somebody else has experiences with Patch 9842771

5 05 2011
Charles Hooper

Sokrates,

Thank you for locating the Metalink (MOS) articles.

My comment in the presentation was based on my observation of SYS.AUX_STATS$, after I gathered system statistics on a system using SSD drives (I was curious to know just how low the numbers could go). My first thought was that those numbers just can’t be right. I checked the documentation for Oracle Database 11.2 and compared it with the documentation for 10.2 and 11.1, but I did not find any indication that there was an intentional scale change in the statistic values. I simply manually set the values to match what I encountered with Oracle Database 11.1.0.7 and then forgot about the problem until I read this article:

http://antognini.ch/2010/11/workload-system-statistics-in-11g/

I need to double-check, but I believe that the problem is still present in patch 4 for 11.2.0.2 on the Windows 64 bit platform (11896292 https://supporthtml.oracle.com/ep/faces/secure/ml3/patches/PatchDownload.jspx?_afPfm=1f# ). I see that patch 5 for 11.2.0.2 on the Windows platform was just recently released (12344273 https://supporthtml.oracle.com/ep/faces/secure/ml3/patches/PatchDownload.jspx?_afPfm=1f# ) so I might test that patch release.

5 05 2011
Charles Hooper

OK, I double-checked the system statistics collection with Oracle Database 11.2.0.2 on 64 bit Windows with patch 4 (early April 2011) installed. Here are the collected statistics:

PNAME                PVAL1 PVAL2
--------------- ---------- ----------------
STATUS                     COMPLETED
DSTART                     05-05-2011 13:35
DSTOP                      05-05-2011 14:35
FLAGS                    0
CPUSPEEDNW      2116.57559
IOSEEKTIM               10
IOTFRSPEED            4096
SREADTIM          1659.545
MREADTIM          3927.108
CPUSPEED              1943
MBRC                     9
MAXTHR           156431360
SLAVETHR

Unless it takes an average of 1.6 seconds to perform a single block read and 3.9 seconds to perform a multi-block read from SSD, the bug is still present in patch 4. I will test patch 5 shortly to see if the bug fix is part of that patch.

5 05 2011
Charles Hooper

It appears that 11.2.0.2 on Windows x64 with patch 5 (late April 2011) still encounters the bug when calculating SREADTIM and MREADTIM:

PNAME                PVAL1 PVAL2
--------------- ---------- ----------------
STATUS                     COMPLETED
DSTART                     05-05-2011 15:21
DSTOP                      05-05-2011 15:41
FLAGS                    0
CPUSPEEDNW      2116.57559
IOSEEKTIM               10
IOTFRSPEED            4096
SREADTIM          1247.132
MREADTIM          3575.567
CPUSPEED              1922
MBRC                     6
MAXTHR           155910144
SLAVETHR
5 05 2011
Andreas Buckenhofer

Statistics collection for fixed objects should also (same with system statistics as you already mentioned) be done during a time with “representative workload” and not e.g. during the night when the DB is idle.

5 05 2011
Charles Hooper

Andreas,

Thank you for the comment. Could you provide a little more detail to explain why fixed object statistics should be collected during a time of “representative workload” and not during the night when the DB is idle.

There is a good chance that I am overlooking something that is very obvious, but I thought that gathering fixed object statistics only populated SYS.TAB_STATS$ and SYS.IND_STATS$, so it would seem that the best time to collect that information is when the database instance is not very busy servicing normal database requests. Obviously, if I am wrong I would like to know more information so that I do not repeat the same mistaken recommendation again in the future.

5 05 2011
Martin Preiss

In AskTom (http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:60121137844769#tom62191850899057) Mr. Kyte wrote (in 2006): “the x$ tables would change size in response to init.ora setting changes generally. Setting processes higher will add rows to various x$ views for example. so, they could be considered a one time thing unless you make a big change to your parameter settings.”

5 05 2011
Martin Preiss

so the system load should not be significant – as I understand it

5 05 2011
Andreas Buckenhofer

Charles,

there are articles in metalink (e.g. How to gather statistics on SYS objects and fixed_objects? [ID 457926.1]) that mention to gather these statistics while there is a representative load (whatever a representative load avtually is).
“Since fixed objects record current database activity; statistics gathering should be done when database has a representative load so that the statistics reflect the normal database activity”. My interpretation was that these statistics have to be gathered again when the “representative” load changes significantly or if there are changes to server parameters (as already by Martin mentioned).

Regards,
Andreas

5 05 2011
Charles Hooper

Andreas,

Thank you for the Metalink (MOS) Doc ID. Interesting, yet I was still skeptical because I have previously seen incorrect information in Metalink (MOS). I looked at the link provided by Martin, but I scrolled down a bit to a test case that was posted by Tom Kyte.

I did a bit of experimentation on 11.2.0.2 using the test case posted by Tom Kyte.

SET AUTOTRACE ON
SET LINESIZE 140
SET PAGESIZE 1000

SELECT COUNT(*) FROM V$SESSION;
 
  COUNT(*)
----------
        24
 
Execution Plan
----------------------------------------------------------
Plan hash value: 505450406
 
----------------------------------------------------------------------------------------------
| Id  | Operation                  | Name            | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |                 |     1 |    25 |     0   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE            |                 |     1 |    25 |            |          |
|   2 |   NESTED LOOPS             |                 |    39 |   975 |     0   (0)| 00:00:01 |
|   3 |    NESTED LOOPS            |                 |    39 |   468 |     0   (0)| 00:00:01 |
|   4 |     FIXED TABLE FULL       | X$KSLWT         |    39 |   312 |     0   (0)| 00:00:01 |
|*  5 |     FIXED TABLE FIXED INDEX| X$KSLED (ind:2) |     1 |     4 |     0   (0)| 00:00:01 |
|*  6 |    FIXED TABLE FIXED INDEX | X$KSUSE (ind:1) |     1 |    13 |     0   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
   5 - filter("W"."KSLWTEVT"="E"."INDX")
   6 - filter(BITAND("S"."KSUSEFLG",1)0 AND BITAND("S"."KSSPAFLG",1)0 AND
              "S"."INST_ID"=USERENV('INSTANCE') AND "S"."INDX"="W"."KSLWTSID")
 
Statistics
---------------------------------------------------
          1  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        526  bytes sent via SQL*Net to client
        519  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

OK, in the above I see the number 39, let’s re-collect the fixed object statistics and see what happens:

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS(NULL)


SELECT COUNT(*) FROM V$SESSION;

  COUNT(*)
----------
        24


Execution Plan
----------------------------------------------------------
Plan hash value: 505450406

----------------------------------------------------------------------------------------------
| Id  | Operation                  | Name            | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |                 |     1 |    25 |     0   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE            |                 |     1 |    25 |            |          |
|   2 |   NESTED LOOPS             |                 |    26 |   650 |     0   (0)| 00:00:01 |
|   3 |    NESTED LOOPS            |                 |    26 |   312 |     0   (0)| 00:00:01 |
|   4 |     FIXED TABLE FULL       | X$KSLWT         |    26 |   208 |     0   (0)| 00:00:01 |
|   5 |     FIXED TABLE FIXED INDEX| X$KSLED (ind:2) |     1 |     4 |     0   (0)| 00:00:01 |
|   6 |    FIXED TABLE FIXED INDEX | X$KSUSE (ind:1) |     1 |    13 |     0   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        526  bytes sent via SQL*Net to client
        519  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

Now we are seeing the number 26 where we had previously seen the number 39. Let’s start up about 15 sessions performing database activity and collect fixed object statistics again:

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS(NULL)

PL/SQL procedure successfully completed.

SELECT COUNT(*) FROM V$SESSION;

  COUNT(*)
----------
        29
 

Execution Plan
----------------------------------------------------------
Plan hash value: 505450406

----------------------------------------------------------------------------------------------
| Id  | Operation                  | Name            | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |                 |     1 |    25 |     0   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE            |                 |     1 |    25 |            |          |
|   2 |   NESTED LOOPS             |                 |    29 |   725 |     0   (0)| 00:00:01 |
|   3 |    NESTED LOOPS            |                 |    29 |   348 |     0   (0)| 00:00:01 |
|   4 |     FIXED TABLE FULL       | X$KSLWT         |    29 |   232 |     0   (0)| 00:00:01 |
|   5 |     FIXED TABLE FIXED INDEX| X$KSLED (ind:2) |     1 |     4 |     0   (0)| 00:00:01 |
|   6 |    FIXED TABLE FIXED INDEX | X$KSUSE (ind:1) |     1 |    13 |     0   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------
 
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        526  bytes sent via SQL*Net to client
        519  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

Now, what was originally showing 39 shows 29, which matches the output for COUNT(*) FROM V$SESSION, but I can’t explain why the number of sessions counted only changed by 5 when there were an additional 15 sessions connected to the database.

The above test case output does appear to agree with Andreas’ statement. I think that this is another case where the real value of the articles on my blog does not fully develop until comments start appearing on those article.

8 05 2011
Log Buffer #219, A Carnival of the Vanities for DBAs | The Pythian Blog

[...] have got to read the blog post to see its beauty and the hard work that goes behind its production. Charles Hooper, one of my favorite bloggers does it [...]

19 05 2011
Martin Preiss

Charles,
I know, this is not AskCharles, but since you have written a lot about Excel-access on Oracle databases perhaps you know the answer to the following question – which is loosely related to the thread’s topic:
When I make an OLEDEB-connection from Excel (or SQL Server Analysis Services) to an Oracle database, Excel tries to get a list of accessible objects with a query like:

SELECT *
FROM   (SELECT ...
         FROM   all_objects o1
        WHERE  ...
        UNION
        SELECT ...
        FROM   all_objects o2,
               all_objects o3,
               all_synonyms s
        WHERE  ...) tables
ORDER  BY 4,
          2,
          3  ;

In 10.2.0.4 the query needs a few seconds (for a user with dba role) but in 11.1.0.7 it’s considerably slower:

Version            Role      Rows            sec
--------        -------    ------   ------------
10.2.0.4            DBA     19824              3      
10.2.0.4        CONNECT      2259             45
11.1.0.7            DBA     23200             40
11.1.0.7        CONNECT      3135            512

For the 11.1.0.7 database fixed table and dictionary stats are created (and seem to include reasonable values). It’s quite clear that the difference comes from all_objects: when I compare the definitions in catalog.sql (10.2.0.4) and cdcore.sql (11.1.0.7) I see some changes in the definition (no_expand hint, new columns namespace, edition, new object_types for mining and olap elements etc. in 11g) – but when I create a test view with the old 10.2.0.4-definition in 11.1.0.7 the performance is similar to the (bad) performance of the new all_objects; so I guess the problem is not the view but the different objects.
The execution plan in 11.1.0.7 shows a complex FILTER operation (and the cardinalities seem to be quite ok when I use gather_plan_statistics) – but I don’t plan to optimize internal data dictionary queries …
I have no idea if there are other options to improve the performance – or if this is the expected behavior in 11g. Do you know the problem – and is this a problem?
Regards
Martin

19 05 2011
Charles Hooper

Martin,

I do not have the answer for you, but your experience is not unique:

http://www.sqlservercentral.com/Forums/Topic852243-1042-1.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/381cd818-e999-4e26-8e80-d62188653a12/

One solution is to not have the program execute that SQL statement at all. If you are using the Microsoft Query tool in Excel, simply turn off the “Use the Query Wizard to create/edit queries”. Based on the above links, there appears to be a similar option in the other tool. If you must use the Microsoft Query tool, it appears that you can improve performance by clicking the “Options…” button on the screen where the tables/columns are normally listed. Uncheck “System Tables” and “Synonyms”, and consider specifying a specific owner.

The SQL statement that you posted reminded me of an earlier forum post:

http://forums.oracle.com/forums/thread.jspa?threadID=640675

Use the DBA_ views rather than the ALL_ views if possible for performance reasons. You *might* be able to accomplish this using either a materialized view or SYS.DBMS_ADVANCED_REWRITE.DECLARE_REWRITE_EQUIVALENCE.

The SQL statement that I obtained from an XP box with the 10.2.0.1 client looks like this (note the RULE hints) – STATISTICS_LEVEL set to ALL:
————————————————
select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner table_owner, o1.object_name table_name, decode(o1.owner,’SYS’, decode(o1.object_type,’TABLE’,’SYSTEM TABLE’,’VIEW’, ‘SYSTEM VIEW’, o1.object_type), ‘SYSTEM’, decode(o1.object_type,’TABLE’,’SYSTEM TABLE’,’VIEW’, ‘SYSTEM VIEW’, o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in (‘TABLE’, ‘VIEW’) union select /*+ RULE */ null table_qualifier, s.owner table_owner, s.synonym_name table_name, ‘SYNONYM’ table_type, null remarks from all_objects o3, all_synonyms s where o3.object_type in (‘TABLE’,’VIEW’) and s.table_owner= o3.owner and s.table_name = o3.object_name union select /*+ RULE */ null table_qualifier, s1.owner table_owner, s1.synonym_name table_name, ‘SYNONYM’ table_type, null remarks from all_synonyms s1 where s1.db_link is not null ) tables WHERE 1=1 AND ( table_type = ‘TABLE’ OR table_type = ‘SYSTEM TABLE’ OR table_type = ‘VIEW’ OR table_type = ‘SYNONYM’ ) ORDER BY 4,2,3
————————————————

The above SQL statement yielded an execution plan that appeared like the following (11.2.0.2):

Plan hash value: 3668676768
 
------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                      | Name                    | Starts | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                               |                         |      1 |   8152 |00:00:03.96 |    1642K|       |       |          |
|   1 |  SORT ORDER BY                                 |                         |      1 |   8152 |00:00:03.96 |    1642K|   619K|   472K|  550K (0)|
|   2 |   VIEW                                         |                         |      1 |   8152 |00:00:03.95 |    1642K|       |       |          |
|   3 |    SORT UNIQUE                                 |                         |      1 |   8152 |00:00:03.95 |    1642K|   832K|   510K|  739K (0)|
|   4 |     UNION-ALL                                  |                         |      1 |   8152 |00:00:03.94 |    1642K|       |       |          |
|*  5 |      TABLE ACCESS BY INDEX ROWID               | SUM$                    |      1 |      0 |00:00:00.01 |       2 |       |       |          |
|*  6 |       INDEX UNIQUE SCAN                        | I_SUM$_1                |      1 |      1 |00:00:00.01 |       1 |       |       |          |
|*  7 |      VIEW                                      | ALL_OBJECTS             |      1 |   4100 |00:00:01.83 |     734K|       |       |          |
|*  8 |       FILTER                                   |                         |      1 |  64189 |00:00:01.76 |     734K|       |       |          |
|   9 |        NESTED LOOPS                            |                         |      1 |  65598 |00:00:00.41 |     111K|       |       |          |
|  10 |         NESTED LOOPS                           |                         |      1 |  65598 |00:00:00.15 |   46382 |       |       |          |
|  11 |          TABLE ACCESS FULL                     | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|* 12 |          TABLE ACCESS BY INDEX ROWID           | OBJ$                    |    179 |  65598 |00:00:00.14 |   46367 |       |       |          |
|* 13 |           INDEX RANGE SCAN                     | I_OBJ5                  |    179 |  65601 |00:00:00.03 |    1127 |       |       |          |
|  14 |         TABLE ACCESS CLUSTER                   | USER$                   |  65598 |  65598 |00:00:00.24 |   65602 |       |       |          |
|* 15 |          INDEX UNIQUE SCAN                     | I_USER#                 |  65598 |  65598 |00:00:00.07 |       4 |       |       |          |
|* 16 |        TABLE ACCESS BY INDEX ROWID             | IND$                    |   4510 |   3819 |00:00:00.01 |    5890 |       |       |          |
|* 17 |         INDEX UNIQUE SCAN                      | I_IND1                  |   4510 |   4510 |00:00:00.01 |    1376 |       |       |          |
|  18 |        NESTED LOOPS                            |                         |  11829 |   4490 |00:00:00.53 |     344K|       |       |          |
|  19 |         NESTED LOOPS                           |                         |  11829 |   4843 |00:00:00.52 |     339K|       |       |          |
|  20 |          FIXED TABLE FULL                      | X$KZSRO                 |  11829 |    158K|00:00:00.08 |       0 |       |       |          |
|* 21 |          INDEX RANGE SCAN                      | I_OBJAUTH2              |    158K|   4843 |00:00:00.41 |     339K|       |       |          |
|* 22 |         TABLE ACCESS BY INDEX ROWID            | OBJAUTH$                |   4843 |   4490 |00:00:00.01 |    4496 |       |       |          |
|  23 |        NESTED LOOPS                            |                         |  22587 |  21476 |00:00:00.32 |     130K|       |       |          |
|  24 |         NESTED LOOPS                           |                         |  22587 |  21476 |00:00:00.27 |     109K|       |       |          |
|  25 |          FIXED TABLE FULL                      | X$KZSRO                 |  22587 |  44492 |00:00:00.07 |       0 |       |       |          |
|* 26 |          INDEX RANGE SCAN                      | I_OBJAUTH2              |  44492 |  21476 |00:00:00.19 |     109K|       |       |          |
|* 27 |         TABLE ACCESS BY INDEX ROWID            | OBJAUTH$                |  21476 |  21476 |00:00:00.04 |   21476 |       |       |          |
|* 28 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|  29 |        NESTED LOOPS                            |                         |    224 |      0 |00:00:00.02 |    9852 |       |       |          |
|  30 |         NESTED LOOPS                           |                         |    224 |      0 |00:00:00.02 |    9852 |       |       |          |
|  31 |          NESTED LOOPS                          |                         |    224 |   4460 |00:00:00.01 |     448 |       |       |          |
|  32 |           TABLE ACCESS BY INDEX ROWID          | TABPART$                |    224 |    223 |00:00:00.01 |     448 |       |       |          |
|* 33 |            INDEX UNIQUE SCAN                   | I_TABPART_OBJ$          |    224 |    223 |00:00:00.01 |     224 |       |       |          |
|  34 |           FIXED TABLE FULL                     | X$KZSRO                 |    223 |   4460 |00:00:00.01 |       0 |       |       |          |
|* 35 |          INDEX RANGE SCAN                      | I_OBJAUTH2              |   4460 |      0 |00:00:00.01 |    9404 |       |       |          |
|* 36 |         TABLE ACCESS BY INDEX ROWID            | OBJAUTH$                |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|  37 |        NESTED LOOPS                            |                         |    155 |     18 |00:00:00.01 |    5517 |       |       |          |
|  38 |         NESTED LOOPS                           |                         |    155 |    196 |00:00:00.01 |    5494 |       |       |          |
|  39 |          NESTED LOOPS                          |                         |    155 |   2412 |00:00:00.01 |     310 |       |       |          |
|* 40 |           TABLE ACCESS BY INDEX ROWID          | TRIGGER$                |    155 |    137 |00:00:00.01 |     310 |       |       |          |
|* 41 |            INDEX UNIQUE SCAN                   | I_TRIGGER2              |    155 |    155 |00:00:00.01 |     155 |       |       |          |
|  42 |           FIXED TABLE FULL                     | X$KZSRO                 |    137 |   2412 |00:00:00.01 |       0 |       |       |          |
|* 43 |          INDEX RANGE SCAN                      | I_OBJAUTH2              |   2412 |    196 |00:00:00.01 |    5184 |       |       |          |
|* 44 |         TABLE ACCESS BY INDEX ROWID            | OBJAUTH$                |    196 |     18 |00:00:00.01 |      23 |       |       |          |
|* 45 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|  46 |        NESTED LOOPS                            |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
|  47 |         NESTED LOOPS                           |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
|  48 |          NESTED LOOPS                          |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
|  49 |           NESTED LOOPS                         |                         |    862 |  17240 |00:00:00.10 |   20367 |       |       |          |
|  50 |            NESTED LOOPS                        |                         |    862 |  17240 |00:00:00.05 |    2262 |       |       |          |
|  51 |             FIXED TABLE FULL                   | X$KZSRO                 |    862 |  17240 |00:00:00.01 |       0 |       |       |          |
|* 52 |             INDEX RANGE SCAN                   | I_OBJ5                  |  17240 |  17240 |00:00:00.04 |    2262 |       |       |          |
|  53 |            TABLE ACCESS CLUSTER                | USER$                   |  17240 |  17240 |00:00:00.05 |   18105 |       |       |          |
|* 54 |             INDEX UNIQUE SCAN                  | I_USER#                 |  17240 |  17240 |00:00:00.01 |     865 |       |       |          |
|* 55 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |  17240 |      0 |00:00:00.05 |   36816 |       |       |          |
|* 56 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |  17240 |    396 |00:00:00.05 |   36444 |       |       |          |
|* 57 |          INDEX RANGE SCAN                      | I_DEPENDENCY2           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 58 |         TABLE ACCESS BY INDEX ROWID            | DEPENDENCY$             |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 59 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 60 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 61 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 62 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|  63 |        NESTED LOOPS                            |                         |   2140 |    876 |00:00:00.09 |   56704 |       |       |          |
|  64 |         NESTED LOOPS                           |                         |   2140 |    876 |00:00:00.09 |   55828 |       |       |          |
|  65 |          FIXED TABLE FULL                      | X$KZSRO                 |   2140 |  26161 |00:00:00.01 |       0 |       |       |          |
|* 66 |          INDEX RANGE SCAN                      | I_OBJAUTH2              |  26161 |    876 |00:00:00.07 |   55828 |       |       |          |
|* 67 |         TABLE ACCESS BY INDEX ROWID            | OBJAUTH$                |    876 |    876 |00:00:00.01 |     876 |       |       |          |
|* 68 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|  69 |        NESTED LOOPS                            |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
|  70 |         NESTED LOOPS                           |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
|  71 |          NESTED LOOPS                          |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
|  72 |           NESTED LOOPS                         |                         |    174 |   3480 |00:00:00.02 |    4511 |       |       |          |
|  73 |            NESTED LOOPS                        |                         |    174 |   3480 |00:00:00.01 |     854 |       |       |          |
|  74 |             FIXED TABLE FULL                   | X$KZSRO                 |    174 |   3480 |00:00:00.01 |       0 |       |       |          |
|* 75 |             INDEX RANGE SCAN                   | I_OBJ5                  |   3480 |   3480 |00:00:00.01 |     854 |       |       |          |
|  76 |            TABLE ACCESS CLUSTER                | USER$                   |   3480 |   3480 |00:00:00.01 |    3657 |       |       |          |
|* 77 |             INDEX UNIQUE SCAN                  | I_USER#                 |   3480 |   3480 |00:00:00.01 |     177 |       |       |          |
|* 78 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |   3480 |      0 |00:00:00.01 |    7453 |       |       |          |
|* 79 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |   3480 |     93 |00:00:00.01 |    7360 |       |       |          |
|* 80 |          INDEX RANGE SCAN                      | I_DEPENDENCY2           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 81 |         TABLE ACCESS BY INDEX ROWID            | DEPENDENCY$             |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 82 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 83 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 84 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 85 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 86 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 87 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 88 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 89 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|  90 |        VIEW                                    |                         |     28 |     28 |00:00:00.01 |       0 |       |       |          |
|  91 |         FAST DUAL                              |                         |     28 |     28 |00:00:00.01 |       0 |       |       |          |
|* 92 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 93 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 94 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 95 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 96 |        FIXED TABLE FULL                        | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|* 97 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 98 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|* 99 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*100 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 101 |        NESTED LOOPS                            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 102 |         FIXED TABLE FULL                       | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*103 |         INDEX RANGE SCAN                       | I_OBJAUTH2              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*104 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 105 |        NESTED LOOPS                            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 106 |         FIXED TABLE FULL                       | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*107 |         INDEX RANGE SCAN                       | I_OBJAUTH2              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*108 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 109 |        VIEW                                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 110 |         SORT GROUP BY                          |                         |      0 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 111 |          NESTED LOOPS                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 112 |           NESTED LOOPS                         |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 113 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*114 |             INDEX UNIQUE SCAN                  | I_OLAP_CUBES$           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*115 |             TABLE ACCESS BY INDEX ROWID        | OLAP_DIMENSIONALITY$    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*116 |              INDEX RANGE SCAN                  | I_OLAP_DIMENSIONALITY$  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*117 |            INDEX RANGE SCAN                    | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*118 |           INDEX UNIQUE SCAN                    | I_OLAP_CUBE_DIMENSIONS$ |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*119 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*120 |        FIXED TABLE FULL                        | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 121 |        NESTED LOOPS                            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*122 |         INDEX RANGE SCAN                       | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*123 |         TABLE ACCESS CLUSTER                   | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*124 |          INDEX UNIQUE SCAN                     | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 125 |      MERGE JOIN                                |                         |      1 |   4052 |00:00:01.96 |     833K|       |       |          |
| 126 |       SORT JOIN                                |                         |      1 |  25033 |00:00:00.32 |   99302 |  2391K|   711K| 2125K (0)|
| 127 |        VIEW                                    | ALL_SYNONYMS            |      1 |  25033 |00:00:00.31 |   99302 |       |       |          |
| 128 |         SORT UNIQUE                            |                         |      1 |  25033 |00:00:00.30 |   99302 |  3242K|   789K| 2881K (0)|
| 129 |          UNION-ALL                             |                         |      1 |  25033 |00:00:00.28 |   99302 |       |       |          |
|*130 |           FILTER                               |                         |      1 |  25033 |00:00:00.16 |   73088 |       |       |          |
| 131 |            NESTED LOOPS                        |                         |      1 |  25033 |00:00:00.15 |   73088 |       |       |          |
| 132 |             NESTED LOOPS                       |                         |      1 |  25033 |00:00:00.08 |   48051 |       |       |          |
| 133 |              NESTED LOOPS                      |                         |      1 |  25033 |00:00:00.01 |    1142 |       |       |          |
| 134 |               TABLE ACCESS FULL                | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|*135 |               INDEX RANGE SCAN                 | I_OBJ2                  |    179 |  25033 |00:00:00.01 |    1127 |       |       |          |
| 136 |              TABLE ACCESS BY INDEX ROWID       | SYN$                    |  25033 |  25033 |00:00:00.06 |   46909 |       |       |          |
|*137 |               INDEX UNIQUE SCAN                | I_SYN1                  |  25033 |  25033 |00:00:00.03 |   21876 |       |       |          |
| 138 |             TABLE ACCESS CLUSTER               | USER$                   |  25033 |  25033 |00:00:00.07 |   25037 |       |       |          |
|*139 |              INDEX UNIQUE SCAN                 | I_USER#                 |  25033 |  25033 |00:00:00.01 |       4 |       |       |          |
|*140 |            FIXED TABLE FULL                    | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*141 |            FILTER                              |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*142 |             FILTER                             |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 143 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 144 |               NESTED LOOPS                     |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 145 |                NESTED LOOPS                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 146 |                 TABLE ACCESS BY INDEX ROWID    | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*147 |                  INDEX UNIQUE SCAN             | I_USER1                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*148 |                 INDEX RANGE SCAN               | I_OBJ5                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 149 |                TABLE ACCESS CLUSTER            | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*150 |                 INDEX UNIQUE SCAN              | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*151 |               INDEX RANGE SCAN                 | I_OBJAUTH1              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*152 |             FIXED TABLE FULL                   | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 153 |             NESTED LOOPS                       |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*154 |              INDEX RANGE SCAN                  | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*155 |              TABLE ACCESS CLUSTER              | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*156 |               INDEX UNIQUE SCAN                | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 157 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*158 |             INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*159 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*160 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 161 |           VIEW                                 | _ALL_SYNONYMS_TREE      |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
|*162 |            CONNECT BY WITH FILTERING           |                         |      1 |      0 |00:00:00.11 |   26214 |  1024 |  1024 |          |
|*163 |             FILTER                             |                         |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
| 164 |              NESTED LOOPS                      |                         |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
| 165 |               NESTED LOOPS                     |                         |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
| 166 |                NESTED LOOPS                    |                         |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
| 167 |                 NESTED LOOPS                   |                         |      1 |      0 |00:00:00.11 |   26214 |       |       |          |
| 168 |                  NESTED LOOPS                  |                         |      1 |  25033 |00:00:00.08 |   26179 |       |       |          |
| 169 |                   NESTED LOOPS                 |                         |      1 |  25033 |00:00:00.01 |    1142 |       |       |          |
| 170 |                    TABLE ACCESS FULL           | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|*171 |                    INDEX RANGE SCAN            | I_OBJ5                  |    179 |  25033 |00:00:00.01 |    1127 |       |       |          |
| 172 |                   TABLE ACCESS CLUSTER         | USER$                   |  25033 |  25033 |00:00:00.06 |   25037 |       |       |          |
|*173 |                    INDEX UNIQUE SCAN           | I_USER#                 |  25033 |  25033 |00:00:00.01 |       4 |       |       |          |
| 174 |                  TABLE ACCESS BY INDEX ROWID   | SYN$                    |  25033 |      0 |00:00:00.03 |      35 |       |       |          |
|*175 |                   INDEX RANGE SCAN             | I_SYN2                  |  25033 |      0 |00:00:00.02 |      35 |       |       |          |
| 176 |                 TABLE ACCESS BY INDEX ROWID    | OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*177 |                  INDEX RANGE SCAN              | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 178 |                TABLE ACCESS CLUSTER            | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*179 |                 INDEX UNIQUE SCAN              | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 180 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*181 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*182 |              FILTER                            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 183 |               TABLE ACCESS BY INDEX ROWID      | SYN$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*184 |                INDEX UNIQUE SCAN               | I_SYN1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*185 |               FIXED TABLE FULL                 | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*186 |               FILTER                           |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*187 |                FILTER                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 188 |                 NESTED LOOPS                   |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 189 |                  NESTED LOOPS                  |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 190 |                   NESTED LOOPS                 |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 191 |                    TABLE ACCESS BY INDEX ROWID | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*192 |                     INDEX UNIQUE SCAN          | I_USER1                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*193 |                    INDEX RANGE SCAN            | I_OBJ5                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 194 |                   TABLE ACCESS CLUSTER         | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*195 |                    INDEX UNIQUE SCAN           | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*196 |                  INDEX RANGE SCAN              | I_OBJAUTH1              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*197 |                FIXED TABLE FULL                | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 198 |                NESTED LOOPS                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*199 |                 INDEX RANGE SCAN               | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*200 |                 TABLE ACCESS CLUSTER           | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*201 |                  INDEX UNIQUE SCAN             | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 202 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*203 |               INDEX RANGE SCAN                 | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*204 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*205 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 206 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*207 |               INDEX RANGE SCAN                 | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*208 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*209 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*210 |             FILTER                             |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 211 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 212 |               NESTED LOOPS                     |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 213 |                NESTED LOOPS                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 214 |                 NESTED LOOPS                   |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 215 |                  NESTED LOOPS                  |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 216 |                   NESTED LOOPS                 |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 217 |                    NESTED LOOPS                |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 218 |                     CONNECT BY PUMP            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 219 |                     TABLE ACCESS BY INDEX ROWID| OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*220 |                      INDEX RANGE SCAN          | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 221 |                    TABLE ACCESS CLUSTER        | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*222 |                     INDEX UNIQUE SCAN          | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 223 |                   TABLE ACCESS CLUSTER         | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*224 |                    INDEX UNIQUE SCAN           | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 225 |                  TABLE ACCESS BY INDEX ROWID   | SYN$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*226 |                   INDEX RANGE SCAN             | I_SYN2                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 227 |                 TABLE ACCESS BY INDEX ROWID    | OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*228 |                  INDEX RANGE SCAN              | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 229 |                TABLE ACCESS CLUSTER            | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*230 |                 INDEX UNIQUE SCAN              | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 231 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*232 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 233 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*234 |               INDEX RANGE SCAN                 | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*235 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*236 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 237 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*238 |               INDEX RANGE SCAN                 | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*239 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*240 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*241 |       SORT JOIN                                |                         |  25033 |   4052 |00:00:01.64 |     734K|   407K|   407K|  361K (0)|
|*242 |        VIEW                                    | ALL_OBJECTS             |      1 |   7921 |00:00:01.62 |     734K|       |       |          |
|*243 |         FILTER                                 |                         |      1 |  64189 |00:00:01.59 |     734K|       |       |          |
| 244 |          NESTED LOOPS                          |                         |      1 |  65598 |00:00:00.35 |     111K|       |       |          |
| 245 |           NESTED LOOPS                         |                         |      1 |  65598 |00:00:00.13 |   46382 |       |       |          |
| 246 |            TABLE ACCESS FULL                   | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|*247 |            TABLE ACCESS BY INDEX ROWID         | OBJ$                    |    179 |  65598 |00:00:00.12 |   46367 |       |       |          |
|*248 |             INDEX RANGE SCAN                   | I_OBJ5                  |    179 |  65601 |00:00:00.03 |    1127 |       |       |          |
| 249 |           TABLE ACCESS CLUSTER                 | USER$                   |  65598 |  65598 |00:00:00.21 |   65602 |       |       |          |
|*250 |            INDEX UNIQUE SCAN                   | I_USER#                 |  65598 |  65598 |00:00:00.06 |       4 |       |       |          |
|*251 |          TABLE ACCESS BY INDEX ROWID           | IND$                    |   4510 |   3819 |00:00:00.01 |    5890 |       |       |          |
|*252 |           INDEX UNIQUE SCAN                    | I_IND1                  |   4510 |   4510 |00:00:00.01 |    1376 |       |       |          |
| 253 |          NESTED LOOPS                          |                         |  11829 |   4490 |00:00:00.53 |     344K|       |       |          |
| 254 |           NESTED LOOPS                         |                         |  11829 |   4843 |00:00:00.52 |     339K|       |       |          |
| 255 |            FIXED TABLE FULL                    | X$KZSRO                 |  11829 |    158K|00:00:00.08 |       0 |       |       |          |
|*256 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |    158K|   4843 |00:00:00.41 |     339K|       |       |          |
|*257 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |   4843 |   4490 |00:00:00.01 |    4496 |       |       |          |
| 258 |          NESTED LOOPS                          |                         |  22587 |  21476 |00:00:00.24 |     130K|       |       |          |
| 259 |           NESTED LOOPS                         |                         |  22587 |  21476 |00:00:00.20 |     109K|       |       |          |
| 260 |            FIXED TABLE FULL                    | X$KZSRO                 |  22587 |  44492 |00:00:00.05 |       0 |       |       |          |
|*261 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |  44492 |  21476 |00:00:00.14 |     109K|       |       |          |
|*262 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |  21476 |  21476 |00:00:00.03 |   21476 |       |       |          |
|*263 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
| 264 |          NESTED LOOPS                          |                         |    224 |      0 |00:00:00.02 |    9852 |       |       |          |
| 265 |           NESTED LOOPS                         |                         |    224 |      0 |00:00:00.02 |    9852 |       |       |          |
| 266 |            NESTED LOOPS                        |                         |    224 |   4460 |00:00:00.01 |     448 |       |       |          |
| 267 |             TABLE ACCESS BY INDEX ROWID        | TABPART$                |    224 |    223 |00:00:00.01 |     448 |       |       |          |
|*268 |              INDEX UNIQUE SCAN                 | I_TABPART_OBJ$          |    224 |    223 |00:00:00.01 |     224 |       |       |          |
| 269 |             FIXED TABLE FULL                   | X$KZSRO                 |    223 |   4460 |00:00:00.01 |       0 |       |       |          |
|*270 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |   4460 |      0 |00:00:00.01 |    9404 |       |       |          |
|*271 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 272 |          NESTED LOOPS                          |                         |    155 |     18 |00:00:00.01 |    5517 |       |       |          |
| 273 |           NESTED LOOPS                         |                         |    155 |    196 |00:00:00.01 |    5494 |       |       |          |
| 274 |            NESTED LOOPS                        |                         |    155 |   2412 |00:00:00.01 |     310 |       |       |          |
|*275 |             TABLE ACCESS BY INDEX ROWID        | TRIGGER$                |    155 |    137 |00:00:00.01 |     310 |       |       |          |
|*276 |              INDEX UNIQUE SCAN                 | I_TRIGGER2              |    155 |    155 |00:00:00.01 |     155 |       |       |          |
| 277 |             FIXED TABLE FULL                   | X$KZSRO                 |    137 |   2412 |00:00:00.01 |       0 |       |       |          |
|*278 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |   2412 |    196 |00:00:00.01 |    5184 |       |       |          |
|*279 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |    196 |     18 |00:00:00.01 |      23 |       |       |          |
|*280 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
| 281 |          NESTED LOOPS                          |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
| 282 |           NESTED LOOPS                         |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
| 283 |            NESTED LOOPS                        |                         |    862 |      0 |00:00:00.16 |   57183 |       |       |          |
| 284 |             NESTED LOOPS                       |                         |    862 |  17240 |00:00:00.10 |   20367 |       |       |          |
| 285 |              NESTED LOOPS                      |                         |    862 |  17240 |00:00:00.05 |    2262 |       |       |          |
| 286 |               FIXED TABLE FULL                 | X$KZSRO                 |    862 |  17240 |00:00:00.01 |       0 |       |       |          |
|*287 |               INDEX RANGE SCAN                 | I_OBJ5                  |  17240 |  17240 |00:00:00.04 |    2262 |       |       |          |
| 288 |              TABLE ACCESS CLUSTER              | USER$                   |  17240 |  17240 |00:00:00.05 |   18105 |       |       |          |
|*289 |               INDEX UNIQUE SCAN                | I_USER#                 |  17240 |  17240 |00:00:00.01 |     865 |       |       |          |
|*290 |             TABLE ACCESS BY INDEX ROWID        | OBJAUTH$                |  17240 |      0 |00:00:00.05 |   36816 |       |       |          |
|*291 |              INDEX RANGE SCAN                  | I_OBJAUTH2              |  17240 |    396 |00:00:00.05 |   36444 |       |       |          |
|*292 |            INDEX RANGE SCAN                    | I_DEPENDENCY2           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*293 |           TABLE ACCESS BY INDEX ROWID          | DEPENDENCY$             |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*294 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*295 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*296 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*297 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
| 298 |          NESTED LOOPS                          |                         |   2140 |    876 |00:00:00.09 |   56704 |       |       |          |
| 299 |           NESTED LOOPS                         |                         |   2140 |    876 |00:00:00.09 |   55828 |       |       |          |
| 300 |            FIXED TABLE FULL                    | X$KZSRO                 |   2140 |  26161 |00:00:00.01 |       0 |       |       |          |
|*301 |            INDEX RANGE SCAN                    | I_OBJAUTH2              |  26161 |    876 |00:00:00.07 |   55828 |       |       |          |
|*302 |           TABLE ACCESS BY INDEX ROWID          | OBJAUTH$                |    876 |    876 |00:00:00.01 |     876 |       |       |          |
|*303 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
| 304 |          NESTED LOOPS                          |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
| 305 |           NESTED LOOPS                         |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
| 306 |            NESTED LOOPS                        |                         |    174 |      0 |00:00:00.03 |   11964 |       |       |          |
| 307 |             NESTED LOOPS                       |                         |    174 |   3480 |00:00:00.02 |    4511 |       |       |          |
| 308 |              NESTED LOOPS                      |                         |    174 |   3480 |00:00:00.01 |     854 |       |       |          |
| 309 |               FIXED TABLE FULL                 | X$KZSRO                 |    174 |   3480 |00:00:00.01 |       0 |       |       |          |
|*310 |               INDEX RANGE SCAN                 | I_OBJ5                  |   3480 |   3480 |00:00:00.01 |     854 |       |       |          |
| 311 |              TABLE ACCESS CLUSTER              | USER$                   |   3480 |   3480 |00:00:00.01 |    3657 |       |       |          |
|*312 |               INDEX UNIQUE SCAN                | I_USER#                 |   3480 |   3480 |00:00:00.01 |     177 |       |       |          |
|*313 |             TABLE ACCESS BY INDEX ROWID        | OBJAUTH$                |   3480 |      0 |00:00:00.01 |    7453 |       |       |          |
|*314 |              INDEX RANGE SCAN                  | I_OBJAUTH2              |   3480 |     93 |00:00:00.01 |    7360 |       |       |          |
|*315 |            INDEX RANGE SCAN                    | I_DEPENDENCY2           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*316 |           TABLE ACCESS BY INDEX ROWID          | DEPENDENCY$             |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*317 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*318 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*319 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*320 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*321 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*322 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*323 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*324 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
| 325 |          VIEW                                  |                         |     28 |     28 |00:00:00.01 |       0 |       |       |          |
| 326 |           FAST DUAL                            |                         |     28 |     28 |00:00:00.01 |       0 |       |       |          |
|*327 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*328 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*329 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*330 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*331 |          FIXED TABLE FULL                      | X$KZSPR                 |      1 |      1 |00:00:00.01 |       0 |       |       |          |
|*332 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*333 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*334 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*335 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 336 |          NESTED LOOPS                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 337 |           FIXED TABLE FULL                     | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*338 |           INDEX RANGE SCAN                     | I_OBJAUTH2              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*339 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 340 |          NESTED LOOPS                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 341 |           FIXED TABLE FULL                     | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*342 |           INDEX RANGE SCAN                     | I_OBJAUTH2              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*343 |            FIXED TABLE FULL                    | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 344 |          VIEW                                  |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 345 |           SORT GROUP BY                        |                         |      0 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 346 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 347 |             NESTED LOOPS                       |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 348 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*349 |               INDEX UNIQUE SCAN                | I_OLAP_CUBES$           |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*350 |               TABLE ACCESS BY INDEX ROWID      | OLAP_DIMENSIONALITY$    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*351 |                INDEX RANGE SCAN                | I_OLAP_DIMENSIONALITY$  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*352 |              INDEX RANGE SCAN                  | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*353 |             INDEX UNIQUE SCAN                  | I_OLAP_CUBE_DIMENSIONS$ |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*354 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*355 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 356 |          NESTED LOOPS                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*357 |           INDEX RANGE SCAN                     | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*358 |           TABLE ACCESS CLUSTER                 | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*359 |            INDEX UNIQUE SCAN                   | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 360 |      VIEW                                      | ALL_SYNONYMS            |      1 |      0 |00:00:00.16 |   74265 |       |       |          |
| 361 |       SORT UNIQUE                              |                         |      1 |      0 |00:00:00.16 |   74265 |  1024 |  1024 |          |
| 362 |        UNION-ALL                               |                         |      1 |      0 |00:00:00.16 |   74265 |       |       |          |
|*363 |         FILTER                                 |                         |      1 |      0 |00:00:00.05 |   48051 |       |       |          |
| 364 |          NESTED LOOPS                          |                         |      1 |      0 |00:00:00.05 |   48051 |       |       |          |
| 365 |           NESTED LOOPS                         |                         |      1 |      0 |00:00:00.05 |   48051 |       |       |          |
| 366 |            NESTED LOOPS                        |                         |      1 |  25033 |00:00:00.01 |    1142 |       |       |          |
| 367 |             TABLE ACCESS FULL                  | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|*368 |             INDEX RANGE SCAN                   | I_OBJ2                  |    179 |  25033 |00:00:00.01 |    1127 |       |       |          |
|*369 |            TABLE ACCESS BY INDEX ROWID         | SYN$                    |  25033 |      0 |00:00:00.04 |   46909 |       |       |          |
|*370 |             INDEX UNIQUE SCAN                  | I_SYN1                  |  25033 |  25033 |00:00:00.02 |   21876 |       |       |          |
| 371 |           TABLE ACCESS CLUSTER                 | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*372 |            INDEX UNIQUE SCAN                   | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*373 |          FIXED TABLE FULL                      | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*374 |          FILTER                                |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*375 |           FILTER                               |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 376 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 377 |             NESTED LOOPS                       |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 378 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 379 |               TABLE ACCESS BY INDEX ROWID      | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*380 |                INDEX UNIQUE SCAN               | I_USER1                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*381 |               INDEX RANGE SCAN                 | I_OBJ5                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 382 |              TABLE ACCESS CLUSTER              | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*383 |               INDEX UNIQUE SCAN                | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*384 |             INDEX RANGE SCAN                   | I_OBJAUTH1              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*385 |           FIXED TABLE FULL                     | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 386 |           NESTED LOOPS                         |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*387 |            INDEX RANGE SCAN                    | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*388 |            TABLE ACCESS CLUSTER                | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*389 |             INDEX UNIQUE SCAN                  | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 390 |          NESTED LOOPS                          |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*391 |           INDEX RANGE SCAN                     | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*392 |           TABLE ACCESS CLUSTER                 | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*393 |            INDEX UNIQUE SCAN                   | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*394 |         VIEW                                   | _ALL_SYNONYMS_TREE      |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
|*395 |          CONNECT BY WITH FILTERING             |                         |      1 |      0 |00:00:00.10 |   26214 |  1024 |  1024 |          |
|*396 |           FILTER                               |                         |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
| 397 |            NESTED LOOPS                        |                         |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
| 398 |             NESTED LOOPS                       |                         |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
| 399 |              NESTED LOOPS                      |                         |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
| 400 |               NESTED LOOPS                     |                         |      1 |      0 |00:00:00.10 |   26214 |       |       |          |
| 401 |                NESTED LOOPS                    |                         |      1 |  25033 |00:00:00.07 |   26179 |       |       |          |
| 402 |                 NESTED LOOPS                   |                         |      1 |  25033 |00:00:00.01 |    1142 |       |       |          |
| 403 |                  TABLE ACCESS FULL             | USER$                   |      1 |    179 |00:00:00.01 |      15 |       |       |          |
|*404 |                  INDEX RANGE SCAN              | I_OBJ5                  |    179 |  25033 |00:00:00.01 |    1127 |       |       |          |
| 405 |                 TABLE ACCESS CLUSTER           | USER$                   |  25033 |  25033 |00:00:00.06 |   25037 |       |       |          |
|*406 |                  INDEX UNIQUE SCAN             | I_USER#                 |  25033 |  25033 |00:00:00.01 |       4 |       |       |          |
| 407 |                TABLE ACCESS BY INDEX ROWID     | SYN$                    |  25033 |      0 |00:00:00.03 |      35 |       |       |          |
|*408 |                 INDEX RANGE SCAN               | I_SYN2                  |  25033 |      0 |00:00:00.02 |      35 |       |       |          |
| 409 |               TABLE ACCESS BY INDEX ROWID      | OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*410 |                INDEX RANGE SCAN                | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 411 |              TABLE ACCESS CLUSTER     
19 05 2011
Charles Hooper

It must be that my last comment exceeded the limit for WordPress. Continuing:

|*412 |               INDEX UNIQUE SCAN                | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 413 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*414 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*415 |            FILTER                              |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 416 |             TABLE ACCESS BY INDEX ROWID        | SYN$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*417 |              INDEX UNIQUE SCAN                 | I_SYN1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*418 |             FIXED TABLE FULL                   | X$KZSPR                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*419 |             FILTER                             |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*420 |              FILTER                            |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 421 |               NESTED LOOPS                     |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 422 |                NESTED LOOPS                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 423 |                 NESTED LOOPS                   |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 424 |                  TABLE ACCESS BY INDEX ROWID   | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*425 |                   INDEX UNIQUE SCAN            | I_USER1                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*426 |                  INDEX RANGE SCAN              | I_OBJ5                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 427 |                 TABLE ACCESS CLUSTER           | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*428 |                  INDEX UNIQUE SCAN             | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*429 |                INDEX RANGE SCAN                | I_OBJAUTH1              |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*430 |              FIXED TABLE FULL                  | X$KZSRO                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 431 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*432 |               INDEX RANGE SCAN                 | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*433 |               TABLE ACCESS CLUSTER             | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*434 |                INDEX UNIQUE SCAN               | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 435 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*436 |             INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*437 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*438 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 439 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*440 |             INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*441 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*442 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*443 |           FILTER                               |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 444 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 445 |             NESTED LOOPS                       |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 446 |              NESTED LOOPS                      |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 447 |               NESTED LOOPS                     |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 448 |                NESTED LOOPS                    |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 449 |                 NESTED LOOPS                   |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 450 |                  NESTED LOOPS                  |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 451 |                   CONNECT BY PUMP              |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 452 |                   TABLE ACCESS BY INDEX ROWID  | OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*453 |                    INDEX RANGE SCAN            | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 454 |                  TABLE ACCESS CLUSTER          | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*455 |                   INDEX UNIQUE SCAN            | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 456 |                 TABLE ACCESS CLUSTER           | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*457 |                  INDEX UNIQUE SCAN             | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 458 |                TABLE ACCESS BY INDEX ROWID     | SYN$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*459 |                 INDEX RANGE SCAN               | I_SYN2                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 460 |               TABLE ACCESS BY INDEX ROWID      | OBJ$                    |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*461 |                INDEX RANGE SCAN                | I_OBJ1                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 462 |              TABLE ACCESS CLUSTER              | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*463 |               INDEX UNIQUE SCAN                | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 464 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*465 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 466 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*467 |             INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*468 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*469 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
| 470 |            NESTED LOOPS                        |                         |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*471 |             INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*472 |             TABLE ACCESS CLUSTER               | USER$                   |      0 |      0 |00:00:00.01 |       0 |       |       |          |
|*473 |              INDEX UNIQUE SCAN                 | I_USER#                 |      0 |      0 |00:00:00.01 |       0 |       |       |          |
------------------------------------------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   5 - filter(BITAND("S"."XPFLAGS",8388608)=8388608)
   6 - access("S"."OBJ#"=:B1)
   7 - filter(((DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='TABLE' OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM 
              TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='SYSTEM TABLE' OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM 
              TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='VIEW' OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM 
              TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='SYNONYM') AND ("O1"."OBJECT_TYPE"='TABLE' OR "O1"."OBJECT_TYPE"='VIEW')))
   8 - filter(((("O"."TYPE#"1 AND "O"."TYPE#"10) OR ("O"."TYPE#"=1 AND =1)) AND ("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1 OR 
              ("O"."TYPE#"7 AND "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"28 AND "O"."TYPE#"29 AND "O"."TYPE#"30 AND "O"."TYPE#"56 AND "O"."TYPE#"93 AND  IS NOT NULL) OR (("O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( IS NOT NULL OR  IS NOT NULL)) 
              OR ("O"."TYPE#"=19 AND  IS NOT NULL) OR ("O"."TYPE#"=12 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=11 AND ( IS NOT NULL OR  IS NOT 
              NULL)) OR ("O"."TYPE#"=22 AND  IS NOT NULL) OR (("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR 
              "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND  IS NOT NULL) OR ("O"."TYPE#"=6 AND  IS NOT NULL) OR 
              ("O"."TYPE#"=13 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=14 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=23 AND  IS NOT 
              NULL) OR ("O"."TYPE#"=42 AND  IS NOT NULL) OR ("O"."TYPE#"=32 AND  IS NOT NULL) OR ("O"."TYPE#"=33 AND  IS NOT NULL) OR ("O"."TYPE#"=44 AND  
              IS NOT NULL) OR ("O"."TYPE#"=48 AND  IS NOT NULL) OR ("O"."TYPE#"=46 AND  IS NOT NULL) OR ("O"."TYPE#"=55 AND =1) OR ("O"."TYPE#"=59 AND  IS 
              NOT NULL) OR ("O"."TYPE#"=62 AND  IS NOT NULL) OR (("O"."TYPE#"=66 OR "O"."TYPE#"=100) AND  IS NOT NULL) OR (("O"."TYPE#"=67 OR 
              "O"."TYPE#"=79) AND  IS NOT NULL) OR ("O"."TYPE#"=68 AND  IS NOT NULL) OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR "O"."TYPE#"=74 OR 
              "O"."TYPE#"=101 OR ("O"."TYPE#"=81 AND  IS NOT NULL) OR "O"."TYPE#"=57 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#"=93 AND ( IS NOT NULL OR  IS NOT NULL) AND =1) OR ("O"."TYPE#"=94 AND  IS NOT NULL) 
              OR ("O"."TYPE#"=95 AND  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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR 
              "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND 
              (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
  12 - filter(BITAND("O"."FLAGS",128)=0)
  13 - access("O"."SPARE3"="U"."USER#" AND "O"."LINKNAME" IS NULL)
       filter(("O"."LINKNAME" IS NULL AND "O"."NAME"'_default_auditing_options_' AND "O"."NAME"'_NEXT_OBJECT'))
  15 - access("O"."OWNER#"="U"."USER#")
  16 - 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))
  17 - access("I"."OBJ#"=:B1)
  21 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
  22 - filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=12 OR "PRIVILEGE#"=11 
              OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18))
  26 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"=:B1)
  27 - filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
  28 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241))))
  33 - access("OBJ#"=:B1)
  35 - access("GRANTEE#"="KZSROROL" AND "BO#"="OBJ#")
  36 - filter("PRIVILEGE#"=9)
  40 - filter(BITAND("T"."PROPERTY",24)=0)
  41 - access("T"."OBJ#"=:B1)
  43 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="T"."BASEOBJECT")
  44 - filter("OA"."PRIVILEGE#"=26)
  45 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241))))
  52 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
       filter(("O"."TYPE#"=9 AND "O"."TYPE#"88))
  54 - access("O"."OWNER#"="U"."USER#")
  55 - filter("OA"."PRIVILEGE#"=26)
  56 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="O"."OBJ#")
  57 - access("DEP"."P_OBJ#"="O"."OBJ#")
  58 - filter("DEP"."D_OBJ#"=:B1)
  59 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241))))
  60 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR 
              (-"KZSPRPRV")=(-192))))
  61 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
  62 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=(-109)))
  66 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"=:B1)
  67 - filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
  68 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241))))
  75 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
       filter(("O"."TYPE#"=13 AND "O"."TYPE#"88))
  77 - access("O"."OWNER#"="U"."USER#")
  78 - filter("OA"."PRIVILEGE#"=26)
  79 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="O"."OBJ#")
  80 - access("DEP"."P_OBJ#"="O"."OBJ#")
  81 - filter("DEP"."D_OBJ#"=:B1)
  82 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241))))
  83 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178))))
  84 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
  85 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR 
              (-"KZSPRPRV")=(-208))))
  86 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR 
              (-"KZSPRPRV")=(-203) OR (-"KZSPRPRV")=(-204))))
  87 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223))))
  88 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=12))
  89 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR 
              (-"KZSPRPRV")=(-254))))
  92 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR 
              (-"KZSPRPRV")=(-261))))
  93 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR 
              (-"KZSPRPRV")=(-249))))
  94 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=(-265)))
  95 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266))))
  96 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267))))
  97 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278))))
  98 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294))))
  99 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR 
              (-"KZSPRPRV")=(-285))))
 100 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR 
              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))
 103 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 104 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR 
              (-"KZSPRPRV")=(-312) OR (-"KZSPRPRV")=(-313))))
 107 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 108 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR 
              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))
 114 - access("C"."OBJ#"=:B1)
 115 - filter("DIML"."DIMENSION_TYPE"=11)
 116 - access("DIML"."DIMENSIONED_OBJECT_ID"="C"."OBJ#" AND "DIML"."DIMENSIONED_OBJECT_TYPE"=1)
 117 - access("DIML"."DIMENSION_ID"="DO"."OBJ#")
 118 - access("DO"."OBJ#"="DIM"."OBJ#")
 119 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR 
              (-"KZSPRPRV")=(-318))))
 120 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322))))
 122 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 123 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 124 - access("O2"."OWNER#"="U2"."USER#")
 130 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR 
              "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 135 - access("O"."OWNER#"="U"."USER#" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 137 - access("O"."OBJ#"="S"."OBJ#")
 139 - access("O"."SPARE3"="U"."USER#")
 140 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 141 - filter((( IS NOT NULL OR "BA"."GRANTOR#"=USERENV('SCHEMAID')) AND (("O"."TYPE#"4 AND "O"."TYPE#"5 AND "O"."TYPE#"7 AND 
              "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"10 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"22 AND "O"."TYPE#"87 AND "O"."TYPE#"88) OR BITAND("U"."SPARE1",16)=0 OR (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR 
              "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 142 - filter(:B1 IS NULL)
 147 - access("BU"."NAME"=:B1)
 148 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 150 - access("O"."OWNER#"="U"."USER#")
 151 - access("BA"."OBJ#"="O"."OBJ#")
 152 - filter("KZSROROL"=:B1)
 154 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 155 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 156 - access("O2"."OWNER#"="U2"."USER#")
 158 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 159 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 160 - access("O2"."OWNER#"="U2"."USER#")
 162 - access("S"."BASE_SYN_ID"=PRIOR NULL)
 163 - 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR 
              "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND 
              (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 
              OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 
              OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 171 - access("BU"."USER#"="O"."SPARE3" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 173 - access("O"."OWNER#"="U"."USER#")
 175 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 177 - access("S"."OBJ#"="O"."OBJ#")
 179 - access("O"."SPARE3"="U"."USER#")
 181 - access("O"."OWNER#"="U"."USER#")
 182 - filter((("S"."NODE" IS NULL AND  IS NOT NULL) OR  IS NOT NULL))
 184 - access("S"."OBJ#"=:B1)
 185 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 186 - filter((( IS NOT NULL OR "BA"."GRANTOR#"=USERENV('SCHEMAID')) AND (("O"."TYPE#"4 AND "O"."TYPE#"5 AND "O"."TYPE#"7 AND 
              "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"10 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"22 AND "O"."TYPE#"87 AND "O"."TYPE#"88) OR BITAND("U"."SPARE1",16)=0 OR (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR 
              "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 187 - filter(:B1 IS NULL)
 192 - access("BU"."NAME"=:B1)
 193 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 195 - access("O"."OWNER#"="U"."USER#")
 196 - access("BA"."OBJ#"="O"."OBJ#")
 197 - filter("KZSROROL"=:B1)
 199 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 200 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 201 - access("O2"."OWNER#"="U2"."USER#")
 203 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 204 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 205 - access("O2"."OWNER#"="U2"."USER#")
 207 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 208 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 209 - access("O2"."OWNER#"="U2"."USER#")
 210 - 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR 
              "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 
              OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 
              OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 220 - access("connect$_by$_pump$_157"."prior s.syn_id "="O"."OBJ#" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 222 - access("BU"."USER#"="O"."SPARE3")
 224 - access("O"."OWNER#"="U"."USER#")
 226 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 228 - access("S"."OBJ#"="O"."OBJ#")
 230 - access("O"."SPARE3"="U"."USER#")
 232 - access("O"."OWNER#"="U"."USER#")
 234 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 235 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 236 - access("O2"."OWNER#"="U2"."USER#")
 238 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 239 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 240 - access("O2"."OWNER#"="U2"."USER#")
 241 - access("S"."TABLE_OWNER"="O3"."OWNER" AND "S"."TABLE_NAME"="O3"."OBJECT_NAME")
       filter(("S"."TABLE_NAME"="O3"."OBJECT_NAME" AND "S"."TABLE_OWNER"="O3"."OWNER"))
 242 - filter(("O3"."OBJECT_TYPE"='TABLE' OR "O3"."OBJECT_TYPE"='VIEW'))
 243 - filter(((("O"."TYPE#"1 AND "O"."TYPE#"10) OR ("O"."TYPE#"=1 AND =1)) AND ("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1 OR 
              ("O"."TYPE#"7 AND "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"28 AND "O"."TYPE#"29 AND "O"."TYPE#"30 AND "O"."TYPE#"56 AND "O"."TYPE#"93 AND  IS NOT NULL) OR (("O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=28 OR "O"."TYPE#"=29 OR "O"."TYPE#"=30 OR "O"."TYPE#"=56) AND ( IS NOT NULL OR  IS NOT NULL)) 
              OR ("O"."TYPE#"=19 AND  IS NOT NULL) OR ("O"."TYPE#"=12 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=11 AND ( IS NOT NULL OR  IS NOT 
              NULL)) OR ("O"."TYPE#"=22 AND  IS NOT NULL) OR (("O"."TYPE#"=1 OR "O"."TYPE#"=2 OR "O"."TYPE#"=3 OR "O"."TYPE#"=4 OR "O"."TYPE#"=5 OR 
              "O"."TYPE#"=19 OR "O"."TYPE#"=20 OR "O"."TYPE#"=34 OR "O"."TYPE#"=35) AND  IS NOT NULL) OR ("O"."TYPE#"=6 AND  IS NOT NULL) OR 
              ("O"."TYPE#"=13 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=14 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=23 AND  IS NOT 
              NULL) OR ("O"."TYPE#"=42 AND  IS NOT NULL) OR ("O"."TYPE#"=32 AND  IS NOT NULL) OR ("O"."TYPE#"=33 AND  IS NOT NULL) OR ("O"."TYPE#"=44 AND  
              IS NOT NULL) OR ("O"."TYPE#"=48 AND  IS NOT NULL) OR ("O"."TYPE#"=46 AND  IS NOT NULL) OR ("O"."TYPE#"=55 AND =1) OR ("O"."TYPE#"=59 AND  IS 
              NOT NULL) OR ("O"."TYPE#"=62 AND  IS NOT NULL) OR (("O"."TYPE#"=66 OR "O"."TYPE#"=100) AND  IS NOT NULL) OR (("O"."TYPE#"=67 OR 
              "O"."TYPE#"=79) AND  IS NOT NULL) OR ("O"."TYPE#"=68 AND  IS NOT NULL) OR "O"."TYPE#"=69 OR "O"."TYPE#"=72 OR "O"."TYPE#"=74 OR 
              "O"."TYPE#"=101 OR ("O"."TYPE#"=81 AND  IS NOT NULL) OR "O"."TYPE#"=57 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#"=93 AND ( IS NOT NULL OR  IS NOT NULL) AND =1) OR ("O"."TYPE#"=94 AND  IS NOT NULL) 
              OR ("O"."TYPE#"=95 AND  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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR 
              "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND 
              (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 247 - filter(BITAND("O"."FLAGS",128)=0)
 248 - access("O"."SPARE3"="U"."USER#" AND "O"."LINKNAME" IS NULL)
       filter(("O"."LINKNAME" IS NULL AND "O"."NAME"'_default_auditing_options_' AND "O"."NAME"'_NEXT_OBJECT'))
 250 - access("O"."OWNER#"="U"."USER#")
 251 - 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))
 252 - access("I"."OBJ#"=:B1)
 256 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 257 - filter(("PRIVILEGE#"=3 OR "PRIVILEGE#"=6 OR "PRIVILEGE#"=7 OR "PRIVILEGE#"=9 OR "PRIVILEGE#"=10 OR "PRIVILEGE#"=12 OR "PRIVILEGE#"=11 
              OR "PRIVILEGE#"=16 OR "PRIVILEGE#"=17 OR "PRIVILEGE#"=18))
 261 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"=:B1)
 262 - filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
 263 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241))))
 268 - access("OBJ#"=:B1)
 270 - access("GRANTEE#"="KZSROROL" AND "BO#"="OBJ#")
 271 - filter("PRIVILEGE#"=9)
 275 - filter(BITAND("T"."PROPERTY",24)=0)
 276 - access("T"."OBJ#"=:B1)
 278 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="T"."BASEOBJECT")
 279 - filter("OA"."PRIVILEGE#"=26)
 280 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241))))
 287 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
       filter(("O"."TYPE#"=9 AND "O"."TYPE#"88))
 289 - access("O"."OWNER#"="U"."USER#")
 290 - filter("OA"."PRIVILEGE#"=26)
 291 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="O"."OBJ#")
 292 - access("DEP"."P_OBJ#"="O"."OBJ#")
 293 - filter("DEP"."D_OBJ#"=:B1)
 294 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241))))
 295 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR 
              (-"KZSPRPRV")=(-192))))
 296 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 297 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=(-109)))
 301 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"=:B1)
 302 - filter(("OA"."PRIVILEGE#"=12 OR "OA"."PRIVILEGE#"=26))
 303 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241))))
 310 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
       filter(("O"."TYPE#"=13 AND "O"."TYPE#"88))
 312 - access("O"."OWNER#"="U"."USER#")
 313 - filter("OA"."PRIVILEGE#"=26)
 314 - access("OA"."GRANTEE#"="KZSROROL" AND "OA"."OBJ#"="O"."OBJ#")
 315 - access("DEP"."P_OBJ#"="O"."OBJ#")
 316 - filter("DEP"."D_OBJ#"=:B1)
 317 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241))))
 318 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178))))
 319 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 320 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR 
              (-"KZSPRPRV")=(-208))))
 321 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR 
              (-"KZSPRPRV")=(-203) OR (-"KZSPRPRV")=(-204))))
 322 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223))))
 323 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=12))
 324 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR 
              (-"KZSPRPRV")=(-254))))
 327 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR 
              (-"KZSPRPRV")=(-261))))
 328 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR 
              (-"KZSPRPRV")=(-249))))
 329 - filter(("INST_ID"=USERENV('INSTANCE') AND (-"KZSPRPRV")=(-265)))
 330 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266))))
 331 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267))))
 332 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278))))
 333 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294))))
 334 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR 
              (-"KZSPRPRV")=(-285))))
 335 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR 
              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))
 338 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 339 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR 
              (-"KZSPRPRV")=(-312) OR (-"KZSPRPRV")=(-313))))
 342 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 343 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR 
              (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR (-"KZSPRPRV")=(-307))))
 349 - access("C"."OBJ#"=:B1)
 350 - filter("DIML"."DIMENSION_TYPE"=11)
 351 - access("DIML"."DIMENSIONED_OBJECT_ID"="C"."OBJ#" AND "DIML"."DIMENSIONED_OBJECT_TYPE"=1)
 352 - access("DIML"."DIMENSION_ID"="DO"."OBJ#")
 353 - access("DO"."OBJ#"="DIM"."OBJ#")
 354 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR 
              (-"KZSPRPRV")=(-318))))
 355 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322))))
 357 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 358 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 359 - access("O2"."OWNER#"="U2"."USER#")
 363 - filter((("O"."SPARE3"=USERENV('SCHEMAID') OR "O"."SPARE3"=1 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR 
              "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 368 - access("O"."OWNER#"="U"."USER#" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 369 - filter("S"."NODE" IS NOT NULL)
 370 - access("O"."OBJ#"="S"."OBJ#")
 372 - access("O"."SPARE3"="U"."USER#")
 373 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 374 - filter((( IS NOT NULL OR "BA"."GRANTOR#"=USERENV('SCHEMAID')) AND (("O"."TYPE#"4 AND "O"."TYPE#"5 AND "O"."TYPE#"7 AND 
              "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"10 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"22 AND "O"."TYPE#"87 AND "O"."TYPE#"88) OR BITAND("U"."SPARE1",16)=0 OR (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR 
              "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 375 - filter(:B1 IS NULL)
 380 - access("BU"."NAME"=:B1)
 381 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 383 - access("O"."OWNER#"="U"."USER#")
 384 - access("BA"."OBJ#"="O"."OBJ#")
 385 - filter("KZSROROL"=:B1)
 387 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 388 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 389 - access("O2"."OWNER#"="U2"."USER#")
 391 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 392 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 393 - access("O2"."OWNER#"="U2"."USER#")
 394 - filter("ST"."SYN_NODE" IS NOT NULL)
 395 - access("S"."BASE_SYN_ID"=PRIOR NULL)
 396 - 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR 
              "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND 
              (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 
              OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 
              OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 404 - access("BU"."USER#"="O"."SPARE3" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 406 - access("O"."OWNER#"="U"."USER#")
 408 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 410 - access("S"."OBJ#"="O"."OBJ#")
 412 - access("O"."SPARE3"="U"."USER#")
 414 - access("O"."OWNER#"="U"."USER#")
 415 - filter((("S"."NODE" IS NULL AND  IS NOT NULL) OR  IS NOT NULL))
 417 - access("S"."OBJ#"=:B1)
 418 - filter(("INST_ID"=USERENV('INSTANCE') AND ((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR 
              (-"KZSPRPRV")=(-50))))
 419 - filter((( IS NOT NULL OR "BA"."GRANTOR#"=USERENV('SCHEMAID')) AND (("O"."TYPE#"4 AND "O"."TYPE#"5 AND "O"."TYPE#"7 AND 
              "O"."TYPE#"8 AND "O"."TYPE#"9 AND "O"."TYPE#"10 AND "O"."TYPE#"11 AND "O"."TYPE#"12 AND "O"."TYPE#"13 AND "O"."TYPE#"14 AND 
              "O"."TYPE#"22 AND "O"."TYPE#"87 AND "O"."TYPE#"88) OR BITAND("U"."SPARE1",16)=0 OR (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR 
              "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR 
              "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 420 - filter(:B1 IS NULL)
 425 - access("BU"."NAME"=:B1)
 426 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 428 - access("O"."OWNER#"="U"."USER#")
 429 - access("BA"."OBJ#"="O"."OBJ#")
 430 - filter("KZSROROL"=:B1)
 432 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 433 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 434 - access("O2"."OWNER#"="U2"."USER#")
 436 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 437 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 438 - access("O2"."OWNER#"="U2"."USER#")
 440 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 441 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 442 - access("O2"."OWNER#"="U2"."USER#")
 443 - 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR 
              "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("O"."TYPE#"=4 OR "O"."TYPE#"=5 
              OR "O"."TYPE#"=7 OR "O"."TYPE#"=8 OR "O"."TYPE#"=9 OR "O"."TYPE#"=10 OR "O"."TYPE#"=11 OR "O"."TYPE#"=12 OR "O"."TYPE#"=13 OR "O"."TYPE#"=14 
              OR "O"."TYPE#"=22 OR "O"."TYPE#"=87) AND (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 453 - access("connect$_by$_pump$_382"."prior s.syn_id "="O"."OBJ#" AND "O"."TYPE#"=5)
       filter("O"."TYPE#"=5)
 455 - access("BU"."USER#"="O"."SPARE3")
 457 - access("O"."OWNER#"="U"."USER#")
 459 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 461 - access("S"."OBJ#"="O"."OBJ#")
 463 - access("O"."SPARE3"="U"."USER#")
 465 - access("O"."OWNER#"="U"."USER#")
 467 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 468 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 469 - access("O2"."OWNER#"="U2"."USER#")
 471 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88)
 472 - filter(("U2"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id')) AND "U2"."TYPE#"=2))
 473 - access("O2"."OWNER#"="U2"."USER#")

Removing the RULE hints sped up the query significantly:

SQL_ID  46770m5m6hsjp, child number 1
-------------------------------------
select /*+ NORULE */ * from (select /*+ NORULE */ null table_qualifier, 
o1.owner table_owner, o1.object_name table_name, decode(o1.owner,'SYS', 
decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', 
o1.object_type), 'SYSTEM', decode(o1.object_type,'TABLE','SYSTEM 
TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), o1.object_type) 
table_type, null remarks from all_objects o1 where o1.object_type in 
('TABLE', 'VIEW') union select /*+ NORULE */ null table_qualifier, 
s.owner table_owner, s.synonym_name table_name, 'SYNONYM' table_type, 
null remarks from all_objects o3, all_synonyms s where o3.object_type 
in ('TABLE','VIEW') and s.table_owner= o3.owner and s.table_name = 
o3.object_name union select /*+ NORULE */ null table_qualifier, 
s1.owner table_owner, s1.synonym_name table_name, 'SYNONYM' table_type, 
null remarks from all_synonyms s1 where s1.db_link is not null ) tables 
WHERE 1=1 AND ( table_type = 'TABLE' OR table_type = 'SYSTEM TABLE' OR 
table_type = 'VIEW' OR table_type = 'S
 
Plan hash value: 1645327938
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                        | Name                    | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                                 |                         |      1 |        |   8152 |00:00:01.06 |   88608 |       |       |          |
|   1 |  SORT ORDER BY                                   |                         |      1 |  30549 |   8152 |00:00:01.06 |   88608 |   619K|   472K|  550K (0)|
|   2 |   VIEW                                           |                         |      1 |  30549 |   8152 |00:00:01.05 |   88608 |       |       |          |
|   3 |    SORT UNIQUE                                   |                         |      1 |  30549 |   8152 |00:00:01.05 |   88608 |   761K|   499K|  676K (0)|
|   4 |     UNION-ALL                                    |                         |      1 |        |   8152 |00:00:01.04 |   88608 |       |       |          |
|*  5 |      TABLE ACCESS BY INDEX ROWID                 | SUM$                    |      1 |      1 |      0 |00:00:00.01 |       2 |       |       |          |
|*  6 |       INDEX UNIQUE SCAN                          | I_SUM$_1                |      1 |      1 |      1 |00:00:00.01 |       1 |       |       |          |
|*  7 |      VIEW                                        | ALL_OBJECTS             |      1 |  30352 |   4100 |00:00:00.44 |   42961 |       |       |          |
...

A Windows 7 box with the 11.2.0.1 client submitted the following SQL statement:
————————————————
select * from (select null table_qualifier, o1.owner table_owner, o1.object_name table_name, decode(o1.owner,’SYS’, decode(o1.object_type,’TABLE’,’SYSTEM TABLE’,’VIEW’, ‘SYSTEM VIEW’, o1.object_type), ‘SYSTEM’, decode(o1.object_type,’TABLE’,’SYSTEM TABLE’,’VIEW’, ‘SYSTEM VIEW’, o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in (‘TABLE’, ‘VIEW’) union select null table_qualifier, s.owner table_owner, s.synonym_name table_name, ‘SYNONYM’ table_type, null remarks from all_objects o3, all_synonyms s where o3.object_type in (‘TABLE’,’VIEW’) and s.table_owner= o3.owner and s.table_name = o3.object_name union select null table_qualifier, s1.owner table_owner, s1.synonym_name table_name, ‘SYNONYM’ table_type, null remarks from all_synonyms s1 where s1.db_link is not null ) tables WHERE 1=1 AND ( table_type = ‘TABLE’ OR table_type = ‘SYSTEM TABLE’ OR table_type = ‘VIEW’ OR table_type = ‘SYNONYM’ ) ORDER BY 4,2,3
————————————————

The execution plan for the above SQL statement was slightly different:

Plan hash value: 1645327938
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                        | Name                    | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                                 |                         |      1 |        |   8152 |00:00:01.05 |   88608 |       |       |          |
|   1 |  SORT ORDER BY                                   |                         |      1 |  30549 |   8152 |00:00:01.05 |   88608 |   619K|   472K|  550K (0)|
|   2 |   VIEW                                           |                         |      1 |  30549 |   8152 |00:00:01.05 |   88608 |       |       |          |
|   3 |    SORT UNIQUE                                   |                         |      1 |  30549 |   8152 |00:00:01.05 |   88608 |   761K|   499K|  676K (0)|
|   4 |     UNION-ALL                                    |                         |      1 |        |   8152 |00:00:01.04 |   88608 |       |       |          |
|*  5 |      TABLE ACCESS BY INDEX ROWID                 | SUM$                    |      1 |      1 |      0 |00:00:00.01 |       2 |       |       |          |
|*  6 |       INDEX UNIQUE SCAN                          | I_SUM$_1                |      1 |      1 |      1 |00:00:00.01 |       1 |       |       |          |
|*  7 |      VIEW                                        | ALL_OBJECTS             |      1 |  30352 |   4100 |00:00:00.44 |   42961 |       |       |          |
|*  8 |       FILTER                                     |                         |      1 |        |  64189 |00:00:00.41 |   42959 |       |       |          |
|*  9 |        HASH JOIN                                 |                         |      1 |  65462 |  65598 |00:00:00.07 |     826 |  1114K|  1114K| 1231K (0)|
|  10 |         TABLE ACCESS FULL                        | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|* 11 |         HASH JOIN                                |                         |      1 |  65462 |  65598 |00:00:00.05 |     812 |  1156K|  1156K| 1268K (0)|
|  12 |          INDEX FULL SCAN                         | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|* 13 |          TABLE ACCESS FULL                       | OBJ$                    |      1 |  65462 |  65598 |00:00:00.03 |     811 |       |       |          |
|* 14 |        TABLE ACCESS BY INDEX ROWID               | IND$                    |   4510 |      1 |   3819 |00:00:00.01 |    1261 |       |       |          |
|* 15 |         INDEX UNIQUE SCAN                        | I_IND1                  |   4510 |      1 |   4510 |00:00:00.01 |     304 |       |       |          |
|  16 |        NESTED LOOPS                              |                         |  22587 |      2 |  21476 |00:00:00.11 |   25823 |       |       |          |
|  17 |         FIXED TABLE FULL                         | X$KZSRO                 |  22587 |      2 |  44492 |00:00:00.04 |       0 |       |       |          |
|* 18 |         INDEX RANGE SCAN                         | I_OBJAUTH1              |  44492 |      1 |  21476 |00:00:00.06 |   25823 |       |       |          |
|* 19 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     10 |      1 |00:00:00.01 |       0 |       |       |          |
|* 20 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     17 |      1 |00:00:00.01 |       0 |       |       |          |
|  21 |        NESTED LOOPS                              |                         |   1236 |      2 |     86 |00:00:00.03 |    3880 |       |       |          |
|  22 |         FIXED TABLE FULL                         | X$KZSRO                 |   1236 |      2 |  23097 |00:00:00.01 |       0 |       |       |          |
|* 23 |         INDEX RANGE SCAN                         | I_OBJAUTH1              |  23097 |      1 |     86 |00:00:00.02 |    3880 |       |       |          |
|  24 |        NESTED LOOPS                              |                         |   2140 |      2 |    876 |00:00:00.03 |    2431 |       |       |          |
|  25 |         FIXED TABLE FULL                         | X$KZSRO                 |   2140 |      2 |  26161 |00:00:00.01 |       0 |       |       |          |
|* 26 |         INDEX RANGE SCAN                         | I_OBJAUTH1              |  26161 |      1 |    876 |00:00:00.02 |    2431 |       |       |          |
|* 27 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     10 |      1 |00:00:00.01 |       0 |       |       |          |
|  28 |        NESTED LOOPS                              |                         |    862 |        |      0 |00:00:00.05 |    6588 |       |       |          |
|  29 |         NESTED LOOPS                             |                         |    862 |      1 |      0 |00:00:00.05 |    6588 |       |       |          |
|  30 |          NESTED LOOPS                            |                         |    862 |      1 |      0 |00:00:00.05 |    6588 |       |       |          |
|  31 |           NESTED LOOPS                           |                         |    862 |      1 |  17240 |00:00:00.03 |    3293 |       |       |          |
|  32 |            MERGE JOIN CARTESIAN                  |                         |    862 |      1 |  17240 |00:00:00.02 |    2429 |       |       |          |
|* 33 |             INDEX RANGE SCAN                     | I_OBJ5                  |    862 |      1 |    862 |00:00:00.01 |    2429 |       |       |          |
|  34 |             BUFFER SORT                          |                         |    862 |      2 |  17240 |00:00:00.01 |       0 |  2048 |  2048 | 2048  (0)|
|  35 |              FIXED TABLE FULL                    | X$KZSRO                 |    862 |      2 |  17240 |00:00:00.01 |       0 |       |       |          |
|* 36 |            INDEX RANGE SCAN                      | I_USER2                 |  17240 |      1 |  17240 |00:00:00.01 |     864 |       |       |          |
|* 37 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |  17240 |      1 |      0 |00:00:00.01 |    3295 |       |       |          |
|* 38 |          INDEX RANGE SCAN                        | I_DEPENDENCY1           |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|* 39 |         TABLE ACCESS BY INDEX ROWID              | DEPENDENCY$             |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 40 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 41 |        HASH JOIN                                 |                         |    155 |      1 |     18 |00:00:00.01 |     521 |   921K|   921K|  540K (0)|
|  42 |         NESTED LOOPS                             |                         |    155 |      2 |     27 |00:00:00.01 |     521 |       |       |          |
|* 43 |          TABLE ACCESS BY INDEX ROWID             | TRIGGER$                |    155 |      1 |    137 |00:00:00.01 |     310 |       |       |          |
|* 44 |           INDEX UNIQUE SCAN                      | I_TRIGGER2              |    155 |      1 |    155 |00:00:00.01 |     155 |       |       |          |
|* 45 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |    137 |      2 |     27 |00:00:00.01 |     211 |       |       |          |
|  46 |         FIXED TABLE FULL                         | X$KZSRO                 |     18 |      2 |     32 |00:00:00.01 |       0 |       |       |          |
|* 47 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|  48 |        NESTED LOOPS                              |                         |    174 |        |      0 |00:00:00.01 |    1181 |       |       |          |
|  49 |         NESTED LOOPS                             |                         |    174 |      1 |      0 |00:00:00.01 |    1181 |       |       |          |
|  50 |          NESTED LOOPS                            |                         |    174 |      1 |      0 |00:00:00.01 |    1181 |       |       |          |
|  51 |           NESTED LOOPS                           |                         |    174 |      1 |   3480 |00:00:00.01 |     671 |       |       |          |
|  52 |            MERGE JOIN CARTESIAN                  |                         |    174 |      1 |   3480 |00:00:00.01 |     495 |       |       |          |
|* 53 |             INDEX RANGE SCAN                     | I_OBJ5                  |    174 |      1 |    174 |00:00:00.01 |     495 |       |       |          |
|  54 |             BUFFER SORT                          |                         |    174 |      2 |   3480 |00:00:00.01 |       0 |  2048 |  2048 | 2048  (0)|
|  55 |              FIXED TABLE FULL                    | X$KZSRO                 |    174 |      2 |   3480 |00:00:00.01 |       0 |       |       |          |
|* 56 |            INDEX RANGE SCAN                      | I_USER2                 |   3480 |      1 |   3480 |00:00:00.01 |     176 |       |       |          |
|* 57 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |   3480 |      1 |      0 |00:00:00.01 |     510 |       |       |          |
|* 58 |          INDEX RANGE SCAN                        | I_DEPENDENCY1           |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|* 59 |         TABLE ACCESS BY INDEX ROWID              | DEPENDENCY$             |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 60 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 61 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      4 |      1 |00:00:00.01 |       0 |       |       |          |
|* 62 |        HASH JOIN                                 |                         |      0 |      1 |      0 |00:00:00.01 |       0 |   955K|   955K|          |
|  63 |         NESTED LOOPS                             |                         |      0 |      3 |      0 |00:00:00.01 |       0 |       |       |          |
|  64 |          TABLE ACCESS BY INDEX ROWID             | TABPART$                |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 65 |           INDEX UNIQUE SCAN                      | I_TABPART_OBJ$          |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 66 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |      0 |      3 |      0 |00:00:00.01 |       0 |       |       |          |
|  67 |         FIXED TABLE FULL                         | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|* 68 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|* 69 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      4 |      0 |00:00:00.01 |       0 |       |       |          |
|* 70 |        FIXED TABLE FULL                          | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
|* 71 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|* 72 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 73 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      4 |      1 |00:00:00.01 |       0 |       |       |          |
|* 74 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 75 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 76 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|* 77 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     17 |      1 |00:00:00.01 |       0 |       |       |          |
|* 78 |        FIXED TABLE FULL                          | X$KZSPR                 |      0 |     14 |      0 |00:00:00.01 |       0 |       |       |          |
|* 79 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|* 80 |        FIXED TABLE FULL                          | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|* 81 |        FIXED TABLE FULL                          | X$KZ
19 05 2011
Charles Hooper

Continuing:

|  87 |        VIEW                                      |                         |     28 |      1 |     28 |00:00:00.01 |       0 |       |       |          |
|  88 |         FAST DUAL                                |                         |     28 |      1 |     28 |00:00:00.01 |       0 |       |       |          |
|  89 |        NESTED LOOPS                              |                         |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|  90 |         FIXED TABLE FULL                         | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|* 91 |         INDEX RANGE SCAN                         | I_OBJAUTH2              |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 92 |        FIXED TABLE FULL                          | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
|  93 |        NESTED LOOPS                              |                         |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|  94 |         FIXED TABLE FULL                         | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|* 95 |         INDEX RANGE SCAN                         | I_OBJAUTH2              |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|* 96 |          FIXED TABLE FULL                        | X$KZSPR                 |      0 |     20 |      0 |00:00:00.01 |       0 |       |       |          |
|  97 |        VIEW                                      |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|  98 |         SORT GROUP BY                            |                         |      0 |      1 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
|  99 |          NESTED LOOPS                            |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 100 |           MERGE JOIN CARTESIAN                   |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 101 |            NESTED LOOPS                          |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*102 |             INDEX UNIQUE SCAN                    | I_OLAP_CUBES$           |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*103 |             TABLE ACCESS BY INDEX ROWID          | OLAP_DIMENSIONALITY$    |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*104 |              INDEX RANGE SCAN                    | I_OLAP_DIMENSIONALITY$  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 105 |            BUFFER SORT                           |                         |      0 |      1 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 106 |             INDEX FULL SCAN                      | I_OLAP_CUBE_DIMENSIONS$ |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*107 |           INDEX RANGE SCAN                       | I_OBJ1                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 108 |        NESTED LOOPS                              |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*109 |         INDEX SKIP SCAN                          | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*110 |         INDEX RANGE SCAN                         | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*111 |      HASH JOIN                                   |                         |      1 |     54 |   4052 |00:00:00.57 |   44650 |  2835K|  1081K| 3277K (0)|
| 112 |       VIEW                                       | ALL_SYNONYMS            |      1 |  12504 |  25033 |00:00:00.10 |    1689 |       |       |          |
| 113 |        SORT UNIQUE                               |                         |      1 |  12504 |  25033 |00:00:00.10 |    1689 |  3171K|   785K| 2818K (0)|
| 114 |         UNION-ALL                                |                         |      1 |        |  25033 |00:00:00.08 |    1689 |       |       |          |
|*115 |          FILTER                                  |                         |      1 |        |  25033 |00:00:00.04 |     837 |       |       |          |
|*116 |           HASH JOIN                              |                         |      1 |  24908 |  25033 |00:00:00.04 |     837 |  2222K|  1185K| 3250K (0)|
| 117 |            TABLE ACCESS FULL                     | SYN$                    |      1 |  25032 |  25033 |00:00:00.01 |     145 |       |       |          |
|*118 |            HASH JOIN                             |                         |      1 |  24908 |  25033 |00:00:00.02 |     692 |  1156K|  1156K| 1279K (0)|
| 119 |             INDEX FULL SCAN                      | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*120 |             HASH JOIN                            |                         |      1 |  24908 |  25033 |00:00:00.01 |     691 |  1114K|  1114K| 1240K (0)|
| 121 |              TABLE ACCESS FULL                   | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*122 |              INDEX FAST FULL SCAN                | I_OBJ2                  |      1 |  24908 |  25033 |00:00:00.01 |     677 |       |       |          |
|*123 |           FIXED TABLE FULL                       | X$KZSPR                 |      1 |     17 |      1 |00:00:00.01 |       0 |       |       |          |
|*124 |           FILTER                                 |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
|*125 |            FILTER                                |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 126 |             NESTED LOOPS                         |                         |      0 |     12 |      0 |00:00:00.01 |       0 |       |       |          |
| 127 |              NESTED LOOPS                        |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 128 |               NESTED LOOPS                       |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 129 |                TABLE ACCESS BY INDEX ROWID       | USER$                   |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*130 |                 INDEX UNIQUE SCAN                | I_USER1                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*131 |                INDEX RANGE SCAN                  | I_OBJ5                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*132 |               INDEX RANGE SCAN                   | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*133 |              INDEX RANGE SCAN                    | I_OBJAUTH1              |      0 |     15 |      0 |00:00:00.01 |       0 |       |       |          |
|*134 |            FIXED TABLE FULL                      | X$KZSRO                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 135 |            NESTED LOOPS                          |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*136 |             INDEX SKIP SCAN                      | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*137 |             INDEX RANGE SCAN                     | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 138 |           NESTED LOOPS                           |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*139 |            INDEX SKIP SCAN                       | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*140 |            INDEX RANGE SCAN                      | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 141 |          VIEW                                    | _ALL_SYNONYMS_TREE      |      1 |    142 |      0 |00:00:00.03 |     852 |       |       |          |
|*142 |           CONNECT BY NO FILTERING WITH START-WITH|                         |      1 |        |      0 |00:00:00.03 |     852 |       |       |          |
|*143 |            FILTER                                |                         |      1 |        |      0 |00:00:00.03 |     852 |       |       |          |
|*144 |             HASH JOIN                            |                         |      1 |    142 |      0 |00:00:00.03 |     852 |  1096K|  1096K| 1261K (0)|
| 145 |              TABLE ACCESS FULL                   | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*146 |              HASH JOIN                           |                         |      1 |    142 |      0 |00:00:00.03 |     838 |   972K|   972K| 1230K (0)|
| 147 |               INDEX FULL SCAN                    | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*148 |               HASH JOIN                          |                         |      1 |    142 |      0 |00:00:00.03 |     837 |   739K|   739K|  210K (0)|
|*149 |                HASH JOIN                         |                         |      1 |    142 |      0 |00:00:00.03 |     837 |   972K|   972K| 1276K (0)|
| 150 |                 INDEX FULL SCAN                  | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*151 |                 HASH JOIN                        |                         |      1 |    142 |      0 |00:00:00.03 |     836 |  2222K|  1185K| 3271K (0)|
| 152 |                  TABLE ACCESS FULL               | SYN$                    |      1 |  25032 |  25033 |00:00:00.01 |     145 |       |       |          |
|*153 |                  HASH JOIN                       |                         |      1 |  24908 |  25033 |00:00:00.01 |     691 |  1114K|  1114K| 1267K (0)|
| 154 |                   TABLE ACCESS FULL              | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*155 |                   INDEX FAST FULL SCAN           | I_OBJ2                  |      1 |  24908 |  25033 |00:00:00.01 |     677 |       |       |          |
| 156 |                INDEX FAST FULL SCAN              | I_OBJ2                  |      0 |  65465 |      0 |00:00:00.01 |       0 |       |       |          |
| 157 |             NESTED LOOPS                         |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*158 |              INDEX SKIP SCAN                     | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*159 |              INDEX RANGE SCAN                    | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 160 |             NESTED LOOPS                         |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*161 |              INDEX SKIP SCAN                     | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*162 |              INDEX RANGE SCAN                    | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*163 |            FILTER                                |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 164 |             TABLE ACCESS BY INDEX ROWID          | SYN$                    |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*165 |              INDEX UNIQUE SCAN                   | I_SYN1                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*166 |             FILTER                               |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
|*167 |              FILTER                              |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 168 |               NESTED LOOPS                       |                         |      0 |     12 |      0 |00:00:00.01 |       0 |       |       |          |
| 169 |                NESTED LOOPS                      |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 170 |                 NESTED LOOPS                     |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 171 |                  TABLE ACCESS BY INDEX ROWID     | USER$                   |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*172 |                   INDEX UNIQUE SCAN              | I_USER1                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*173 |                  INDEX RANGE SCAN                | I_OBJ5                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*174 |                 INDEX RANGE SCAN                 | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*175 |                INDEX RANGE SCAN                  | I_OBJAUTH1              |      0 |     15 |      0 |00:00:00.01 |       0 |       |       |          |
|*176 |              FIXED TABLE FULL                    | X$KZSRO                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 177 |              NESTED LOOPS                        |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*178 |               INDEX SKIP SCAN                    | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*179 |               INDEX RANGE SCAN                   | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*180 |             FIXED TABLE FULL                     | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
|*181 |       VIEW                                       | ALL_OBJECTS             |      1 |  30352 |   7921 |00:00:00.45 |   42961 |       |       |          |
|*182 |        FILTER                                    |                         |      1 |        |  64189 |00:00:00.43 |   42959 |       |       |          |
|*183 |         HASH JOIN                                |                         |      1 |  65462 |  65598 |00:00:00.07 |     826 |  1114K|  1114K| 1246K (0)|
| 184 |          TABLE ACCESS FULL                       | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*185 |          HASH JOIN                               |                         |      1 |  65462 |  65598 |00:00:00.05 |     812 |  1156K|  1156K| 1261K (0)|
| 186 |           INDEX FULL SCAN                        | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*187 |           TABLE ACCESS FULL                      | OBJ$                    |      1 |  65462 |  65598 |00:00:00.03 |     811 |       |       |          |
|*188 |         TABLE ACCESS BY INDEX ROWID              | IND$                    |   4510 |      1 |   3819 |00:00:00.01 |    1261 |       |       |          |
|*189 |          INDEX UNIQUE SCAN                       | I_IND1                  |   4510 |      1 |   4510 |00:00:00.01 |     304 |       |       |          |
| 190 |         NESTED LOOPS                             |                         |  22587 |      2 |  21476 |00:00:00.12 |   25823 |       |       |          |
| 191 |          FIXED TABLE FULL                        | X$KZSRO                 |  22587 |      2 |  44492 |00:00:00.04 |       0 |       |       |          |
|*192 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |  44492 |      1 |  21476 |00:00:00.07 |   25823 |       |       |          |
|*193 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     10 |      1 |00:00:00.01 |       0 |       |       |          |
|*194 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     17 |      1 |00:00:00.01 |       0 |       |       |          |
| 195 |         NESTED LOOPS                             |                         |   1236 |      2 |     86 |00:00:00.03 |    3880 |       |       |          |
| 196 |          FIXED TABLE FULL                        | X$KZSRO                 |   1236 |      2 |  23097 |00:00:00.01 |       0 |       |       |          |
|*197 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |  23097 |      1 |     86 |00:00:00.02 |    3880 |       |       |          |
| 198 |         NESTED LOOPS                             |                         |   2140 |      2 |    876 |00:00:00.03 |    2431 |       |       |          |
| 199 |          FIXED TABLE FULL                        | X$KZSRO                 |   2140 |      2 |  26161 |00:00:00.01 |       0 |       |       |          |
|*200 |          INDEX RANGE SCAN                        | I_OBJAUTH1              |  26161 |      1 |    876 |00:00:00.02 |    2431 |       |       |          |
|*201 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     10 |      1 |00:00:00.01 |       0 |       |       |          |
| 202 |         NESTED LOOPS                             |                         |    862 |        |      0 |00:00:00.05 |    6588 |       |       |          |
| 203 |          NESTED LOOPS                            |                         |    862 |      1 |      0 |00:00:00.05 |    6588 |       |       |          |
| 204 |           NESTED LOOPS                           |                         |    862 |      1 |      0 |00:00:00.05 |    6588 |       |       |          |
| 205 |            NESTED LOOPS                          |                         |    862 |      1 |  17240 |00:00:00.04 |    3293 |       |       |          |
| 206 |             MERGE JOIN CARTESIAN                 |                         |    862 |      1 |  17240 |00:00:00.02 |    2429 |       |       |          |
|*207 |              INDEX RANGE SCAN                    | I_OBJ5                  |    862 |      1 |    862 |00:00:00.01 |    2429 |       |       |          |
| 208 |              BUFFER SORT                         |                         |    862 |      2 |  17240 |00:00:00.01 |       0 |  2048 |  2048 | 2048  (0)|
| 209 |               FIXED TABLE FULL                   | X$KZSRO                 |    862 |      2 |  17240 |00:00:00.01 |       0 |       |       |          |
|*210 |             INDEX RANGE SCAN                     | I_USER2                 |  17240 |      1 |  17240 |00:00:00.01 |     864 |       |       |          |
|*211 |            INDEX RANGE SCAN                      | I_OBJAUTH1              |  17240 |      1 |      0 |00:00:00.01 |    3295 |       |       |          |
|*212 |           INDEX RANGE SCAN                       | I_DEPENDENCY1           |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|*213 |          TABLE ACCESS BY INDEX ROWID             | DEPENDENCY$             |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*214 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*215 |         HASH JOIN                                |                         |    155 |      1 |     18 |00:00:00.01 |     521 |   921K|   921K|  538K (0)|
| 216 |          NESTED LOOPS                            |                         |    155 |      2 |     27 |00:00:00.01 |     521 |       |       |          |
|*217 |           TABLE ACCESS BY INDEX ROWID            | TRIGGER$                |    155 |      1 |    137 |00:00:00.01 |     310 |       |       |          |
|*218 |            INDEX UNIQUE SCAN                     | I_TRIGGER2              |    155 |      1 |    155 |00:00:00.01 |     155 |       |       |          |
|*219 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |    137 |      2 |     27 |00:00:00.01 |     211 |       |       |          |
| 220 |          FIXED TABLE FULL                        | X$KZSRO                 |     18 |      2 |     32 |00:00:00.01 |       0 |       |       |          |
|*221 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
| 222 |         NESTED LOOPS                             |                         |    174 |        |      0 |00:00:00.01 |    1181 |       |       |          |
| 223 |          NESTED LOOPS                            |                         |    174 |      1 |      0 |00:00:00.01 |    1181 |       |       |          |
| 224 |           NESTED LOOPS                           |                         |    174 |      1 |      0 |00:00:00.01 |    1181 |       |       |          |
| 225 |            NESTED LOOPS                          |                         |    174 |      1 |   3480 |00:00:00.01 |     671 |       |       |          |
| 226 |             MERGE JOIN CARTESIAN                 |                         |    174 |      1 |   3480 |00:00:00.01 |     495 |       |       |          |
|*227 |              INDEX RANGE SCAN                    | I_OBJ5                  |    174 |      1 |    174 |00:00:00.01 |     495 |       |       |          |
| 228 |              BUFFER SORT                         |                         |    174 |      2 |   3480 |00:00:00.01 |       0 |  2048 |  2048 | 2048  (0)|
| 229 |               FIXED TABLE FULL                   | X$KZSRO                 |    174 |      2 |   3480 |00:00:00.01 |       0 |       |       |          |
|*230 |             INDEX RANGE SCAN                     | I_USER2                 |   3480 |      1 |   3480 |00:00:00.01 |     176 |       |       |          |
|*231 |            INDEX RANGE SCAN                      | I_OBJAUTH1              |   3480 |      1 |      0 |00:00:00.01 |     510 |       |       |          |
|*232 |           INDEX RANGE SCAN                       | I_DEPENDENCY1           |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|*233 |          TABLE ACCESS BY INDEX ROWID             | DEPENDENCY$             |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*234 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*235 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      4 |      1 |00:00:00.01 |       0 |       |       |          |
|*236 |         HASH JOIN                                |                         |      0 |      1 |      0 |00:00:00.01 |       0 |   955K|   955K|          |
| 237 |          NESTED LOOPS                            |                         |      0 |      3 |      0 |00:00:00.01 |       0 |       |       |          |
| 238 |           TABLE ACCESS BY INDEX ROWID            | TABPART$                |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*239 |            INDEX UNIQUE SCAN                     | I_TABPART_OBJ$          |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*240 |           INDEX RANGE SCAN                       | I_OBJAUTH1              |      0 |      3 |      0 |00:00:00.01 |       0 |       |       |          |
| 241 |          FIXED TABLE FULL                        | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|*242 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|*243 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      4 |      0 |00:00:00.01 |       0 |       |       |          |
|*244 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
|*245 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|*246 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*247 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      4 |      1 |00:00:00.01 |       0 |       |       |          |
|*248 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*249 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*250 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|*251 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     17 |      1 |00:00:00.01 |       0 |       |       |          |
|*252 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     14 |      0 |00:00:00.01 |       0 |       |       |          |
|*253 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |     14 |      1 |00:00:00.01 |       0 |       |       |          |
|*254 |         FIXED TABLE FULL                         | X$KZSPR                 |      1 |      7 |      1 |00:00:00.01 |       0 |       |       |          |
|*255 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |      7 |      0 |00:00:00.01 |       0 |       |       |          |
|*256 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     10 |      0 |00:00:00.01 |       0 |       |       |          |
|*257 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     14 |      0 |00:00:00.01 |       0 |       |       |          |
|*258 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     20 |      0 |00:00:00.01 |       0 |       |       |          |
|*259 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     14 |      0 |00:00:00.01 |       0 |       |       |          |
|*260 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     10 |      0 |00:00:00.01 |       0 |       |       |          |
| 261 |         VIEW                                     |                         |     28 |      1 |     28 |00:00:00.01 |       0 |       |       |          |
| 262 |          FAST DUAL                               |                         |     28 |      1 |     28 |00:00:00.01 |       0 |       |       |          |
| 263 |         NESTED LOOPS                             |                         |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
| 264 |          FIXED TABLE FULL                        | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|*265 |          INDEX RANGE SCAN                        | I_OBJAUTH2              |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*266 |         FIXED TABLE FULL                         | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
| 267 |         NESTED LOOPS                             |                         |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
| 268 |          FIXED TABLE FULL                        | X$KZSRO                 |      0 |      2 |      0 |00:00:00.01 |       0 |       |       |          |
|*269 |          INDEX RANGE SCAN                        | I_OBJAUTH2              |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*270 |           FIXED TABLE FULL                       | X$KZSPR                 |      0 |     20 |      0 |00:00:00.01 |       0 |       |       |          |
| 271 |         VIEW                                     |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 272 |          SORT GROUP BY                           |                         |      0 |      1 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 273 |           NESTED LOOPS                           |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 274 |            MERGE JOIN CARTESIAN                  |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 275 |             NESTED LOOPS                         |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*276 |              INDEX UNIQUE SCAN                   | I_OLAP_CUBES$           |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*277 |              TABLE ACCESS BY INDEX ROWID         | OLAP_DIMENSIONALITY$    |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*278 |               INDEX RANGE SCAN                   | I_OLAP_DIMENSIONALITY$  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 279 |             BUFFER SORT                          |                         |      0 |      1 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 280 |              INDEX FULL SCAN                     | I_OLAP_CUBE_DIMENSIONS$ |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*281 |            INDEX RANGE SCAN                      | I_OBJ1                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 282 |         NESTED LOOPS                             |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*283 |          INDEX SKIP SCAN                         | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*284 |          INDEX RANGE SCAN                        | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 285 |      VIEW                                        | ALL_SYNONYMS            |      1 |    143 |      0 |00:00:00.03 |     997 |       |       |          |
| 286 |       SORT UNIQUE                                |                         |      1 |    143 |      0 |00:00:00.03 |     997 |  1024 |  1024 |          |
| 287 |        UNION-ALL                                 |                         |      1 |        |      0 |00:00:00.03 |     997 |       |       |          |
|*288 |         FILTER                                   |                         |      1 |        |      0 |00:00:00.01 |     145 |       |       |          |
| 289 |          NESTED LOOPS                            |                         |      1 |      1 |      0 |00:00:00.01 |     145 |       |       |          |
| 290 |           NESTED LOOPS                           |                         |      1 |      1 |      0 |00:00:00.01 |     145 |       |       |          |
| 291 |            MERGE JOIN CARTESIAN                  |                         |      1 |      1 |      0 |00:00:00.01 |     145 |       |       |          |
|*292 |             TABLE ACCESS FULL                    | SYN$                    |      1 |      1 |      0 |00:00:00.01 |     145 |       |       |          |
| 293 |             BUFFER SORT                          |                         |      0 |    177 |      0 |00:00:00.01 |       0 | 73728 | 73728 |          |
| 294 |              INDEX FULL SCAN                     | I_USER2                 |      0 |    177 |      0 |00:00:00.01 |       0 |       |       |          |
| 295 |            TABLE ACCESS BY INDEX ROWID           | OBJ$                    |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*296 |             INDEX UNIQUE SCAN                    | I_OBJ1                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 297 |           TABLE ACCESS CLUSTER                   | USER$                   |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*298 |            INDEX UNIQUE SCAN                     | I_USER#                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*299 |          FILTER                                  |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
|*300 |           FILTER                                 |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 301 |            NESTED LOOPS                          |                         |      0 |     12 |      0 |00:00:00.01 |       0 |       |       |          |
| 302 |             NESTED LOOPS                         |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 303 |              NESTED LOOPS                        |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 304 |               TABLE ACCESS BY INDEX ROWID        | USER$                   |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*305 |                INDEX UNIQUE SCAN                 | I_USER1                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*306 |               INDEX RANGE SCAN                   | I_OBJ5                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*307 |              INDEX RANGE SCAN                    | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*308 |             INDEX RANGE SCAN                     | I_OBJAUTH1              |      0 |     15 |      0 |00:00:00.01 |       0 |       |       |          |
|*309 |           FIXED TABLE FULL                       | X$KZSRO                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 310 |           NESTED LOOPS                           |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*311 |            INDEX SKIP SCAN                       | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*312 |            INDEX RANGE SCAN                      | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 313 |          NESTED LOOPS                            |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*314 |           INDEX SKIP SCAN                        | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*315 |           INDEX RANGE SCAN                       | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*316 |         VIEW                                     | _ALL_SYNONYMS_TREE      |      1 |    142 |      0 |00:00:00.03 |     852 |       |       |          |
|*317 |          CONNECT BY NO FILTERING WITH START-WITH |                         |      1 |        |      0 |00:00:00.03 |     852 |       |       |          |
|*318 |           FILTER                                 |                         |      1 |        |      0 |00:00:00.03 |     852 |       |       |          |
|*319 |            HASH JOIN                             |                         |      1 |    142 |      0 |00:00:00.03 |     852 |  1096K|  1096K| 1270K (0)|
| 320 |             TABLE ACCESS FULL                    | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*321 |             HASH JOIN                            |                         |      1 |    142 |      0 |00:00:00.03 |     838 |   972K|   972K| 1252K (0)|
| 322 |              INDEX FULL SCAN                     | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*323 |              HASH JOIN                           |                         |      1 |    142 |      0 |00:00:00.03 |     837 |   739K|   739K|  172K (0)|
|*324 |               HASH JOIN                          |                         |      1 |    142 |      0 |00:00:00.03 |     837 |   972K|   972K| 1279K (0)|
| 325 |                INDEX FULL SCAN                   | I_USER2                 |      1 |    177 |    179 |00:00:00.01 |       1 |       |       |          |
|*326 |                HASH JOIN                         |                         |      1 |    142 |      0 |00:00:00.03 |     836 |  2222K|  1185K| 3271K (0)|
| 327 |                 TABLE ACCESS FULL                | SYN$                    |      1 |  25032 |  25033 |00:00:00.01 |     145 |       |       |          |
|*328 |                 HASH JOIN                        |                         |      1 |  24908 |  25033 |00:00:00.01 |     691 |  1114K|  1114K| 1267K (0)|
| 329 |                  TABLE ACCESS FULL               | USER$                   |      1 |    177 |    179 |00:00:00.01 |      14 |       |       |          |
|*330 |                  INDEX FAST FULL SCAN            | I_OBJ2                  |      1 |  24908 |  25033 |00:00:00.01 |     677 |       |       |          |
| 331 |               INDEX FAST FULL SCAN               | I_OBJ2                  |      0 |  65465 |      0 |00:00:00.01 |       0 |       |       |          |
| 332 |            NESTED LOOPS                          |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*333 |             INDEX SKIP SCAN                      | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*334 |             INDEX RANGE SCAN                     | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 335 |            NESTED LOOPS                          |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*336 |             INDEX SKIP SCAN                      | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*337 |             INDEX RANGE SCAN                     | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*338 |           FILTER                                 |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 339 |            TABLE ACCESS BY INDEX ROWID           | SYN$                    |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*340 |             INDEX UNIQUE SCAN                    | I_SYN1                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*341 |            FILTER                                |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
|*342 |             FILTER                               |                         |      0 |        |      0 |00:00:00.01 |       0 |       |       |          |
| 343 |              NESTED LOOPS                        |                         |      0 |     12 |      0 |00:00:00.01 |       0 |       |       |          |
| 344 |               NESTED LOOPS                       |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 345 |                NESTED LOOPS                      |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 346 |                 TABLE ACCESS BY INDEX ROWID      | USER$                   |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*347 |                  INDEX UNIQUE SCAN               | I_USER1                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*348 |                 INDEX RANGE SCAN                 | I_OBJ5                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*349 |                INDEX RANGE SCAN                  | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*350 |               INDEX RANGE SCAN                   | I_OBJAUTH1              |      0 |     15 |      0 |00:00:00.01 |       0 |       |       |          |
|*351 |             FIXED TABLE FULL                     | X$KZSRO                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
| 352 |             NESTED LOOPS                         |                         |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*353 |              INDEX SKIP SCAN                     | I_USER2                 |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*354 |              INDEX RANGE SCAN                    | I_OBJ4                  |      0 |      1 |      0 |00:00:00.01 |       0 |       |       |          |
|*355 |            FIXED TABLE FULL                      | X$KZSPR                 |      0 |     17 |      0 |00:00:00.01 |       0 |       |       |          |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   5 - filter(BITAND("S"."XPFLAGS",8388608)=8388608)
   6 - access("S"."OBJ#"=:B1)
   7 - filter((INTERNAL_FUNCTION("O1"."OBJECT_TYPE") AND (DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='TABLE' 
              OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='SYSTEM 
              TABLE' OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='VIEW' 
              OR DECODE("O1"."OWNER",'SYS',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),'SYSTEM',DECODE("O1"."OBJECT_TYPE",'TABLE','SYSTEM TABLE','VIEW','SYSTEM 
              VIEW',"O1"."OBJECT_TYPE"),"O1"."OBJECT_TYPE")='SYNONYM')))
   8 - 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 (INTERNAL_FUNCTION("O"."TYPE#") AND ( IS NOT NULL OR  IS NOT NULL)) OR (INTERNAL_FUNCTION("O"."TYPE#") AND  IS NOT NULL) OR ("O"."TYPE#"29 AND 
              "O"."TYPE#"13 AND "O"."TYPE#"9 AND "O"."TYPE#"11 AND "O"."TYPE#"30 AND "O"."TYPE#"12 AND "O"."TYPE#"56 AND "O"."TYPE#"7 AND "O"."TYPE#"8 
              AND "O"."TYPE#"14 AND "O"."TYPE#"28 AND "O"."TYPE#"93 AND  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#"=12 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=14 AND ( IS NOT NULL OR  IS NOT NULL)) OR 
              ("O"."TYPE#"=6 AND  IS NOT NULL) OR ("O"."TYPE#"=19 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#"=46 AND  IS NOT NULL) OR ("O"."TYPE#"=68 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") AND  IS 
              NOT NULL) OR ("O"."TYPE#"=23 AND  IS NOT NULL) OR ("O"."TYPE#"=44 AND  IS NOT NULL) OR ("O"."TYPE#"=62 AND  IS NOT NULL) OR ("O"."TYPE#"=42 AND  IS NOT 
              NULL) OR ("O"."TYPE#"=32 AND  IS NOT NULL) OR ("O"."TYPE#"=59 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") 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 (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
   9 - access("O"."SPARE3"="U"."USER#")
  11 - access("O"."OWNER#"="U"."USER#")
  13 - filter(("O"."NAME"'_NEXT_OBJECT' AND "O"."NAME"'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND BITAND("O"."FLAGS",128)=0))
  14 - 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))
  15 - access("I"."OBJ#"=:B1)
  18 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("OA"."PRIVILEGE#") AND "OA"."GRANTEE#"="KZSROROL"))
  19 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
  20 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
  23 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("PRIVILEGE#") AND "GRANTEE#"="KZSROROL"))
  26 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("OA"."PRIVILEGE#") AND "OA"."GRANTEE#"="KZSROROL"))
  27 - filter((((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
  33 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
       filter(("O"."TYPE#"=9 AND "O"."TYPE#"88))
  36 - access("O"."OWNER#"="U"."USER#")
  37 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))
  38 - access("DEP"."D_OBJ#"=:B1)
  39 - filter("DEP"."P_OBJ#"="O"."OBJ#")
  40 - filter((((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
  41 - access("OA"."GRANTEE#"="KZSROROL")
  43 - filter(BITAND("T"."PROPERTY",24)=0)
  44 - access("T"."OBJ#"=:B1)
  45 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26)
       filter("OA"."PRIVILEGE#"=26)
  47 - filter((((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
  53 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
       filter(("O"."TYPE#"=13 AND "O"."TYPE#"88))
  56 - access("O"."OWNER#"="U"."USER#")
  57 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))
  58 - access("DEP"."D_OBJ#"=:B1)
  59 - filter("DEP"."P_OBJ#"="O"."OBJ#")
  60 - filter((((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
  61 - filter(((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE')))
  62 - access("GRANTEE#"="KZSROROL")
  65 - access("OBJ#"=:B1)
  66 - access("BO#"="OBJ#" AND "PRIVILEGE#"=9)
       filter("PRIVILEGE#"=9)
  68 - filter((((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND "INST_ID"=USERENV('INSTANCE')))
  69 - filter(((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE')))
  70 - filter((((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) OR (-"KZSPRPRV")=(-203) OR (-"KZSPRPRV")=(-204)) AND 
              "INST_ID"=USERENV('INSTANCE')))
  71 - filter((((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND "INST_ID"=USERENV('INSTANCE')))
  72 - filter((((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE')))
  73 - filter(((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE')))
  74 - filter((((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE')))
  75 - filter((((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE')))
  76 - filter((((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND "INST_ID"=USERENV('INSTANCE')))
  77 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
  78 - filter((((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND "INST_ID"=USERENV('INSTANCE')))
  79 - filter((((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND "INST_ID"=USERENV('INSTANCE')))
  80 - filter((((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE')))
  81 - filter((((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE')))
  82 - filter((((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE')))
  83 - filter((((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND "INST_ID"=USERENV('INSTANCE')))
  84 - filter((((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR 
              (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE')))
  85 - filter((((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND "INST_ID"=USERENV('INSTANCE')))
  86 - filter((((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE')))
  91 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
  92 - filter((((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR (-"KZSPRPRV")=(-313)) AND 
              "INST_ID"=USERENV('INSTANCE')))
  95 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
  96 - filter((((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR 
              (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE')))
 102 - access("C"."OBJ#"=:B1)
 103 - filter("DIML"."DIMENSION_TYPE"=11)
 104 - access("DIML"."DIMENSIONED_OBJECT_ID"=:B1 AND "DIML"."DIMENSIONED_OBJECT_TYPE"=1)
 107 - access("DIML"."DIMENSION_ID"="DO"."OBJ#")
       filter("DO"."OBJ#"="DIM"."OBJ#")
 109 - 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'))))
 110 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 111 - access("S"."TABLE_OWNER"="O3"."OWNER" AND "S"."TABLE_NAME"="O3"."OBJECT_NAME")
 115 - 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 ("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))
 116 - access("O"."OBJ#"="S"."OBJ#")
 118 - access("O"."OWNER#"="U"."USER#")
 120 - access("O"."SPARE3"="U"."USER#")
 122 - filter("O"."TYPE#"=5)
 123 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
 124 - 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 125 - filter(:B1 IS NULL)
 130 - access("BU"."NAME"=:B1)
 131 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 132 - access("O"."OWNER#"="U"."USER#")
 133 - access("BA"."OBJ#"="O"."OBJ#")
 134 - filter("KZSROROL"=:B1)
 136 - 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'))))
 137 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 139 - 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'))))
 140 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 142 - access("S"."BASE_SYN_ID"=PRIOR NULL)
       filter( IS NOT NULL)
 143 - 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 
              ("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 144 - access("O"."SPARE3"="U"."USER#")
 146 - access("O"."OWNER#"="U"."USER#")
 148 - access("S"."OBJ#"="O"."OBJ#")
 149 - access("O"."OWNER#"="U"."USER#")
 151 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 153 - access("BU"."USER#"="O"."SPARE3")
 155 - filter("O"."TYPE#"=5)
 158 - 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'))))
 159 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 161 - 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'))))
 162 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 163 - filter(( IS NOT NULL OR ("S"."NODE" IS NULL AND  IS NOT NULL)))
 165 - access("S"."OBJ#"=:B1)
 166 - 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 167 - filter(:B1 IS NULL)
 172 - access("BU"."NAME"=:B1)
 173 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 174 - access("O"."OWNER#"="U"."USER#")
 175 - access("BA"."OBJ#"="O"."OBJ#")
 176 - filter("KZSROROL"=:B1)
 178 - 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'))))
 179 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 180 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
 181 - filter(("O3"."OBJECT_TYPE"='TABLE' OR "O3"."OBJECT_TYPE"='VIEW'))
 182 - 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 (INTERNAL_FUNCTION("O"."TYPE#") AND ( IS NOT NULL OR  IS NOT NULL)) OR (INTERNAL_FUNCTION("O"."TYPE#") AND  IS NOT NULL) OR ("O"."TYPE#"29 AND 
              "O"."TYPE#"13 AND "O"."TYPE#"9 AND "O"."TYPE#"11 AND "O"."TYPE#"30 AND "O"."TYPE#"12 AND "O"."TYPE#"56 AND "O"."TYPE#"7 AND "O"."TYPE#"8 
              AND "O"."TYPE#"14 AND "O"."TYPE#"28 AND "O"."TYPE#"93 AND  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#"=12 AND ( IS NOT NULL OR  IS NOT NULL)) OR ("O"."TYPE#"=14 AND ( IS NOT NULL OR  IS NOT NULL)) OR 
              ("O"."TYPE#"=6 AND  IS NOT NULL) OR ("O"."TYPE#"=19 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#"=46 AND  IS NOT NULL) OR ("O"."TYPE#"=68 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") AND  IS 
              NOT NULL) OR ("O"."TYPE#"=23 AND  IS NOT NULL) OR ("O"."TYPE#"=44 AND  IS NOT NULL) OR ("O"."TYPE#"=62 AND  IS NOT NULL) OR ("O"."TYPE#"=42 AND  IS NOT 
              NULL) OR ("O"."TYPE#"=32 AND  IS NOT NULL) OR ("O"."TYPE#"=59 AND  IS NOT NULL) OR (INTERNAL_FUNCTION("O"."TYPE#") 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 (("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))))
 183 - access("O"."SPARE3"="U"."USER#")
 185 - access("O"."OWNER#"="U"."USER#")
 187 - filter(("O"."NAME"'_NEXT_OBJECT' AND "O"."NAME"'_default_auditing_options_' AND "O"."LINKNAME" IS NULL AND BITAND("O"."FLAGS",128)=0))
 188 - 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))
 189 - access("I"."OBJ#"=:B1)
 192 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("OA"."PRIVILEGE#") AND "OA"."GRANTEE#"="KZSROROL"))
 193 - filter((((-"KZSPRPRV")=(-144) OR (-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
 194 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
 197 - access("OBJ#"=:B1 AND "GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("PRIVILEGE#") AND "GRANTEE#"="KZSROROL"))
 200 - access("OA"."OBJ#"=:B1 AND "OA"."GRANTEE#"="KZSROROL")
       filter((INTERNAL_FUNCTION("OA"."PRIVILEGE#") AND "OA"."GRANTEE#"="KZSROROL"))
 201 - filter((((-"KZSPRPRV")=(-184) OR (-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
 207 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=9)
       filter(("O"."TYPE#"=9 AND "O"."TYPE#"88))
 210 - access("O"."OWNER#"="U"."USER#")
 211 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))
 212 - access("DEP"."D_OBJ#"=:B1)
 213 - filter("DEP"."P_OBJ#"="O"."OBJ#")
 214 - filter((((-"KZSPRPRV")=(-141) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
 215 - access("OA"."GRANTEE#"="KZSROROL")
 217 - filter(BITAND("T"."PROPERTY",24)=0)
 218 - access("T"."OBJ#"=:B1)
 219 - access("OA"."OBJ#"="T"."BASEOBJECT" AND "OA"."PRIVILEGE#"=26)
       filter("OA"."PRIVILEGE#"=26)
 221 - filter((((-"KZSPRPRV")=(-152) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
 227 - access("O"."SPARE3"=:B1 AND "O"."NAME"=:B2 AND "O"."TYPE#"=13)
       filter(("O"."TYPE#"=13 AND "O"."TYPE#"88))
 230 - access("O"."OWNER#"="U"."USER#")
 231 - access("OA"."OBJ#"="O"."OBJ#" AND "OA"."GRANTEE#"="KZSROROL" AND "OA"."PRIVILEGE#"=26)
       filter(("OA"."PRIVILEGE#"=26 AND "OA"."GRANTEE#"="KZSROROL"))
 232 - access("DEP"."D_OBJ#"=:B1)
 233 - filter("DEP"."P_OBJ#"="O"."OBJ#")
 234 - filter((((-"KZSPRPRV")=(-181) OR (-"KZSPRPRV")=(-241)) AND "INST_ID"=USERENV('INSTANCE')))
 235 - filter(((-"KZSPRPRV")=(-109) AND "INST_ID"=USERENV('INSTANCE')))
 236 - access("GRANTEE#"="KZSROROL")
 239 - access("OBJ#"=:B1)
 240 - access("BO#"="OBJ#" AND "PRIVILEGE#"=9)
       filter("PRIVILEGE#"=9)
 242 - filter((((-"KZSPRPRV")=(-189) OR (-"KZSPRPRV")=(-190) OR (-"KZSPRPRV")=(-191) OR (-"KZSPRPRV")=(-192)) AND "INST_ID"=USERENV('INSTANCE')))
 243 - filter(((-"KZSPRPRV")=12 AND "INST_ID"=USERENV('INSTANCE')))
 244 - filter((((-"KZSPRPRV")=(-200) OR (-"KZSPRPRV")=(-201) OR (-"KZSPRPRV")=(-202) 
19 05 2011
Charles Hooper
              "INST_ID"=USERENV('INSTANCE')))
 245 - filter((((-"KZSPRPRV")=(-251) OR (-"KZSPRPRV")=(-252) OR (-"KZSPRPRV")=(-253) OR (-"KZSPRPRV")=(-254)) AND "INST_ID"=USERENV('INSTANCE')))
 246 - filter((((-"KZSPRPRV")=(-268) OR (-"KZSPRPRV")=(-267)) AND "INST_ID"=USERENV('INSTANCE')))
 247 - filter(((-"KZSPRPRV")=(-265) AND "INST_ID"=USERENV('INSTANCE')))
 248 - filter((((-"KZSPRPRV")=(-177) OR (-"KZSPRPRV")=(-178)) AND "INST_ID"=USERENV('INSTANCE')))
 249 - filter((((-"KZSPRPRV")=(-222) OR (-"KZSPRPRV")=(-223)) AND "INST_ID"=USERENV('INSTANCE')))
 250 - filter((((-"KZSPRPRV")=(-246) OR (-"KZSPRPRV")=(-247) OR (-"KZSPRPRV")=(-248) OR (-"KZSPRPRV")=(-249)) AND "INST_ID"=USERENV('INSTANCE')))
 251 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))
 252 - filter((((-"KZSPRPRV")=(-205) OR (-"KZSPRPRV")=(-206) OR (-"KZSPRPRV")=(-207) OR (-"KZSPRPRV")=(-208)) AND "INST_ID"=USERENV('INSTANCE')))
 253 - filter((((-"KZSPRPRV")=(-258) OR (-"KZSPRPRV")=(-259) OR (-"KZSPRPRV")=(-260) OR (-"KZSPRPRV")=(-261)) AND "INST_ID"=USERENV('INSTANCE')))
 254 - filter((((-"KZSPRPRV")=(-265) OR (-"KZSPRPRV")=(-266)) AND "INST_ID"=USERENV('INSTANCE')))
 255 - filter((((-"KZSPRPRV")=(-277) OR (-"KZSPRPRV")=(-278)) AND "INST_ID"=USERENV('INSTANCE')))
 256 - filter((((-"KZSPRPRV")=(-292) OR (-"KZSPRPRV")=(-293) OR (-"KZSPRPRV")=(-294)) AND "INST_ID"=USERENV('INSTANCE')))
 257 - filter((((-"KZSPRPRV")=(-282) OR (-"KZSPRPRV")=(-283) OR (-"KZSPRPRV")=(-284) OR (-"KZSPRPRV")=(-285)) AND "INST_ID"=USERENV('INSTANCE')))
 258 - filter((((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR 
              (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE')))
 259 - filter((((-"KZSPRPRV")=(-315) OR (-"KZSPRPRV")=(-316) OR (-"KZSPRPRV")=(-317) OR (-"KZSPRPRV")=(-318)) AND "INST_ID"=USERENV('INSTANCE')))
 260 - filter((((-"KZSPRPRV")=(-320) OR (-"KZSPRPRV")=(-321) OR (-"KZSPRPRV")=(-322)) AND "INST_ID"=USERENV('INSTANCE')))
 265 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 266 - filter((((-"KZSPRPRV")=(-309) OR (-"KZSPRPRV")=(-310) OR (-"KZSPRPRV")=(-311) OR (-"KZSPRPRV")=(-312) OR (-"KZSPRPRV")=(-313)) AND 
              "INST_ID"=USERENV('INSTANCE')))
 269 - access("GRANTEE#"="KZSROROL" AND "OBJ#"=:B1)
 270 - filter((((-"KZSPRPRV")=(-302) OR (-"KZSPRPRV")=(-303) OR (-"KZSPRPRV")=(-304) OR (-"KZSPRPRV")=(-305) OR (-"KZSPRPRV")=(-306) OR 
              (-"KZSPRPRV")=(-307)) AND "INST_ID"=USERENV('INSTANCE')))
 276 - access("C"."OBJ#"=:B1)
 277 - filter("DIML"."DIMENSION_TYPE"=11)
 278 - access("DIML"."DIMENSIONED_OBJECT_ID"=:B1 AND "DIML"."DIMENSIONED_OBJECT_TYPE"=1)
 281 - access("DIML"."DIMENSION_ID"="DO"."OBJ#")
       filter("DO"."OBJ#"="DIM"."OBJ#")
 283 - 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'))))
 284 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 288 - filter(((INTERNAL_FUNCTION("O"."SPARE3") 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 ("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR 
              ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  IS NOT NULL)))
 292 - filter("S"."NODE" IS NOT NULL)
 296 - access("O"."OBJ#"="S"."OBJ#" AND "O"."OWNER#"="U"."USER#" AND "O"."TYPE#"=5)
 298 - access("O"."SPARE3"="U"."USER#")
 299 - 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 300 - filter(:B1 IS NULL)
 305 - access("BU"."NAME"=:B1)
 306 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 307 - access("O"."OWNER#"="U"."USER#")
 308 - access("BA"."OBJ#"="O"."OBJ#")
 309 - filter("KZSROROL"=:B1)
 311 - 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'))))
 312 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 314 - 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'))))
 315 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 316 - filter("ST"."SYN_NODE" IS NOT NULL)
 317 - access("S"."BASE_SYN_ID"=PRIOR NULL)
       filter( IS NOT NULL)
 318 - 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 
              ("U"."TYPE#"2 AND SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND 
              "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 319 - access("O"."SPARE3"="U"."USER#")
 321 - access("O"."OWNER#"="U"."USER#")
 323 - access("S"."OBJ#"="O"."OBJ#")
 324 - access("O"."OWNER#"="U"."USER#")
 326 - access("S"."OWNER"="BU"."NAME" AND "S"."NAME"="O"."NAME")
 328 - access("BU"."USER#"="O"."SPARE3")
 330 - filter("O"."TYPE#"=5)
 333 - 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'))))
 334 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 336 - 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'))))
 337 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 338 - filter(( IS NOT NULL OR ("S"."NODE" IS NULL AND  IS NOT NULL)))
 340 - access("S"."OBJ#"=:B1)
 341 - 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 (("U"."TYPE#"2 AND 
              SYS_CONTEXT('userenv','current_edition_name')='ORA$BASE') OR ("U"."TYPE#"=2 AND "U"."SPARE2"=TO_NUMBER(SYS_CONTEXT('userenv','current_edition_id'))) OR  
              IS NOT NULL)))))
 342 - filter(:B1 IS NULL)
 347 - access("BU"."NAME"=:B1)
 348 - access("BU"."USER#"="O"."SPARE3" AND "O"."NAME"=:B1)
 349 - access("O"."OWNER#"="U"."USER#")
 350 - access("BA"."OBJ#"="O"."OBJ#")
 351 - filter("KZSROROL"=:B1)
 353 - 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'))))
 354 - access("O2"."DATAOBJ#"=:B1 AND "O2"."TYPE#"=88 AND "O2"."OWNER#"="U2"."USER#")
 355 - filter((((-"KZSPRPRV")=(-45) OR (-"KZSPRPRV")=(-47) OR (-"KZSPRPRV")=(-48) OR (-"KZSPRPRV")=(-49) OR (-"KZSPRPRV")=(-50)) AND 
              "INST_ID"=USERENV('INSTANCE')))

Notice in the above execution plans that there are problems with the cardinality estimates, and the MERGE JOIN CARTESIAN join method appear quite frequently (this may not be a problem).

At this time, I do not have the answer for speeding up this particular SQL statement. Someone famous once said that the fastest way to do something is to not do it at all – you might see if that is an option for you.

20 05 2011
Martin Preiss

Charles,
thank you for the links and your research. The question was more of academic interest than of pratical need – and I think you are right: the best solution would be to avoid the query and to use and adapt existing connections. I don’t think, it’s possible to change the query – but DBMS_ADVANCED_REWRITE would certainly be an option. For the sake of completeness some additional observations:
– as already mentioned the performance is related to the user rights: a user with select_catalog_role (or dba role) gets the results faster than a user only with connect – and so the SQL Server forum suggestions are wrong: a reduction of the number of visible objects does not help
– a SQL_TRACE (or into sqlmonitor) reveals that waits are not a problem: the query is almost completly CPU bound
– the use of dba_objects would certainly improve the performance: the view definition of dba_objects is quite simple and a SELECT count(*) needs only 2.600 consistent gets for dba_objects and 169.000 consistent gets for all_objects
– another option to improve the performance of the complete excel query would be to use a common table expression with a materialize hint to replace the all_objects references:

with
all_objects_mat
as
(select /*+ materialize */ *
from all_objects)
SELECT *
FROM (SELECT ...
FROM all_objects_mat o1
WHERE ...
UNION
SELECT ...
FROM all_objects_mat o2,
all_objects_mat o3,
all_synonyms s
WHERE ...) tables
ORDER BY 4,
2,
3 ;

For a DBA user the changed query needs 5 sec (and 175K consistent gets) instead of 15 sec (and 500K consistent gets) for the original query.
For the CONNECT user the changed query runs in 15 sec while the original query needs 55 sec (I have no idea why the numbers differ from the results I got yesterday cause the database is a single user system with little load).
– the rule hint in your query is interesting: what client version did you use (my query is from Excel 2007)?

12 09 2011
System Stats « Oracle Scratchpad

[...] from Sokrates in a Charles Hooper [...]

23 08 2012
Benny

Hi Charles,

from what I read so far, the values in CPUSPEED and CPUSPEEDNW do not actually represent the speed in MHz. It seems to be an internal value Oracle uses to compare the speed of a CPU in relation to others. See e.g. http://www.sql.ru/forum/actualthread.aspx?tid=682014&pg=5&mid=10015821#10015821 for a collection of those values gathered with different CPUs.
Could be that setting CPUSPEED to e.g. 2664 manually (like in your case) might cause unexpected results with Optimizer, because it’s way too high? Just an idea.

– totally agree with manually setting SREADTIM and MREADTIM though!

Benny

23 08 2012
Charles Hooper

Benny,

I believe that you are correct that the CPUSPEED and CPUSPEEDNW values are not directly derived from the CPU’s speed in MHz (or GHz) – I hope that this article did not give the impression that I was stating there was a direct relationship between the speed in MHz and the CPUSPEED/CPUSPEEDNW values. If I recall correctly, the CPUSPEED and CPUSPEEDNW values indicate the number of “Oracle operations” performed in a certain time period (perhaps the number of consistent gets performed per millisecond, although I am not sure that the scale is millisecond). I had previously mentioned that observation a couple of times, including in this article:

http://hoopercharles.wordpress.com/2009/12/27/high-value-for-mbrc-causes-high-bchr-high-cpu-usage-and-slow-performance/

You are correct that setting the CPUSPEED to an arbitrary value could lead to problems with execution plans (and performance) – but doing so might be helpful in certain situations as mentioned in my discussion with Mark Farnham in the comments section of this article. The 2664 value that I manually specified is in fact a value that is higher than the values displayed in the article that you linked, however that value is smaller than the 2714 value that Oracle Database manually calculated. I suppose that the higher manually calculated value might simply mean that the memory throughput (and access time) is faster in the system that I used than it is in the other systems (might be non-ECC vs. ECC type memory, triple/quad channel vs. single/dual channel, 1600MHz memory vs. 800MHz memory, etc.).

23 08 2012
Benny

Hi Charles!

I didn’t read through all the comments, so I didn’t notice the discussion you mentioned. Thank you for the explanations!

15 10 2012
DanyC

Hey Charles,

Quick one:

do you know what is the difference between

BEGIN
DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
END;

and

BEGIN
DBMS_STATS.GATHER_FIXED_OBJECTS_STATS(null);
END;

Cheers,
Dani

15 10 2012
Charles Hooper

Dani,

There should be no difference between the two calls – NULL is the default value of the first parameter. NULL may be specified for additional clarity regarding the intended call behavior. Documentation reference:

http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_stats.htm#i1039162

18 10 2012
DanyC

Cheers Charles, as usual!!

Be well,
Dani

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Follow

Get every new post delivered to your Inbox.

Join 141 other followers

%d bloggers like this: