RE: Disable monitoring without disabling advisories

I've never tried it, or even read anything about it, but I just searched the hidden parameters for "monitor" and came up with this one:  

_dml_monitoring_enabled
 

Its description is "enable modification monitoring" and it defaults to TRUE on my 10.2.0.2 system. Maybe if you set this to FALSE that will do the trick? Let us know how the testing goes.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rajesh.Rao_at_jpmchase.com

Oracle 10gR2. Is there a way to disable the table monitoring, without setting statistics_level to BASIC and losing the advisories? Looks like this cannot be done from what I have read so far.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l