Thanks Stephen,
I am steering the dev team towards 100% compute statistics (once) and then set-up automated jobs to collect when stats become stale. To do this I need to enable monitoring (to decide on staleness). This is a heavy OLTP system running in RAC ...
Initially we will test this in the dev environment, but that is RAC too..
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
From: Stephen Andert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 4:28 PM
To: Jamadagni, Rajendra; [EMAIL PROTECTED]
Subject: Re: Alter table monitoring ... impact on performance??
I don't know about 9, but we've been using it on 8.1.7.3 for over 6
months and have not noticed any negatives.
Good luck and let us know what you find out. We're planning a move to
9 this year.
Stephen
>>> [EMAIL PROTECTED] 01/16/03 01:50PM >>>
Does any one know the performance impact on 'alter table monitoring'
??
(this is for Oracle 9202) Should we expect any slowness ??
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
