Re: DML Monitoring not working for table.
From: Yong Huang <"Yong>
Date: Fri, 2 Aug 2019 03:41:49 +0000 (UTC)
Message-ID: <1112134871.40561.1564717309748_at_mail.yahoo.com>
> For couple of tables in one of 11.1.0.7 database, DML monitoring is not working
...
> _dml_monitoring_enabled TRUE
> enable modification monitoring
Date: Fri, 2 Aug 2019 03:41:49 +0000 (UTC)
Message-ID: <1112134871.40561.1564717309748_at_mail.yahoo.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 02 2019 - 05:41:49 CEST