Re: dba_tab_mod view
- From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "yong321@xxxxxxxxx" for DMARC)
- To: veeeraman@xxxxxxxxx
- Date: Thu, 14 May 2015 07:18:56 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
