Re: dba_tab_mod view

From: Yong Huang <>
Date: Thu, 14 May 2015 07:18:56 -0700
Message-ID: <>

> 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

Received on Thu May 14 2015 - 16:18:56 CEST

Original text of this message