Saturday, May 8, 2021

sql_id

set lin 450

select inst_id,sql_id,child_number,SQL_PLAN_BASELINE,to_char(last_active_time,'DD-MON-YYYY HH24:MI:SS')last_active_time,plan_hash_value from gv$sql
where sql_id = '&&sql_id' and last_active_time is not null order by last_active_time;

No comments:

Post a Comment