Re: DML Monitoring not working for table.

  • From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "yong321" for DMARC)
  • To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Aug 2019 03:41:49 +0000 (UTC)

For couple of tables in one of 11.1.0.7 database, DML monitoring is not 
working
...
_dml_monitoring_enabled                            TRUE
    enable modification monitoring

Rakesh,

Is statistics_level set to basic by any chance? If it is, even if 
_dml_monitoring_enabled is set to true, DML monitoring may not work in your 
version, maybe due to a bug.

Yong Huang
--
//www.freelists.org/webpage/oracle-l


Other related posts: