Re: dba_tab_mod view
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 14 May 2015 07:18:56 -0700
Message-ID: <1431613136.4660.YahooMailBasic_at_web184804.mail.gq1.yahoo.com>
> even if you set the monitoring off for the tables, it will be
> ignored from 10g onwards and the update stats will be collected
Date: Thu, 14 May 2015 07:18:56 -0700
Message-ID: <1431613136.4660.YahooMailBasic_at_web184804.mail.gq1.yahoo.com>
> even if you set the monitoring off for the tables, it will be
> ignored from 10g onwards and the update stats will be collected
From 10g on, monitoring and nomonitoring are always ignored. SQL Reference doesn't have it. Dbms_metadata.get_ddl doesn't show it either. Regular tables always have monitoring on and global temporary tables always have it off. If you use alter system (not alter session) to set statistics_level to basic, or more precisely, _dml_monitoring_enabled to false, all monitoring is off.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 14 2015 - 16:18:56 CEST