what size of db_block_size should I use when building a datawarehouse db?

[Trina]

Hi,
I'm new to data warehouse db. The current data warehouse db size is 300gig which has the db block size of 4kb which I think it is small and not sure why the privious dba build the small size of the db. I got assign to build the new datawarehouse db which I'm not sure should I build with 8kb or 16k block size based on the size of 300gig+ db so I can export the current db and import to the new db.
Any suggestion is greatly appreciate it.

Trina

[LKBrwn_DBA]

16k block size seems ok.

[PAVB]

Platform?... can't you go for 32K?

[metinergoktas]

These are main principles when deciding the db block size

If the rows are small and access to the rows are random , then choose a smaller block size.
If the rows are small and access is sequential, then choose a larger block size.
If the rows are small and access is both random and sequential, then it might be effective to choose a larger block size.
If the rows are large, such as rows containing large object (LOB) data, then choose a larger block size.

[Trina]

the platform is aix 5.3

[PAVB]

These are main principles when deciding the db block size

If the rows are small and access to the rows are random , then choose a smaller block size.
If the rows are small and access is sequential, then choose a larger block size.
If the rows are small and access is both random and sequential, then it might be effective to choose a larger block size.
If the rows are large, such as rows containing large object (LOB) data, then choose a larger block size.

... true but, poster already said it - it's a Data Warehouse.

[Trina]

I found some info on google website regardinng to db block size and thought to share with everyone.

Oracle Database 10g Performance Tuning Tips and Techniques
-- as a rule of thumb, a DW should use the maximum block size available for your platform (either 16k or 32kb), while a transaction procesing system should use an 8kb block size.

[PAVB]

I found some info on google website regardinng to db block size and thought to share with everyone.

Oracle Database 10g Performance Tuning Tips and Techniques
-- as a rule of thumb, a DW should use the maximum block size available for your platform (either 16k or 32kb), while a transaction procesing system should use an 8kb block size.

Well... if you look at the answers to your post you may be surprised that's exactly what everybody here was telling you.

[Trina]

I want to thank all of you providing me suggestion of what db block size to use. Have a great day.

Trina