Database Tuning (MOSC)

MOSC Banner

ORA-20025 when running awrsqrpt.sql

edited Apr 30, 2018 8:28AM in Database Tuning (MOSC) 2 commentsAnswered

I'm running awrsqrpt.sql to get an AWR report on a specific SID.  It takes the start and end time values with no issue, but after I enter the SID I get the following error:

Specify the SQL Id
~~~~~~~~~~~~~~~~~~
Enter value for sql_id: 290
SQL ID specified:  290
declare
*
ERROR at line 1:
ORA-20025: SQL ID 290 does not exist for this database/instance
ORA-06512: at line 22

The SID is there and active:

SQL> select STATUS FROM V$SESSION WHERE SID=290;

STATUS
--------
ACTIVE

It's there and active, there's nothing in the knowledge base for this specific issue for ORA-20025.  Any suggestions?

Barry Niconienko

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