sql_check

 col SQL_PROFILE for a40
select inst_id, sql_id, child_number ,SQL_PLAN_BASELINE, SQL_PROFILE, 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