DB_BLOCK_SIZE [message #74255] |
Sat, 23 October 2004 02:44 |
Kishor
Messages: 11 Registered: February 2003
|
Junior Member |
|
|
Hi Guru
I wanted to know what is the relation between DB_BLOCK_SIZE and os block size ,also what is ratio of
DB_BLOCK_SIZE ,what if it is equal,greater,lesser than os
block size . Hoow to know os block size.
|
|
|
Re: DB_BLOCK_SIZE [message #74259 is a reply to message #74255] |
Mon, 25 October 2004 03:49 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Docs say
[i]
set DB_BLOCK_SIZE multiple to OS block size but it should not exceed the maximum size of OS I/O buffer.
[/i]
why?
db_block_size helps with database I/O.
Operating system block size helps with OS I/O
so if OS Block size = 8k
and Database block = 4k
for every 2 database calls, One OS block is used.
if osblock=8 and dbblock= 16
then
for every database call, 2 osblocks are used.
and db_block_size should be based on nature of the database.
for OLTP system use smaller blocks
for DSS /warehouse use larger blocks.
>>Hoow to know os block size?
depends on your Operating system.
in solaris i would use
bash-2.03$ df -g | grep "block size"
/ (/dev/dsk/c0t0d0s0 ): 8192 block size 1024 frag size
/proc (/proc ): 512 block size 512 frag size
/dev/fd (fd ): 1024 block size 1024 frag size
/etc/mnttab (mnttab ): 512 block size 512 frag size
/var/run (swap ): 8192 block size 8192 frag size
/tmp (swap ): 8192 block size 8192 frag size
|
|
|