oracle-wiki.net - List SQL Run Dates for a Given Plan Hash Value

The New Home of Oracle-wiki.net

All things oracle...

A website for IT Professionals involved with Oracle database.

Back

List SQL Run Dates for a Given Plan Hash Value

---- List SQL Run Dates for a Given Plan Hash Value-- SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300 SELECT DISTINCT sql_plan_hash_value, to_char(sample_time,'DD-Mon-YYYY') as st FROM DBA_HIST_ACTIVE_SESS_HISTORY WHERE sql_plan_hash_value=&Enter_Plan_Hash_ValueORDER BY st

Published on

Published 18th June 2025

Page updated

Google Sites

Report abuse