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" <AponteT_at_hsn.net> 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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Wed Mar 26 2003 - 20:28:38 CST