RE: Veritas

Hi Steve,

I completely agree with using standard file sizes. (Even when using UFS?) So would someone like to suggest standard file sizes? Last time I went raw I used sizes of 128MB, 1GB, and 8GB (adding 64K or 128K for overhead) and it worked just fine.

Regarding raw vs. QuickIO... By using standard file sizes with a good volume manager and having the ability to easily move and backup raw datafiles, are there any remaining objections to using raw? I believe this addresses all the "disadvantages" discussed in the Oracle paper titled, "Making the decision to use raw devices:" Note:29676.1. FYI, here's a couple more Metalink notes:
- 20 questions on raw devices: Note:37914.1 - How to implement raw devices: Note:23037.1

Also, regarding Veritas performance vs. raw... http://eval.veritas.com/webfiles/docs/dbed_2-1_perf.pdf

Steve Orr

-----Original Message-----
Sent: Tuesday, April 03, 2001 12:49 AM
To: Steve Orr; Multiple recipients of list ORACLE-L

Hi Steve,

With a volume manager, increasing the size of a raw partition is easy.

(Not that I endorse the idea of changing the sizes of datafiles. On the contrary, I am of the opinion that all datafiles should be uniformly sized. See
http://www.ixora.com.au/tips/creation/datafiles.htm for my thoughts on that.)

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Tuesday, 3 April 2001 5:01
To: Multiple recipients of list ORACLE-L

Regarding QuickIO performance...
I use QuickIO and it's great but I don't believe it is faster than raw. I've seen performance comparisons on a few websites but don't remember the links. I believe Steve Adam's website has some details on QuickIO performance vs. raw.

Regarding QuickIO ease of management...
Just like raw, you have to pre-allocate storage but instead of a raw partition pre-allocation is to a file via the "qiomkfile" command. Just like raw you cannot have any database files with autoextend. Just like raw you still have to define and maintain symbolic links. Unlike raw it's relatively easy to increase the pre-allocated size of a QuickIO file.

HTH,
Steve Orr

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Orr
  INET: sorr_at_arzoo.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).