RE: TIMED_STATISTICS
- From: Surendra.Tirumala@xxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Apr 2004 10:36:33 -0500
Thank you Cary, Mladen and everyone!!!
-----Original Message-----
From: Cary Millsap [mailto:cary.millsap@xxxxxxxxxx]
Sent: Friday, April 02, 2004 10:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
- SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Surendra.Tirumala@xxxxxx
Sent: Friday, April 02, 2004 8:39 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: TIMED_STATISTICS
Thank you Mark!
The documentation also added to my confusion as it says.."Normally, it
should be false..."
===========================
TIMED_STATISTICS specifies whether or not statistics related to time are
collected.
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@xxxxxxxxxxxxxxx]
Sent: Friday, April 02, 2004 9:32 AM
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
