Re: create table and create index monitor or nomonitor deprecated in 10g?

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 30 May 2008 10:22:18 -0700
Message-ID: <bf46380805301022v1171bca3oe2c15940d8898eed@mail.gmail.com>


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 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 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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 30 2008 - 12:22:18 CDT

Original text of this message