CBO Question - Is 'monitoring' used to calculate query plan?

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 8 Jan 2009 11:53:00 -0800
Message-ID: <bf46380901081153n1e926432q40ac33526a95d1ae_at_mail.gmail.com>

From the 9i SQL manual:


Specify MONITORING if you want Oracle to collect modification statistics on *table*. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. *They are available for use by the optimizer *or for analysis by the user.

I can't find such a reference for 10g or 11g.

Does anyone know definitively if that is still the case for newer versions of Oracle?

A link to such documentation would be useful if you have it handy.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Thu Jan 08 2009 - 13:53:00 CST

Original text of this message