Running tunefs on Solaris with Oracle

From: <Brian_P_MacLean_at_eFunds.Com>
Date: Mon, 15 Apr 2002 11:23:32 -0800
Message-ID: <F001.00444AAA.20020415112332@fatcity.com>

OS: Solaris, 2.7
Oracle: v8.1.7

Anyone mess around with tuning file systems to be optimized for Oracle with the "tunefs" command. I've messed with the "-m minfree" parameter before but that is a usable/free space issue, not really a performance issue. I'm looking at the "-e maxbpg" parameter now. The last line of the man pages reads "For file systems with exclusively large files, this parameter should be set higher". Google, IXORA, Metalink, and Sun searches didn't turn up anything

Opinions, links, experiences .... Anyone?

The man page reads as follows:

     -e maxbpg Indicate the maximum number of blocks  any  single
               file  can  allocate out of a cylinder group before
               it is  forced  to  begin  allocating  blocks  from
               another  cylinder  group.  Typically this value is
               set to approximately  one  quarter  of  the  total
               blocks  in  a  cylinder  group.  The  intent is to
               prevent any single file  from  using  up  all  the
               blocks  in a single cylinder group, thus degrading
               access times for all files subsequently  allocated
               in  that  cylinder group. The effect of this limit
               is to cause big files to do long seeks  more  fre-
               quently  than if they were allowed to allocate all
               the blocks in  a  cylinder  group  before  seeking
               elsewhere. For file systems with exclusively large
               files, this parameter should be set higher.

TIA Brian P. MacLean
Oracle DBA, OCP8i

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Brian_P_MacLean_at_eFunds.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). Received on Mon Apr 15 2002 - 14:23:32 CDT