oracle中查看sql执行计划和已执行过的SQL计划-CSDN博客

1.SQL>explain plan for select * from scott.emp ;

Explained.

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------
Plan hash value: 3956160932

--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |    14 |   518 |     3   (0)| 00:00:01 |
|   1 | TABLE ACCESS FULL| EMP |    14 |   518 |     3   (0)| 00:00:01 |
--------------------------------------------------------------------------

已选择8行。

2.
SQL> select * from scott.emp;

     EMPNO ENAME      JOB              MGR HIREDATE              SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-12月-80            800                    20
      7499 ALLEN      SALESMAN        7698 20-2月 -81           1600        300         30
      7521 WARD       SALESMAN        7698 22-2月 -81           1250        500         30
      7566 JONES      MANAGER         7839 02-4月 -81           2975                    20
      7654 MARTIN     SALESMAN        7698 28-9月 -81           1250       1400         30
      7698 BLAKE      MANAGER         7839 01-5月 -81           2850                    30
      7782 CLARK      MANAGER         7839 09-6月 -81           2450                    10
      7788 SCOTT      ANALYST         7566 19-4月 -87           3000                    20
      7839 KING       PRESIDENT            17-11月-81           5000                    10
      7844 TURNER     SALESMAN        7698 08-9月 -81           1500          0         30
      7876 ADAMS      CLERK           7788 23-5月 -87           1100                    20
      7900 JAMES      CLERK           7698 03-12月-81            950                    30
      7902 FORD       ANALYST         7566 03-12月-81           3000                    20
      7934 MILLER     CLERK           7782 23-1月 -82           1300                    10

已选择14行。
SQL> select sql_id from v$sql where sql_text='select * from scott.emp';

SQL_ID
-------------
ggqns3c1jz86c

SQL> select * from table(dbms_xplan.display_cursor('ggqns3c1jz86c'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------
SQL_ID ggqns3c1jz86c, child number 0
-------------------------------------
select * from scott.emp

Plan hash value: 3956160932

--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |       |       |     3 (100)|          |
|   1 | TABLE ACCESS FULL| EMP |    14 |   518 |     3   (0)| 00:00:01 |
--------------------------------------------------------------------------

已选择13行。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22253646/viewspace-667334/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22253646/viewspace-667334/