Re: newfs suggestions for Oracle filesystem

• Steve Rospo <srospo_at_watchmark.com>

>
> Any suggestions for newfs parameters for a file system that will be
> dedicated to Oracle data files? It will be a large file system with very
> few files of very large (2GB) size. I've been using the following with
> good results but I'm wondering if anyone has any suggestions.
>
> newfs -v -C 64 -c 229 -f 8192 -i 65536 -r 10000 /dev/dsk/cWtXdYsZ
> tunefs -a 128 -e 1048576 -m 0 -o time /newfilesystem
>
> Details:
> Solaris 2.8
> Oracle 8.1.7.1 EE
> 16k db block size
> 8k operating block size

Check if you can change the portion of a cyl group that one file can use from the default to 100%. This will keep the files a bit more contiguous.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.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).