| 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
The "normally...false" thing is old-fashioned thinking that hasn't yet
made its exit from Oracle's documentation. Unless your system was built
in the 1980s, timed_statistics should be set permanently to true, as it
is in the default parameter set for Oracle version 9.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 4/6 Seattle, 5/7 Dallas, 5/18 New Jersey
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Surendra.Tirumala_at_ky.gov
Sent: Friday, April 02, 2004 8:39 AM
To: oracle-l_at_freelists.org
Subject: 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
 |
 |