sql_card

select id , object_name, OBJECT_OWNER OWNER, operation,options, cost , CARDINALITY "ROWS",Last_degree Degree
--,  to_char(to_date(time,'sssss'),'hh24:mi:ss') Time
from gv$sql_plan_statistics_all
where CARDINALITY >0 and time > 0
--object_name is not null
and sql_id ='&&sql_id'
and PLAN_HASH_VALUE='&&plan_hash_value' 
--and inst_id = ' 1'
--and child_number = 151
--and time is not null
order by id