Display_cursor(null,null,'allstats Last') Command With Statistics_level=all Does Not Display Buffer Information For SQL With Illogical Predicate
Last updated on DECEMBER 06, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 12.2]
Information in this document applies to any platform.
The purpose of the document is to explain the situation of the incomplete display of display_cursor with Statistics_level=all.
The DBMS_XPLAN.DISPLAY_CURSOR is important for the diagnostic of SQL performance, and it will provide useful information.
But sometimes the output command is not complete, why? The reason is the SQL with illogical predicate, as the following example testcase shows.
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