List Distinct SQL ID's for a Given Session
--
-- List Distinct SQL ID's for a Given Session
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT
   snap_id,
   sample_id,
   dbid,
   instance_number,
   sql_id,
   sql_plan_hash_value
FROM dba_hist_active_sess_history 
WHERE session_id=&Enter_Session_ID
AND sql_plan_hash_value IS NOT NULL
ORDER BY sql_id,sql_plan_hash_value
/

Related Scripts

Get Historical Plans from the AWR Using SQLID
Displays SQL Statement for the Specified Address or Hash
List SQL Run Dates for a Given Plan Hash Value

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License