Home > Scripts > How to generate the explain for a SQL.

How to generate the explain for a SQL.

December 17, 2013

Recently i have got a chance to work on TUNING activity as a part of this i generated explain for couple of time using below method.

———————————————

set lines 180 pages 30000

explain plan for

<SQL>;

select plan_table_output from table(dbms_xplan.display(‘plan_table’,null,’advanced -projection’));

———————————————

Please note that PLAN_TABLE should be created before doing above. Table can be created using below script.

@$ORACLE_HOME/rdbms/admin/utlxplan.sql


					
Advertisements
Categories: Scripts
%d bloggers like this: