Re: Block Size Question

No - you have to export, rebuild the database with the new paramater, and import.
No other way around it. Can be time consuming depending.

• Dc.

Alan Russell wrote:

> If a database is already set to use 2K blocks is it just a matter of
> changing the block size parameter in the init.ora
> to the larger size?
>
> markp7832_at_my-deja.com wrote in message <7m4thm$abh$1_at_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 Mon Jul 12 1999 - 16:14:38 CDT