[11/27] Plan_table

orcl@SCOTT> explain plan set statement_id = 'demo01' for select * from emp

  2  where ename = 'KING';

Explained.

orcl@SCOTT> select * from table (DBMS_XPLAN.DISPLAY());

PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Plan hash value: 3956160932

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |    38 |     3   (0)| 00:00:01 |

|*  1 |  TABLE ACCESS FULL| EMP  |     1 |    38 |     3   (0)| 00:00:01 |

--------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   1 - filter("ENAME"='KING')

13 rows selected.

orcl@SCOTT> select * from table(dbms_xplan.display(null,null,'ALL'));

PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Plan hash value: 3956160932

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |    38 |     3   (0)| 00:00:01 |

|*  1 |  TABLE ACCESS FULL| EMP  |     1 |    38 |     3   (0)| 00:00:01 |

--------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):

-------------------------------------------------------------

   1 - SEL$1 / EMP@SEL$1

Predicate Information (identified by operation id):

---------------------------------------------------

   1 - filter("ENAME"='KING')

Column Projection Information (identified by operation id):

-----------------------------------------------------------

   1 - "EMP"."EMPNO"[NUMBER,22], "ENAME"[VARCHAR2,10],

       "EMP"."JOB"[VARCHAR2,9], "EMP"."MGR"[NUMBER,22],

       "EMP"."HIREDATE"[DATE,7], "EMP"."SAL"[NUMBER,22],

       "EMP"."COMM"[NUMBER,22], "EMP"."DEPTNO"[NUMBER,22],

       "EMP"."STARS"[VARCHAR2,20]

27 rows selected.

orcl@SCOTT> select plan_table_output from table(dbms_xplan.display(null,null,'ADVANCED -PROJECTION -PREDICATE -ALIAS'));

PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Plan hash value: 3956160932

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |    38 |     3   (0)| 00:00:01 |

|   1 |  TABLE ACCESS FULL| EMP  |     1 |    38 |     3   (0)| 00:00:01 |

--------------------------------------------------------------------------

Outline Data

-------------

  /*+

      BEGIN_OUTLINE_DATA

      FULL(@"SEL$1" "EMP"@"SEL$1")

      OUTLINE_LEAF(@"SEL$1")

      ALL_ROWS

      DB_VERSION('11.2.0.1')

      OPTIMIZER_FEATURES_ENABLE('11.2.0.1.1')

      IGNORE_OPTIM_EMBEDDED_HINTS

      END_OUTLINE_DATA

  */

22 rows selected.