Performance - EBS (MOSC)

MOSC Banner

ORA-13768: Snapshot ID must be between 1 and 15 - when loading in cloned enviorment

edited Jan 9, 2017 3:47PM in Performance - EBS (MOSC) 7 commentsAnswered

Hi Team,

I am trying to load the SQL into STS into a cloned enviorment but getting the following.

Elapsed: 00:00:00.03

18:07:04 APPS@IREBSPSL1>> set lines 150

18:07:24 APPS@IREBSPSL1>> col module for a25

18:07:24 APPS@IREBSPSL1>> col action for a25

select distinct a.sql_id ,a.PLAN_HASH_VALUE,a.SNAP_ID

18:07:24 APPS@IREBSPSL1>> 18:07:24   2  from DBA_HIST_SQLSTAT a , dba_hist_snapshot b

18:07:24   3  where

a.snap_id=b.snap_id

18:07:24   4  18:07:24   5  and sql_id='4c0g8raqgkybn'

18:07:24   6  and plan_hash_value='2128479914'

18:07:24   7  order by 3 desc;

SQL_ID        PLAN_HASH_VALUE    SNAP_ID

------------- --------------- ----------

4c0g8raqgkybn      2128479914      71771

4c0g8raqgkybn      2128479914      71770

4c0g8raqgkybn      2128479914      70609

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center