AWR Analysis

SET LINES 260
SET PAGES 200
COLUMN sql_profile FORMAT A45
COLUMN sql_plan_baseline FORMAT A45
COLUMN sql_patch FORMAT A45
COLUMN module FORMAT A35
SELECT inst_id,
       sql_id,
       child_number,
       plan_hash_value,
       sql_profile,
       sql_plan_baseline,
       sql_patch,
       module,
       parsing_schema_name,
       executions,
       last_active_time
FROM   gv$sql
WHERE  sql_id = '7r1gn0tpbwjjj'

ORDER BY last_active_time DESC;