Step by step "TUNINING SQL STATEMENT"
- You must execute script when create table "PLAN_TABLE
$ORACLE_HOME\RDBMS\ADMIN\UTLXPLAN.SQL
- Run PLAN
explain plan
set statement_id ='a3' into plan_table for select * from test
where code= :1;
- Select result
select
STATEMENT_ID, TIMESTAMP, REMARKS,
OPERATION, OPTIONS, OBJECT_NODE,
OBJECT_TYPE,OPTIMIZER,SEARCH_COLUMNS,
ID, PARENT_ID, POSITION,
COST, CARDINALITY, BYTES,
OTHER_TAG, PARTITION_START, PARTITION_STOP,
PARTITION_ID, other
from plan_table
where statement_id ='a2'
Mirek Dylong
Received on Mon Mar 12 2001 - 04:38:34 CST