SQL Performance (MOSC)

MOSC Banner

issues with sql baselines

edited May 23, 2013 6:27AM in SQL Performance (MOSC) 6 commentsAnswered
i run this following query :

SELECT DISTINCT /*+ INDEX (l KS_LEDGER_1PK) */ a.acct_num
            FROM PATRON.ST_LEDGER_AVAIL_FUNDS a, ks_acct_ledger al, ks_ledger l
           WHERE     A.ACCT_NUM = l.acct_num
                 AND al.ledger_id = l.id
                 AND l.balance > 0
/

and i get its sql_id as 3xs2m3rvk5q71

when I look for the baseline for this sql_id i cant find it. 

SELECT sql_handle, plan_name
FROM dba_sql_plan_baselines
WHERE signature IN (SELECT exact_matching_signature FROM v$sqlarea WHERE sql_id='3xs2m3rvk5q71');

no rows found.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center