| 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
Thank you Mark!
The documentation also added to my confusion as it says.."Normally, it
should be false..."
Values:
true
The statistics are collected and stored in trace files or displayed in the V$SESSTATS and V$SYSSTATS dynamic performance views.
false
The value of all time-related statistics is set to zero. This setting lets Oracle avoid the overhead of requesting the time from the operating system. Normally, TIMED_STATISTICS should be false.
On some systems with very fast timer access, Oracle might enable timing even if this parameter is set to false. On these systems, setting the parameter to true can sometimes produce more accurate statistics for long-running operations.
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
Sent: Friday, April 02, 2004 9:32 AM
To: oracle-l_at_freelists.org
Subject: 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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |