Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Block Size Question

Re: Block Size Question

From: <markp7832_at_my-deja.com>
Date: Fri, 09 Jul 1999 13:30:29 GMT
Message-ID: <7m4thm$abh$1@nnrp1.deja.com>


My experience agrees that even an OLTP should use 8K as the Oracle block size; the exception would be if your machine is already memory constrained then you could be better off sticking with 4K, but 2K is too small.

In article <3784A3CA.638E_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> g.renfrew_at_acca.org.uk wrote:
> >
> > Hi All,
> >
> > I've a question about the db_block_size param.
> >
> > Running 7323 on Solaris 2.6.
> >
> > Solaris 2.6 NFS block size is 8K (as returned by the command "echo
:sb
> > | fsdb /dev/md/dsk/d50 | grep \^bsize | cut -f2"). Assuming this is
> > correct, should my default DB_BLOCK_SIZE be 8K also?
> >
> > I have created a database from scratch on this machine, with the
> > db_block_size param not set - so I expected the size default to 8K.
> > However, after some simple calculations on bytes / blocks on
> > dba_segments I get the db_block_size to be 2K.
> >
> > This tells me either my method of working out the Solaris
block_size is
> > way off or something somewhere is setting the db_block_size to be
other
> > than the default.
> >
> > Are my calculations correct, or am I working out the FS block size
> > incorrectly.
> >
> > Thanks
> >
> > Graeme Renfrew
> > DBA
> > ACCA Glasgow, UK
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> I think it defaults to 2k on most Solaris versions....
>
> ...but I am pretty sure that 8k is the preferred...
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
>

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 08:30:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US