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 Sat Jul 10 1999 - 00:23:57 CDT
