My Oracle Support Banner

"SET AUTOTRACE ON" Not Showing Executing Plan. Error: cannot fetch plan for statement_id 'PLUS5443586' (Doc ID 1321211.1)

Last updated on AUGUST 04, 2018

Applies to:

SQL*Plus - Version 11.2.0.2 and later
Oracle Server - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

When executing "alter session set current_schema" and then "set autotrace on" there is an error for the execution plan.

Example


SQL> set autotrace on

SQL> alter session set current_schema=USER1;

Session altered.

Elapsed: 00:00:00.01
SQL> select sysdate from dual;

SYSDATE
---------
04-MAY-11

Elapsed: 00:00:00.10

Execution Plan
----------------------------------------------------------
Error: cannot fetch plan for statement_id 'PLUS5233060'



Changes

Database was upgraded from 9i to 11g.  It was working fine in 9i.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.