Database Tuning (MOSC)

MOSC Banner

ORA-13767: End snapshot ID must be greater than begin snapshot ID.

edited Nov 22, 2018 1:16AM in Database Tuning (MOSC) 4 commentsAnswered

Hi,

When running sql tuning adviser , getting below error after giving sql id.

SQL> @?/rdbms/admin/sqltrpt.sql

ERROR at line 1:

ORA-13767: End snapshot ID must be greater than begin snapshot ID.

ORA-06512: at line 36

ERROR:

ORA-13608: The specified name NULL is invalid.

ORA-06512: at "SYS.PRVT_ADVISOR", line 5883

ORA-06512: at "SYS.DBMS_SQLTUNE", line 926

ORA-06512: at line 1

But for other sql's its working fine. Please suggest.

Database 11g Enterprise Edition Release 11.2.0.3.0

Regards

Shekar

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