| 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: TIMED_STATISTICS
In my opinion, any database which you think you'll ever need to tune =
needs to have timed_statistics=3DTRUE.
Without it, you simply do not hav enought information available to = effectively tune.
-Mark
-----Original Message-----
From: Surendra.Tirumala_at_ky.gov [mailto:Surendra.Tirumala_at_ky.gov]
Sent: Friday, April 02, 2004 9:27 AM
To: oracle-l_at_freelists.org
Subject: TIMED_STATISTICS=20
Hello All,
=20
I never had to set my timed_statistics to true in my present environment =
as
I never faced
any THE major performance problems. As I have everything else stabilized
with our migrations to
9203, I am planning to test setting this up in our test environment next
week.
=20
I would like to know your experiences with this.
Am I correct in assuming that majority of the critical systems run with =
this
parameter set to true?
=20
Thanks for your input.
=20
Surendra
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Apr 02 2004 - 08:29:48 CST
 |
 |