STATEMENT_ID           
PLAN_ID                
TIMESTAMP              
REMARKS                
OPERATION              
OPTIONS                
OBJECT_NODE            
OBJECT_OWNER           
OBJECT_NAME            
OBJECT_ALIAS           
OBJECT_INSTANCE        
OBJECT_TYPE            
OPTIMIZER              
SEARCH_COLUMNS         
ID                     
PARENT_ID              
DEPTH                  
POSITION               
COST                   
CARDINALITY            
BYTES                  
OTHER_TAG              
PARTITION_START        
PARTITION_STOP         
PARTITION_ID           
OTHER                  
DISTRIBUTION           
CPU_COST               
IO_COST                
TEMP_SPACE             
ACCESS_PREDICATES      
FILTER_PREDICATES      
PROJECTION             
TIME                   
QBLOCK_NAME            


EXPLAIN PLAN set STATEMENT_ID = 'A' FOR select * from (select name, x, y  from l where (x  < 50))

EXPLAIN PLAN set STATEMENT_ID = 'A' FOR select *  from l where (x  < 50) 

select id, COST,CPU_COST IO_COST ,TEMP_SPACE   ,CARDINALITY ,BYTES  from plan_table where statement_id = 'A'





@?/rdbms/admin/utlxplan 

@?/sqlplus/admin/plustrce