The New Home of Oracle-wiki.net
The New Home of Oracle-wiki.net
All things oracle...
All things oracle...
A website for IT Professionals involved with Oracle database.
Embedded Files
List Distinct SQL ID's for a Given Session
List Distinct SQL ID's for a Given Session
---- List Distinct SQL ID's for a Given Session-- SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300 SELECT snap_id, sample_id, dbid, instance_number, sql_id, sql_plan_hash_valueFROM dba_hist_active_sess_history WHERE session_id=&Enter_Session_IDAND sql_plan_hash_value IS NOT NULLORDER BY sql_id,sql_plan_hash_value
/
Published on
Published 18th June 2025
Page updated
Google Sites
Report abuse