RE: Disable monitoring without disabling advisories
- From: Rajesh.Rao@xxxxxxxxxxxx
- To: Robert Freeman <robertgfreeman@xxxxxxxxx>
- Date: Thu, 21 Jun 2007 16:18:34 -0400
I had similar thought many years ago, when I brought a few Rampant press
books :))
Robert Freeman <robertgfreeman@xxxxxxxxx>
06/21/2007 04:11 PM
To: Rajesh.Rao@xxxxxxxxxxxx, "Elliott, Patrick"
<patrick.elliott@xxxxxxxxxxxxx>
cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Disable monitoring without disabling advisories
Just one more reason that I wonder why I bank at
JPMChase.... :)
RF
--- Rajesh.Rao@xxxxxxxxxxxx wrote:
> 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.
Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)
Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)
Other related posts: