DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: i/o intensive oracle database

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    i/o intensive oracle database

    what exactly do you look for when determining if a database is i/o intensive? need help getting a better understand of what i/o basically means etc thanks!

  2. #2
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    5
    Hi...

    I/O Intensive means, the Read Write process of the Oracle Datafiles in HDD, you can monitor this activity by using OS utility, if it is in Unix u can use IOSTAT, find out which HDD is having IO process, then look at the contents of the hdd, after that you can try to spread the contents to another HDD to give load ballancing and faster response to the application, this is part of The Oracle Performance Tuning...

    TIA
    Jeram
    Oracle DBA

  3. #3
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    For Datafile I/O Statistics, you can refer V$FILESTAT joined with V$DATAFILE. Columns from v$filestat useful are phyrds (No of physical reads done), phywrts (No of physical writes done) After startup of database.
    This is vast topic to discuss, you can mainly concentrate on full table scans. You can create index after checking full table scans, and reduce # of full table scans, depends on your application type (DSS or OLTP).

    Have a nice time,

    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: i/o intensive oracle database

    Originally posted by imose
    what exactly do you look for when determining if a database is i/o intensive? need help getting a better understand of what i/o basically means etc thanks!
    I stands for input, it is you write opertation.
    O stands for out put, it stands for read operations.

    IO can be disk IO or memory IO.

    And database itself is not IO intensive its the application thats IO intensive. So look at your application if you see that lots of IO is taking place.

    Read some Tuning Manuals.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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