Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

DB_BLOCK_SIZE for Oracle

2 posters

Go down

DB_BLOCK_SIZE for Oracle Empty DB_BLOCK_SIZE for Oracle

Post  DilMustafa 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.

http://forums.oracle.com/forums/thread.jspa?threadID=699333&start=0&tstart=0

DilMustafa

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

Back to top Go down

DB_BLOCK_SIZE for Oracle Empty Re: DB_BLOCK_SIZE for Oracle

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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