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: [EMAIL PROTECTED]
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: [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).