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: [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).
