High I/O
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: High I/O

  1. #1
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    24

    High I/O

    Hi All:

    We have 4 similar databases (8.1.7.4) on 4 different Sun Enterprise 3500 with Solaris 8. All these servers have same number of disks and all the data files are spread across the multiple disks. We have same number of users on all 4 databases and I can not say the database access is same but almost.

    All the servers are on the same patch level OS wise. Same patch level Database wise. We used to have same amount of I/O on all the databases and we started having high I/O on one devise (A1000) in One server. On this devise we do not have other files except oracle datafiles. For sure we did not install any patches on the server. Verified all the objects, All the objects are valid and were analyzed.

    Is there a way that I can find which process is causing this high I/O. We do not have anything else other than the OS and the Oracle Database on these servers.

    Few other questions...

    1) What can cause High I/O on devise,....Can a Corrupted Datafile?..
    I have verified the datafiles with DBV, None of the datafiles have any problem.

    2) Is there a way to find which process is causing this high I/O through a UNIX command?

    3) If I rebuild all Indexes Will that help?

    Thanks in Advance,
    vbadba.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look at v$filestat to find out which files have the most I/O. Then figure out which objects are in that datafile. From there, you should have a clue as to WHAT and WHO and you can analyze this person's session to find out WHY.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    24
    Hi Jeff:

    I have only one user for my database and I do know Which data file is having high I/O but How can I find which process is causing that High I/O.

    Thanks,
    vbadba

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    Look at v$filestat to find out which files have the most I/O. Then figure out which objects are in that datafile. From there, you should have a clue as to WHAT and WHO and you can analyze this person's session to find out WHY.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    24
    Hi Jeff:

    For my database I have only one user but There are about 500 users to the my application using the same database ligoin.

    Thanks,
    vbadba

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I'm happy for you. The WHO is not as important as WHAT and WHERE. Find out WHAT file is being hit the hardest that is assigned to your mount point and then find out WHAT tables are assigned to that file.

    BTW, have you verified that the physical device is OK? Like maybe a bad disk in a RAID 5 set?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    24
    Hi Jeff:

    Initially Sun thought we have a Bad controller (They gave me Guds script which collects Performance statistics with the result they concluded it is a bad controller) and they replaced the controller twice after our problem. Now Sun is saying it is not a Controller problem anymore. The devise having High I/O is Sun A1000 and is RAID 5. My application is read intensive. And All the disks are good.

    I have 11 tables and related indexes on this devise, Is there a way that I can find Which object is causing this high I/O? and Can a corrupted object cause high I/O

    Thanks for your time.

    Thanks,
    vbadba

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    Look at v$filestat to find out which files have the most I/O. Then figure out which objects are in that datafile. From there, you should have a clue as to WHAT and WHO and you can analyze this person's session to find out WHY.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    24
    Hi Jeff:

    Could you please give some more info on that please.

    Thanks,
    vbadba

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width