> 作者： Yunlong YANG

我們可以透過很多方式獲取Oracle 的sql執行計劃，也可以透過檢視直接檢視當前執行計劃，如下所示：
``` sql
SQL> col "QUERY Plan_Table" format a50
select id,lpad(' ',2*(level-1))||operation||' ' ||options||' ' || object_name||' '||decode(id,0,'Cost='||cost) "QUERY Plan_Table"
from v$sql_plan start with id=0 and sql_id='17f8jqsxpnzah'
connect by prior id=parent_id andSQL>   2    3   sql_id='17f8jqsxpnzah';

ID QUERY Plan_Table
---------- --------------------------------------------------
	 0 SELECT STATEMENT   Cost=1
	 1   TABLE ACCESS BY INDEX ROWID T_OBJECTS
	 2     INDEX RANGE SCAN IND_T_ID

--也可以根據需求，列出其他的內容
SQL> col "QUERY Plan_Table" format a50
select id,lpad(' ',2*(level-1))||operation||' ' ||options||' ' || object_name||' '||decode(id,0,'Cost='||cost) "QUERY Plan_Table",BYTES,IO_COST
from v$sql_plan start with id=0 and sql_id='17f8jqsxpnzah'
connect by prior idSQL> =parent_id and sql_id='17f8jqsxpnzah';  2    3

ID QUERY Plan_Table					   BYTES    IO_COST
---------- -------------------------------------------------- ---------- ----------
	 0 SELECT STATEMENT   Cost=1
	 1   TABLE ACCESS BY INDEX ROWID T_OBJECTS		     207	  0
	 2     INDEX RANGE SCAN IND_T_ID					  0

SQL> 
```

具體可參考官方文件，檢視相關列的說明：
V$SQL_PLAN
- https://docs.oracle.com/database/121/REFRN/GUID-87561B21-721C-42EB-8E3D-28251C9BC50C.htm#REFRN30250

【SQL_PLAN】Oracle 透過檢視sql_plan 格式化執行計劃

相關文章