1. If you have bug 1210242, then using timed_statistics=true will have a profound impact upon performance. Get a patch, and then go to 3.
2. If you use an HP-UX release older than release 10, then using timed_statistics=true will have a profound impact upon performance. Upgrade HP-UX, and then go to 3. 3. Otherwise, set timed_statistics=true at the instance level, and leave it set that way forever. In your first hour of using timing data, you will probably recover more system capacity than the timer mechanism will consume in a year. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -----Original Message----- Sent: Monday, July 01, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Do you guys think making times statistic =true has any performance impact . Are there any other considerations ? -Bp ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 12:53 PM > > Depending on the version of the database, timed_statistics > > may be dynamic > > and > > not require a database bounce. > > True - but the timing values are meaningless unless the counters > (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the > counters and switches on timing at the same time.... I wouldn't recommend > using the time values otherwise. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Want to know about a carpenter who built a bridge with two sticks and three > nails? Write me for details! > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
