what size of db_block_size should I use when building a datawarehouse db?
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.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
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.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
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.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
16k
Originally Posted by metinergoktas
Bookmarks