i am a new DBA. how to arrive at the block size( ie 2k or 4k or 8k or 16k).
what factor(s) is/are used to deceid this block size. can anyone help me out to find
Somebody may lecture on this for hours. The healine is: use 8K if you do not run DSS in which case 16K.
1. Type of application
If DSS: Large block size: 16/32
If OLTP: Small 4/8
If Hybrid: Compromise.
2. Type of data
If many rows of LOBs type data, bigger block size would be required to hold the rows so that chaining does'nt occur.
3. Hard disks and other system resorces available.
4. Many other considerations, I suppose.
My block size is 2K.
If I want to change it I will need to recreate the whole database.
Make sure you do your research and get the correct block size before you create the database. Doing this now will save you time and effort, always .
Deciding where to put tablespaces and what the default storage parameters might be is useful b4 DB creation as well.
In DBVERIFY you don't have to specify your block size, wasn't the default 2K :-)
Yeah yeah, but it was already 2K when I arrived and they dont want me to 'fix' it
Go for 32K block size if your system supports even if the system is OLTP. There are a number of benefits having a bigger db_block_size.
1 More Rows will be stored in a block.
2 Reduction in I/O
3 Free space for update is reduced.
4 Elimination of free list contention.
So you guys definetly think I should convince this company to increase the block size to 8K?
migrate to 9i and you can have your multiple db block sizes
Originally posted by tamilselvan
Go for 32K block size if your system supports even if the system is OLTP
Would'nt block contention increase if too many users want to update rows in the same data block in OLTP?
Also, kindly see the post of another moderator in:
[Edited by Raminder on 09-29-2001 at 11:31 PM]
Click Here to Expand Forum to Full Width