Sunday, January 17, 2010

Oracle and Informix I/O profiling - 1

This is an interesting subject in database and storage industry. Today number of I/O auto optimization techniques are evolving such as Oracle ASM at the database front and Dynamic/Thin provisioning at the storage front. Manual I/O designing and optimization for database are already a legacy subject?

Sometimes, we have to cope with the legacy. So I start listing the possible physical storage structure of Oracle and Informix.

Trick is the design of LUN (or volume)? Size, RAID level, Number of spindles … for different I/O profiles of database structures. Theory knowledge on database product and experience may come in handy here.



No comments:

Post a Comment