sqlt: for 10.2 database - ORA-20404: sql with id "gp4kn8xm77c2j" was not found in memory nor in a
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