| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Veritas Quick IO & Oracle Performance
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.
TIA, Ed
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). Received on Wed Jan 09 2002 - 16:37:55 CST
 |
 |