Find sql baseline info from sql_id
Pass the sql_id to get the respective sql baseline
oracle configurationintermediate
by OracleDba
12 views
📋Steps in this guide1/1
1
Find sql baseline info from sql_id
Pass the sql_id to get the respective sql baseline
Code/Command (click line numbers to comment):
12
SELECT sql_handle, plan_name FROM dba_sql_plan_baselines WHERE
signature IN ( SELECT exact_matching_signature FROM gv$sql WHERE sql_id='&SQL_ID')Comments (0)
Please to add comments
No comments yet. Be the first to comment!