DB_BLOCK_SIZE for Oracle

View previous topic View next topic Go down

DB_BLOCK_SIZE for Oracle

Post  DilMustafa on Mon Jun 29, 2009 7:35 pm

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.



Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada

View user profile

Back to top Go down

Re: DB_BLOCK_SIZE for Oracle

Post  ngalemmo on Mon Jun 29, 2009 9:32 pm

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.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum