RE: Disable monitoring without disabling advisories

From: <Rajesh.Rao_at_jpmchase.com>
Date: Thu, 21 Jun 2007 14:02:42 -0400
Message-ID: <OFC3A747BA.4D4EE883-ON85257301.00625858-85257301.00632004@jpmchase.com>

The application does not make any bulk DML's or nothing that should change the execution plans. The weekly analyze job will analyze all the objects, and not just stale or objects with no stats. Dont ask me why, but the requirement is to simulate 9i behaviour, even after migration to 10g.

Need to investigate usage of _dml_monitoring_enabled as suggested by Allen.

Regards
Raj

"Elliott, Patrick" <patrick.elliott_at_medtronic.com> 06/21/2007 01:41 PM  

        To:     <Rajesh.Rao_at_jpmchase.com>, <oracle-l_at_freelists.org>
        cc: 
        Subject:        RE: Disable monitoring without disabling advisories

It would be better to just freeze the statistics on the tables that you don't want to change. I wouldn't turn of monitoring altogether.  

Pat  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rajesh.Rao_at_jpmchase.com Sent: Thursday, June 21, 2007 12:02 PM
To: oracle-l_at_freelists.org
Subject: Disable monitoring without disabling advisories

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.

Regards
Raj

This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Please refer to http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK legal entities.

---

CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

---

This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates.

This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

Please refer to http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK legal entities.

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

Received on Thu Jun 21 2007 - 13:02:42 CDT