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 -----------------------------------------------------------------