Re: Veritas Database Edition 2.0 for Oracle?

'high traffic website' is not really consistent with '5 x 9Gb discs'.

I would be quite surprised if the Veritas Databse Edition helped. Use the money to buy more (smaller) discs.

Without details of the set-up it would be pointless to offer configuration advice. However check (probably through v$filestats with timed_statisticsset to true) what your I/O response time is and how well balanced it is. (see also the redo write time in v$sysstat).

In the short term your best bet may be to use fine-grain striping (in the order of 64K per disc) to randomise the I/O as much as possible. Raw/LVM volumes are better than file system; but if using file system then a larger number of smaller files may be better than a small number of large files.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

jrb_6502_at_my-dejanews.com wrote in message <7fiteh$hto$1_at_nnrp1.dejanews.com>...
>I'm running Oracle 7.3.4 on an Enterprise 450, Solaris 2.6, 4 CPU, 4 GB
RAM,
>5 * 9 GB drives (no RAID). This box serves as the back end for a high
traffic
>web site.
>
>I'm investigating installing Veritas Database Edition 2.0 for Oracle would
>improve database performance.
>
>Has anyone used this particular product? Was it worth the money? Any
gotchas?
>
>Would reconfiguring the existing disk setup/adding physical disks/moving to
>RAID yield better bang for the buck?
Received on Tue Apr 20 1999 - 17:19:44 CDT