Just my $0.02 worth...With the advent of Rman (thus making backups easy), and GUI volume managers and the fact with QIO requires manual intervention for things such as file extension/creation, I can't see what it gives you (beside a higher license fee) over raw devices.
hth connor --- "Aponte, Tony" <[EMAIL PROTECTED]> wrote: > Dennis, > > The benefits of QIO are realized not only by Oracle > but also by the storage administrators. Oracle > improvements come from kernelized async I/O, > elimination of UNIX double-buffering and > single-writer file header locking in the O/S. > Storage administrators gain from managing a cooked > file system. It enables many online tasks (like > provisioning for new storage on active file systems, > restriping on the fly, wholesale relocation of > databases) that are impossible or very painful and > error prone with raw partitions. My group has a > good relationship with UNIX SAs and we try help > whenever we can. > > However, it ain't a no-brainer. In pre-ODM > environments QIO files have to be pre-created on the > UNIX side before being added to the database, or the > file offlined and enabled for QIO after the fact. > It's a simple command line tool but it takes > planning and preparation plus adjustments to > existing procedures. Our biggest point of pain is > during recoveries. In the thick of things we keep > forgetting to pre-create the QIO files before > restoring datafiles to an alternate location. The > recoveries are successful but we pay a performance > penalty until we negotiate downtime to QIO-enable > the recovered files (which is really renaming the > data file and creating a link with a specific > pattern that triggers the code path for QIO > handling.) > > As for the speed claims coming from your > salesperson, all I can say is that we get pretty > close to raw speeds. I highly recommend it > especially for online redo logs, and it's easy to > revert to regular files if you change your mind. > > HTH > Tony Aponte > > -----Original Message----- > Sent: Friday, March 14, 2003 11:14 AM > To: Multiple recipients of list ORACLE-L > > > Is anyone using Veritas Quick I/O for Oracle? We are > purchasing some new > Solaris systems with fiber channel and Veritas File > System, and the Veritas > salesperson is claiming "up to 400 times faster". I > would like to know if > anyone else has discovered this miracle and what > benefits you are seeing. > Thanks. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
