SQL Performance (MOSC)

MOSC Banner

Unable to load sql plans to baseline using sqlset

edited Jan 21, 2017 4:00AM in SQL Performance (MOSC) 4 commentsAnswered ✓

Hi guys,

I'm unable to load all the sql plans into the baseline from the sqlset.

want to ask. anyone faced this issue before? and how you solve it.

select sqlset_name,SQL_ID, PLAN_HASH_VALUE,ELAPSED_TIME,OPTIMIZER_COST,BIND_DATA from DBA_SQLSET_STATEMENTS where upper(sql_id) = upper('XX8hmghX9v1x')

     

SQLSET_NAMESQL_IDPLAN_HASH_VALUEELAPSED_TIMEOPTIMIZER_COST
XXJ8HMGHA9V1X_SETXXj8hmghX9v1x863,359,5801,242,023,471
XXJ8HMGHA9V1X_SETXXj8hmghX9v1x1,762,480,34916,140,092
XXJ8HMGHA9V1X_SETXXj8hmghX9v1x2,710,829,60774,799,855,31340

SET SERVEROUTPUT ON

DECLARE

my_plans pls_integer;

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