In this post, you’ll learn more about the Oracle ErrorORA-13781: cannot perform test-execute and explain plan operations on the automatic SQL tuning task with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-13781: cannot perform test-execute and explain plan operations on the automatic SQL tuning task
Reason for the Error ORA-13781: cannot perform test-execute and explain plan operations on the automatic SQL tuning task
The user attempted to test-execute or generate explain plans for a SQL workload using the automatic SQL tuning task.
How to fix the Error ORA-13781: cannot perform test-execute and explain plan operations on the automatic SQL tuning task ?
You can fix this error in Oracle by following the below steps
Verify the name of the tuning task and retry the operation.