DBMS_XPLAN.DISPLAY_CURSOR Gives Unexpected Results when Last Executed SQL Statement is Expected
Last updated on MARCH 29, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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, ...
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms