SQL> set autotrace traceonly;
SQL> select * from dba_users;
24 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 2681337108
----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 64 | 17472 | 26 (0)| 00:00:01 |
| 1 | NESTED LOOPS | | 64 | 17472 | 26 (0)| 00:00:01 |
|* 2 | HASH JOIN | | 17 | 4318 | 20 (0)| 00:00:01 |
|* 3 | HASH JOIN | | 17 | 4148 | 17 (0)| 00:00:01 |
|* 4 | HASH JOIN OUTER | | 17 | 3978 | 14 (0)| 00:00:01 |
|* 5 | HASH JOIN | | 17 | 3808 | 11 (0)| 00:00:01 |
|* 6 | HASH JOIN OUTER | | 17 | 3536 | 9 (0)| 00:00:01 |
| 7 | NESTED LOOPS | | 17 | 2856 | 7 (0)| 00:00:01 |
| 8 | MERGE JOIN CARTESIAN | | 1 | 26 | 4 (0)| 00:00:01 |
|* 9 | TABLE ACCESS FULL | PROFILE$ | 1 | 13 | 2 (0)| 00:00:01 |
| 10 | BUFFER SORT | | 2 | 26 | 2 (0)| 00:00:01 |
|* 11 | TABLE ACCESS FULL | PROFILE$ | 2 | 26 | 2 (0)| 00:00:01 |
|* 12 | TABLE ACCESS BY INDEX ROWID BATCHED| USER$ | 12 | 1704 | 3 (0)| 00:00:01 |
|* 13 | INDEX SKIP SCAN | I_USER2 | 24 | | 1 (0)| 00:00:01 |
|* 14 | TABLE ACCESS FULL | RESOURCE_GROUP_MAPPING$ | 1 | 40 | 2 (0)| 00:00:01 |
| 15 | TABLE ACCESS FULL | PROFNAME$ | 2 | 32 | 2 (0)| 00:00:01 |
| 16 | TABLE ACCESS FULL | TS$ | 5 | 50 | 3 (0)| 00:00:01 |
| 17 | TABLE ACCESS FULL | TS$ | 5 | 50 | 3 (0)| 00:00:01 |
| 18 | TABLE ACCESS FULL | TS$ | 5 | 50 | 3 (0)| 00:00:01 |
|* 19 | TABLE ACCESS FULL | USER_ASTATUS_MAP | 4 | 76 | 0 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------------------