Home » RDBMS Server » Server Administration » db_block_size (oracle 10g,solaris)
db_block_size [message #338716] Tue, 05 August 2008 15:48 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

doc says db block size should me multiple size of os block size.

can anybody explain me the concept of setting database block size db_block_size to multiple of os block size in detail ?


Thanks in advance
Regards,
Balaji
Re: db_block_size [message #338717 is a reply to message #338716] Tue, 05 August 2008 16:02 Go to previous messageGo to next message
BlackSwan
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
2*OS_BLOCK_SIZE=DB_BLOCK_SIZE
4*OS_BLOCK_SIZE=DB_BLOCK_SIZE
8*OS_BLOCK_SIZE=DB_BLOCK_SIZE

Basic elementary school multiplication!
Re: db_block_size [message #338819 is a reply to message #338716] Wed, 06 August 2008 00:58 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Documentation told such because, thought oracle uses db_block_size to treat and work with data at its lowest granularity (i.e. block), but utlimately the data are stored on harddisk in the form of os blocks and whenever, oracle tries to read specific datablock, all the os level block consisting of that datablock are read..
That is why, oracle recommends that db block size should be multiple of os blocks..

Regards,
Dipali..

[Updated on: Wed, 06 August 2008 00:59]

Report message to a moderator

Previous Topic: oracle10g sys user password
Next Topic: Oracle installation
Goto Forum:
  


Current Time: Sat Aug 19 06:28:42 CDT 2017

Total time taken to generate the page: 0.09024 seconds