Re: Oracle/Veritas File System

On Wed, 12 Jun 2002 21:24:48 +0100, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>I'm not a good one to ask since I'm a great fan of raw. In terms of
>'raw is not an option', you still have to do some preliminary work with
>a QIO file, so its not really much different.
>

Actually, it's quite easy..
create file system (vxfs(.. create qio file.. (superfast) add it to tablespace.. (probable same speed as craete datafile.. takes about a min+ for 1GB).
the bitch about qiofiles, they cannot be resized downwards.

>The one strong for argument for QIO (at the place I was using it) was
>that they had some largish machines (in terms of memory) and 32-bit
>oracle. Using QIO (actually "Cached QIO" allowed use of more of the ram
>- an advantage that 64bit Oracle would/should obviate. And yes - it
>outperformed the original vxfs files that were originally in use
>significantly
>

Never experience SGA's beyond 4 GB's, which was/is possible w/ some recompile of oracle.

>The strong argument against QIO - is that raw devices are free :-)

I don't remember what we paid for their license, but support isn't that expensive. Their support is actually more helpful than any other (i also deal w/ oracle and sun).
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Jun 12 2002 - 15:41:06 CDT