| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Disable monitoring without disabling advisories
You could just turn off the dbms_scheduler job that computes the statistics. It is called GATHER_STATS_JOB.
Pat
From: Rajesh.Rao_at_jpmchase.com [mailto:Rajesh.Rao_at_jpmchase.com]
Sent: Thursday, June 21, 2007 1:03 PM
To: Elliott, Patrick
Cc: oracle-l_at_freelists.org
Subject: RE: Disable monitoring without disabling advisories
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.
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.
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 21 2007 - 13:12:24 CDT
 |
 |