newfs suggestions for Oracle filesystem
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 1 /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 S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: newfs suggestions for Oracle filesystem
-- Steve Rospo [EMAIL PROTECTED] 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 1 /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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: newfs suggestions for Oracle filesystem
You probably don't need 64k of inodes for a FS dedicated to database files. Check out *the* Solaris tuning book, plenty of info there that will answer all of your Solaris tuning questions. http://www.powells.com/cgi-bin/biblio?inkey=4-0130952494-0 Jared On Saturday 26 January 2002 03:40, Steve Rospo wrote: 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 1 /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 S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).