SQL Performance (MOSC)

MOSC Banner

sqlt: for 10.2 database - ORA-20404: sql with id "gp4kn8xm77c2j" was not found in memory nor in a

edited Dec 12, 2014 10:01AM in SQL Performance (MOSC) 1 commentAnswered ✓

The runing of sqltexecute with a script is not finding the previous sql and failing with ERROR at line 1:

ORA-20404: sql with id "gp4kn8xm77c2j" was not found in memory nor in awr

Can you provide the solution to this situation?

psprdbsvr:/home/oracle/dba/scripts/sqlt/run> more sqltxecute2.log

SQL>SET TERM ON ECHO OFF;

To monitor progress, login into another session and execute:

SQL> SELECT * FROM SQLTXADMIN.sqlt$_log_v;

... collecting diagnostics details, please wait ...

In case of a disconnect review log file in current directory

If running as SYS in 12c make sure to review sqlt_instructions.html first

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