ORA-13768: Snapshot ID must be between 1 and 15 - when loading in cloned enviorment
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