RE: system event waits

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" <ORACLE-L_at_fatcity.com> 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: john.kanagaraj_at_hds.com
>
> 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: ListGuru_at_fatcity.com (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: big_planet_2000_at_hotmail.com

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: ListGuru_at_fatcity.com (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: cary.millsap_at_hotsos.com

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: ListGuru_at_fatcity.com (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).