RE: Disable monitoring without disabling advisories
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: <Rajesh.Rao@xxxxxxxxxxxx>
- Date: Thu, 21 Jun 2007 13:12:24 -0500
You could just turn off the dbms_scheduler job that computes the
statistics. It is called GATHER_STATS_JOB.
Pat
________________________________
From: Rajesh.Rao@xxxxxxxxxxxx [mailto:Rajesh.Rao@xxxxxxxxxxxx]
Sent: Thursday, June 21, 2007 1:03 PM
To: Elliott, Patrick
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx>
06/21/2007 01:41 PM
To: <Rajesh.Rao@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Rajesh.Rao@xxxxxxxxxxxx
Sent: Thursday, June 21, 2007 12:02 PM
To: oracle-l@xxxxxxxxxxxxx
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.
___________________________________________________________________________________________________
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
Other related posts:
