Re: Veritas Quick IO & Oracle Performance

Ed,

I would be interested in getting a copy of your test scripts to try it out on our setup. Solaris 8, veritas DBed 2.2 and Oracle 8.1.7.

Our performance has increased since switching to quick io, but that also included a major application overhaul, and new disk layout and an upgrade to 8.1.7.

Of course numerous factors come into play with these tests: Disk layout,whether the tables are analyzed, how the sql looked,hardware...etc.

As far as issues with quickio, some that I can think of are to make sure to size your datafiles properly because auto-extend doesn't work(if you use the whole file). And There are some gotchas if you use RMAN for backups (I don't,tar works fine for quickio files). So far, no problems here.

-Brian

On Wed, 9 Jan 2002, Ed Bittel wrote:
>I was asked to evaluate the potential benefit of using
>Veritas Quick I/O
>for one of our databases. I put together some simple
>tests to gauge the
>expected impact of Veritas Quick I/O on Oracle
>performance. The tests
>were designed so that the only variable when running
>the test scripts
>was type of datafile the scripts were reading from or
>writing to (i.e.,
>Quick I/O or non-Quick I/O).
>
>The results of the tests were very surprising. Only
>the performance of
>large DDL operations, such as copying tables and
>creating indexes, was
>significantly improved after implementing Veritas
>Quick I/O for an
>Oracle datafile. Performance of DML operations ranged
>from marginally
>improved to markedly worse after implementing Veritas
>Quick I/O for an
>Oracle datafile. Large selects were particularly poor
>performing with
>Quick IO.
>
>Are these results typical? Are there any issue I
>should be aware of?
>
>We're running Oracle 8.1.6.3 on Solaris with Veritas
>Database Edition
>for Oracle 2.1.1.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Haas
  INET: bhaas_at_musiciansfriend.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).