RE: statspack wait events

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Wed, 4 Feb 2004 14:53:32 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E96703E7D470@floexmailbe2.ffci.com>

Hi Raghu,

Before you spend too much time chasing this, ensure that your wait time is a significant amount of total response time. Otherwise you may be chasing down something that is ~1% of your total response time. =20

Look in your statspack report at "total wait time","service time" and "response time", below the Top 5 Wait Events. If total wait time is a small percentage of response time, you're safe forgetting it and making a mental note to keep an eye on it.=20

Personally I have bigger fish to fry than to chase down wait events that just aren't worth my time.=20

Lisa Koivu
Senior Monkey and man, am I craving sugar Orlando, FL, USA

-----Original Message-----
From: Raghu Kota (WBTQ) [mailto:RKota_at_WestonBakeries.com]=20 Sent: Wednesday, February 04, 2004 2:26 PM To: oracle-l_at_freelists.org
Subject: statspack wait events

Hi Friends,

I have concern regarding wait events got from statspack, So dilemma is =
=3D

what action I need to take now?? Any ideas will appreciated. My =3D environment is oracle8174 on AIX51.

Top 5 Wait Events

~~~~~~~~~~~~~~~~~                                             Wait     %

=3D

Total

Event                                               Waits  Time (cs)   =

=3D

Wt Time

-------------------------------------------- ------------ ------------ =

=3D

db file sequential read                           145,479       20,055

=3D

49.21

log file sync                                       4,549        6,466

=3D

15.87

db file parallel write                                252        5,134

=3D

12.60

log file parallel write                             4,560        4,784

=3D

11.74

control file parallel write                           326        2,165

=3D

5.31

Thanks again
Raghu.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission.  By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 04 2004 - 13:53:32 CST