Re: oracle is causing high WIO

  • From: "Terry Sutton" <terrysutton@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Oct 2005 16:40:35 -0700

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@xxxxxxxxxxx> wrote:
    startup restrict and see what it is doing.
    ----- Original Message ----- 
    From: raja rao 
    To: raja4list@xxxxxxxxx ; 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.

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



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

Other related posts: