Re: Disable monitoring without disabling advisories

If you lock the statistics of the table , then monitoring would not be effective.
I have done this for few of my tables with volatile data. you can refer the ASK TOM site for some useful discussion on this subject.

Thanks
Ajeet

On 6/21/07, Rajesh.Rao_at_jpmchase.com <Rajesh.Rao_at_jpmchase.com> wrote:
>
>
> 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.
>

-- 
Ajeet
Oracle DBA ,India

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