SQL> SET LINESIZE 132
SQL> SELECT * FROM TABLE(dbms_xplan.DISPLAY('PLAN_TABLE','100'));

PLAN_TABLE_OUTPUT                                                                                                                   
------------------------------------------------------------------------------------------------------------------------------------
                                                                                                                                    
-------------------------------------------------------------------------------------------------------                             
| Id  | Operation                          | Name                        | Rows  | Bytes | Cost (%CPU)|                             
-------------------------------------------------------------------------------------------------------                             
|   0 | SELECT STATEMENT                   |                             |    11 |   786 |     6  (34)|                             
|   1 |  UNION-ALL                         |                             |       |       |            |                             
|*  2 |   FILTER                           |                             |       |       |            |                             
|   3 |    NESTED LOOPS ANTI               |                             |   104 |  7800 |     4   (0)|                             
|*  4 |     TABLE ACCESS FULL              | STTM_CUST_ACCOUNT           |   104 |  4056 |     3   (0)|                             
|*  5 |     TABLE ACCESS BY INDEX ROWID    | SMTB_USER_ACCESS_EXCE_ACCTS |     1 |    36 |     1   (0)|                             
|*  6 |      INDEX UNIQUE SCAN             | PK_SMTB_USER_EXCE_ACCTS     |     1 |       |     0   (0)|                             

PLAN_TABLE_OUTPUT                                                                                                                   
------------------------------------------------------------------------------------------------------------------------------------
|   7 |    VIEW                            | SMVW_USER_BRANCHES          |     2 |    22 |    12   (0)|                             
|   8 |     UNION-ALL                      |                             |       |       |            |                             
|   9 |      MINUS                         |                             |       |       |            |                             
|  10 |       NESTED LOOPS                 |                             |     1 |    17 |     2   (0)|                             
|* 11 |        TABLE ACCESS BY INDEX ROWID | STTM_BRANCH                 |     1 |     8 |     1   (0)|                             
|* 12 |         INDEX UNIQUE SCAN          | SYS_C007309                 |     1 |       |     0   (0)|                             
|* 13 |        TABLE ACCESS BY INDEX ROWID | SMTB_USER                   |     1 |     9 |     1   (0)|                             
|* 14 |         INDEX UNIQUE SCAN          | PK_SMUSER                   |     1 |       |     0   (0)|                             
|  15 |       SORT UNIQUE                  |                             |     1 |    20 |            |                             
|  16 |        NESTED LOOPS                |                             |     1 |    20 |     5   (0)|                             
|* 17 |         TABLE ACCESS BY INDEX ROWID| SMTB_USER                   |     1 |     9 |     2   (0)|                             

PLAN_TABLE_OUTPUT                                                                                                                   
------------------------------------------------------------------------------------------------------------------------------------
|* 18 |          INDEX UNIQUE SCAN         | PK_SMUSER                   |     1 |       |     1   (0)|                             
|* 19 |         TABLE ACCESS FULL          | SMTB_USER_BRANCHES          |     1 |    11 |     3   (0)|                             
|  20 |      NESTED LOOPS                  |                             |     1 |    20 |     5   (0)|                             
|* 21 |       TABLE ACCESS BY INDEX ROWID  | SMTB_USER                   |     1 |     9 |     2   (0)|                             
|* 22 |        INDEX UNIQUE SCAN           | PK_SMUSER                   |     1 |       |     1   (0)|                             
|* 23 |       TABLE ACCESS FULL            | SMTB_USER_BRANCHES          |     1 |    11 |     3   (0)|                             
|* 24 |    FILTER                          |                             |       |       |            |                             
|  25 |     NESTED LOOPS                   |                             |     1 |    19 |     2   (0)|                             
|* 26 |      TABLE ACCESS BY INDEX ROWID   | STTM_ACCOUNT_CLASS          |     1 |    10 |     1   (0)|                             
|* 27 |       INDEX UNIQUE SCAN            | STACCCLS_PK                 |     1 |       |     0   (0)|                             
|  28 |      TABLE ACCESS BY INDEX ROWID   | SMTB_USER                   |     1 |     9 |     1   (0)|                             

PLAN_TABLE_OUTPUT                                                                                                                   
------------------------------------------------------------------------------------------------------------------------------------
|* 29 |       INDEX UNIQUE SCAN            | PK_SMUSER                   |     1 |       |     0   (0)|                             
|* 30 |     INDEX UNIQUE SCAN              | UI_SM_USER_ACCCLASS         |     1 |    12 |     1   (0)|                             
|* 31 |     INDEX UNIQUE SCAN              | UI_SM_USER_ACCCLASS         |     1 |    12 |     1   (0)|                             
|* 32 |   TABLE ACCESS BY INDEX ROWID      | SMTB_USER_ACCESS_EXCE_ACCTS |     1 |    36 |     2   (0)|                             
|* 33 |    INDEX RANGE SCAN                | PK_SMTB_USER_EXCE_ACCTS     |     2 |       |     1   (0)|                             
-------------------------------------------------------------------------------------------------------