Systems Engineering and RDBMS

Autotrace enhancement in 10gR2

Posted by decipherinfosys on March 30, 2007

In 10gR2, autotrace uses DBMS_XPLAN to display the explain plans.  In prior versions, one had to use the DBMX_XPLAN packae to get the same output.  This gives much more detailed information to the end users – especially important is the addition of the predicates at the bottom of the plan which clearly show the step at which Oracle’s optimizer is applying them.

Sorry, the comment form is closed at this time.

%d bloggers like this: