[Oracle-l] create table and create index monitor or nomonitor deprecated in 10g?

At 11:22 AM 5/30/2008, Jared Still wrote:
On Fri, May 30, 2008 at 9:17 AM, Yong Huang
<yong321_at_yahoo.com> wrote:
Modification Monitoring: _dml_monitoring_enabled
This 10g param allows you to do what you used to
be able to do in 9i with alter
table (no)monitoring, but not at table level any more; it's system wide either
all monitoring or all nomonitoring. But I think it¡¯s still better to disable
this parameter and leave statistics_level to typical than set statistics_level
to basic when you want to disable table monitoring. Documentation writers must
have a dilemma, though; they probably wish the first underscore were dropped.


There's at least one exception.

If you are stuck on <http://10.2.0.2>10.2.0.2
(not allowed to upgrade) then you best not
use ASMM, and have statistics_level = basic, as well as db_cache_advice=off.

While benchmarking a <http://10.2.0.2>10.2.0.2
database a nasty performance bug appeared.

See ML 5918631.8 and 3452409.8 regarding waits on 'simulator lru latch'




--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist