High Disk I/O
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: High Disk I/O

  1. #1
    Join Date
    Apr 2003
    Location
    Delhi
    Posts
    51

    High Disk I/O

    Hi
    In our Production database we have high disk I/Os.
    Could somebody pls let me know how to avoid these?
    and where things should be checked in first place?
    regards
    nik
    regards
    nik

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well if you have high disk i/o you either have a very bad setup or you dont have enough disks / controllers

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    You could start looking at your top 10 SQL and drilling down the queries. Sometimes a performance index can help out tremendously.

    My apps have a download daemon that kicks off every 15 seconds, by adding one index we avoided a FTS when this runs. Compound this throughout the day and the savings is signifigant.


    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Apr 2003
    Location
    Delhi
    Posts
    51
    bad set up means Tablespace organization and all or bad queries?
    which one of these can be a major factor in this?
    thanx
    Chetan
    regards
    nik

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    The volume of physical i/o's is not affected by tablespace organization -- the duration of i/o waits might be though.

    SQL tuning sounds like the right answer here.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Nov 2001
    Posts
    335
    Do you have high % of IO utilization? Do you have number of Mb per sec read/write? If number mb read/write is low but % is high there could be problem either with disks/san setup or something else with hard disk.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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