My Oracle Support Banner

Display_cursor(null,null,'allstats Last') Command With Statistics_level=all Does Not Display Buffer Information For SQL With Illogical Predicate (Doc ID 2333906.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [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.


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.