Re: create table and create index monitor or nomonitor deprecated in 10g?
Date: Fri, 30 May 2008 09:17:59 -0700 (PDT)
In addition to what others said, here's what I wrote about statistics_level and the parameters controlled by it. Critique is welcome.
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.
> Date: Thu, 29 May 2008 14:21:41 -0700 (PDT)
> From: laura pena <lizzpenaorclgrp_at_yahoo.com>
> Subject: create table and create index monitor or nomonitor deprecated in
> Hey does anyone know if 10g has depreciated the monitor nomonitor options
> you create index or table?
> Looks like the default is to turn monitoring on in 10g. But I'm not sure.