Re: oracle is causing high WIO

From: Terry Sutton <terrysutton_at_usa.net>
Date: Mon, 24 Oct 2005 16:40:35 -0700
Message-ID: <032701c5d8f4$7de7f2e0$6500a8c0@TerrySutton>

What are the top wait events in the database? As Jared said, the top SQL from a Statspack will tell you what SQL is performing high physical reads, but the top wait events will tell you just what Oracle is waiting on. If it's doing I/O, it's waiting on something.

--Terry

even after the startup restrict also the below is the WIO:

$ sar -u 2 5
SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005

  12:09:30    %usr    %sys    %wio   %idle
  12:09:32      11       6      64      19
  12:09:34      12       7      66      16
  12:09:36       4       1      90       6
  12:09:38       0       0      94       5
  12:09:40       0       0      90      10

CAN SOMEONE hlep me. we are stuck here on the production db.

Michael McMullen <ganstadba_at_hotmail.com> wrote: startup restrict and see what it is doing.

Original Message ----- From: raja rao To: raja4list_at_yahoo.com ; Michael McMullen ; oracle list Sent: Monday, October 24, 2005 12:10 PM Subject: oracle is causing high WIO

It seems the problem is with oracle.

Now when I shutdown the WIO is 0% AND when i start oracle, it is showing WIO as 80-90%

$ sar -u 2 4
SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005

    11:54:39 %usr %sys %wio %idle
    11:54:41 4 4 85 6
    11:54:43 1 2 83 14
    11:54:45 1 2 81 16
    11:54:47 2 2 82 13

how to find out why oracle is causing this high WIO ?

can someone help me

raja rao wrote:
Yes,

When the db was down, there was no change in WIO.

Means, the databse connections are not casing this high WIO.

--
http://www.freelists.org/webpage/oracle-l

Yahoo! FareChase - Search multiple travel sites in one click.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 24 2005 - 18:43:47 CDT