RE: TIMED_STATISTICS

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Apr 2004 09:32:15 -0500

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@xxxxxx [mailto:Surendra.Tirumala@xxxxxx]
Sent: Friday, April 02, 2004 9:27 AM
To: oracle-l@xxxxxxxxxxxxx
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

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: