| db_block_size [message #338716] |
Tue, 05 August 2008 15:48  |
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 #338819 is a reply to message #338716] |
Wed, 06 August 2008 00:58  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
