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!
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...
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,
Catch me online at Yahoo: ddpatel256
Click Here to Expand Forum to Full Width