Executing the equivalent of
SELECT DBMS_SQLTUNE.report_tuning_task('SQL TASK') FROM dual
It produces the general information section; the SQL ID; the actual statement and then generates an Error Statement. ORA-00942 Table or View does not exist.
I trapped for the error and the trace attributed it to a select statement from SYS.DBA_PENDING_TRANSACTIONS. However, the user can select from that table.
SELECT DBMS_SQLTUNE.report_tuning_task('SQL TASK') FROM dual
It produces the general information section; the SQL ID; the actual statement and then generates an Error Statement. ORA-00942 Table or View does not exist.
I trapped for the error and the trace attributed it to a select statement from SYS.DBA_PENDING_TRANSACTIONS. However, the user can select from that table.
