DBMS_XPLAN.DISPLAY_CURSOR Gives Unexpected Results when Last Executed SQL Statement is Expected
(Doc ID 1684511.1)
Last updated on JULY 16, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
- Executing the function DBMS_XPLAN.DISPLAY_CURSOR returns an execution plan for an entirely different statement than the last executed SQL statement
- SERVEROUTPUT is set ON, Displayed statement is : DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES)
Statement auditing has been enabled, Displayed statement is : insert into system.aud$ (sessionid, entryid, ...
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document