REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	u_autotrace.sql
REM
REM <SQLDIR_GRP>UTIL MOST</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy
REM
REM Purpose:
REM	<SQLDIR_TXT>
REM	Creates PLAN table by running $ORACLE_HOME/rdbms/admin/utlxplan.sql
REM	sets AUTOTRACE ON (traceonly explain)
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	u_autotrace.sql
REM 
REM Example:
REM	u_autotrace.sql
REM
REM
REM History:
REM	11-25-2001	VMOGILEV	Created
REM
REM

--alter session set hash_area_size=30000000;

@?/rdbms/admin/utlxplan.sql 

set autotrace traceonly explain
set lines 1000
set trims on
column plan_plus_exp format a800