DB_BLOCK_SIZE for Oracle
2 posters
Page 1 of 1
DB_BLOCK_SIZE for Oracle
What should be value for DB_BLOCK_SIZE in Oracle DB (10g Rel 2). Oracle recommends 32 but if you google around a little bit, you will find 100's talking against 32 block size.
http://forums.oracle.com/forums/thread.jspa?threadID=699333&start=0&tstart=0
http://forums.oracle.com/forums/thread.jspa?threadID=699333&start=0&tstart=0
DilMustafa- Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada
Re: DB_BLOCK_SIZE for Oracle
I don't usually get that deep into physical set up, but for a data warehouse it makes sense to use a larger rather than smaller block. In places where I have built DW's using Oracle, it was usually set up with 16 or 32K blocks and things performed well.
My guess is there is probably a diminishing return with larger blocks and there is probably and inverse result with relatively sparse queries.
I think it would also depend on the type of disk storage you are using. Stripped RAID (I don't recall what number it is) would do better with larger blocks since it reads in parallel against multiple drives. Mirroring also helps as it provides multiple paths to the same data.
My guess is there is probably a diminishing return with larger blocks and there is probably and inverse result with relatively sparse queries.
I think it would also depend on the type of disk storage you are using. Stripped RAID (I don't recall what number it is) would do better with larger blocks since it reads in parallel against multiple drives. Mirroring also helps as it provides multiple paths to the same data.
Similar topics
» Dimension Table Indexing Strategy
» Fact Table Indexing Strategy
» Oracle BI features
» ETL from Oracle to SQL Server 2008 Data Warehouse
» snowflakes and ORACLE partitions
» Fact Table Indexing Strategy
» Oracle BI features
» ETL from Oracle to SQL Server 2008 Data Warehouse
» snowflakes and ORACLE partitions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum