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
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
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
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member

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..


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

Report message to a moderator

Previous Topic: DBMS Scheduler error
Next Topic: Max Role problem(ORA-28031: maximum of 148 enabled roles exceeded)
Goto Forum:

Current Time: Tue Oct 25 02:33:40 CDT 2016

Total time taken to generate the page: 0.13010 seconds