select timestamp,id,lpad(' ', depth * 4) || operation operation,options,object_owner,object_name,optimizer,
cost, cardinality, bytes, cpu_cost, io_cost, temp_space, access_predicates
from dba_hist_sql_plan
where plan_hash_value='3530185607' -- sql_id='90bu5gk069js1' --and
ORDER BY timestamp,ID;
select timestamp,id,lpad(' ', depth * 4) || operation operation,options,object_owner,object_name,optimizer,
cost, cardinality, bytes, cpu_cost, io_cost, temp_space, access_predicates
from v$sql_plan
where sql_id='994f3dnk69v3h';
cost, cardinality, bytes, cpu_cost, io_cost, temp_space, access_predicates
from dba_hist_sql_plan
where plan_hash_value='3530185607' -- sql_id='90bu5gk069js1' --and
ORDER BY timestamp,ID;
select timestamp,id,lpad(' ', depth * 4) || operation operation,options,object_owner,object_name,optimizer,
cost, cardinality, bytes, cpu_cost, io_cost, temp_space, access_predicates
from v$sql_plan
where sql_id='994f3dnk69v3h';