查看SQl执行计划

SQL> explain plan for SELECT b.MACHINE, b.PROGRAM, COUNT(*)
  2    FROM v$process a, v$session b
  3   WHERE a.ADDR = b.PADDR
  4     AND b.USERNAME IS NOT NULL
  5   GROUP BY b.MACHINE, b.PROGRAM
  6   ORDER BY COUNT(*) DESC;
 
Explained

SQL> select plan_table_output from table(dbms_xplan.display);
 
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1009378975
--------------------------------------------------------------------------------
| Id  | Operation                   | Name            | Rows  | Bytes | Cost (%C
--------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                 |     1 |   206 |     2 (1
|   1 |  SORT ORDER BY              |                 |     1 |   206 |     2 (1
|   2 |   HASH GROUP BY             |                 |     1 |   206 |     2 (1
|   3 |    NESTED LOOPS             |                 |     1 |   206 |     0
|   4 |     NESTED LOOPS            |                 |     1 |   193 |     0
|   5 |      MERGE JOIN CARTESIAN   |                 |     5 |   290 |     0
|*  6 |       FIXED TABLE FULL      | X$KSUPR         |     1 |    32 |     0
|   7 |       BUFFER SORT           |                 |   100 |  2600 |     0
|   8 |        FIXED TABLE FULL     | X$KSLWT         |   100 |  2600 |     0
|*  9 |      FIXED TABLE FIXED INDEX| X$KSUSE (ind:1) |     1 |   135 |     0
|* 10 |     FIXED TABLE FIXED INDEX | X$KSLED (ind:2) |     1 |    13 |     0
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
 
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
   6 - filter("INST_ID"=USERENV('INSTANCE') AND BITAND("KSSPAFLG",1)<>0)
   9 - filter("S"."KSUUDLNA" IS NOT NULL AND "S"."INST_ID"=USERENV('INSTANCE') A
              BITAND("S"."KSSPAFLG",1)<>0 AND BITAND("S"."KSUSEFLG",1)<>0 AND "A
              AND "S"."INDX"="W"."KSLWTSID")
  10 - filter("W"."KSLWTEVT"="E"."INDX")
 
26 rows selected