
rem 
rem $Header: utlxplan.sql 29-oct-2001.20:28:58 mzait Exp $ xplainpl.sql 
rem 
Rem Copyright (c) 1988, 2001, Oracle Corporation. All rights reserved. 
Rem NAME 
REM UTLXPLAN.SQL 
Rem FUNCTION 
Rem NOTES 
Rem MODIFIED 
Rem mzait 10/26/01 - add keys and filter predicates to the plan table 
Rem ddas 05/05/00 - increase length of options column 
Rem ddas 04/17/00 - add CPU, I/O cost, temp_space columns 
Rem mzait 02/19/98 - add distribution method column 
Rem ddas 05/17/96 - change search_columns to number 
Rem achaudhr 07/23/95 - PTI: Add columns partition_{start, stop, id} 
Rem glumpkin 08/25/94 - new optimizer fields 
Rem jcohen 11/05/93 - merge changes from branch 1.1.710.1 - 9/24 
Rem jcohen 09/24/93 - #163783 add optimizer column 
Rem glumpkin 10/25/92 - Renamed from XPLAINPL.SQL 
Rem jcohen 05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef) 
Rem rlim 04/29/91 - change char to varchar2 
Rem Peeler 10/19/88 - Creation 
Rem 
Rem This is the format for the table that is used by the EXPLAIN PLAN 
Rem statement. The explain statement requires the presence of this 
Rem table in order to store the descriptions of the row sources. 

drop table PLAN_TABLE; 

create table PLAN_TABLE ( 
xxstatement_id xxvarchar2(30), 
xxtimestamp xxdate, 
xxremarks xxvarchar2(80), 
xxoperation xxvarchar2(30), 
xxoptions xxvarchar2(255), 
xxobject_node xxvarchar2(128), 
xxobject_owner xxvarchar2(30), 
xxobject_name xxvarchar2(30), 
xxobject_instance numeric, 
xxobject_type varchar2(30), 
xxoptimizer varchar2(255), 
xxsearch_columns number, 
xxid xx xxnumeric, 
xxparent_id xxnumeric, 
xxposition xxnumeric, 
xxcost xx xxnumeric, 
xxcardinality xxnumeric, 
xxbytes xx xxnumeric, 
xxother_tag varchar2(255), 
xxpartition_start varchar2(255), 
partition_stop varchar2(255), 
partition_id numeric, 
xxother xx xxlong, 
xxdistribution varchar2(30), 
xxcpu_cost xxnumeric, 
xxio_cost xx xxnumeric, 
xxtemp_space xxnumeric, 
access_predicates varchar2(4000), 
filter_predicates varchar2(4000)); 
