Here's my 2 cents,

Q: What is a good block size strategy for my database? (What is a good
db_block_size for my database?)
A: Oracle provides 2k, 4k, 8k, 16k and 32k block sizes (at least on Solaris). The
block size for the server must be specified at database create time, thus the DBA
must know what types of activities will be going on in the database. Rules of thumb are:

- Heavy OLTP: 2k block size (but must be a high contention ... not just inserts)
- Heavy Data Warehouse/DSS: 32k block size
- *Any* other activity; go with standard block size for your OS (8k on unix,
4k on Windows boxes).

I've never seen a need for anyone to use a 4k or 16k server. Some oracle operations
seem to be internally tuned to using a standard block size (e.g. drop table took
five times as long when the block size was 2k than it was when 8k in our internal tests).

Todd

>
> The thumb rule is for oltp go for small block size and DSS it should big
> block size.
>
> Again if your in 9i don't bother much about the block size. Since block
> size can be decided at tablespace level.
>
>
> Thanks and Regards,
> Satheesh Babu.S
> Associate Consultant.
> 080-57593938
> Bangalore.
> India.
>
>
>
>
>
> -----Original Message-----
> From: Tony James
> [mailto:oracledba-ezmlmshield-x33733992.[Email address protected]
> Sent: Wednesday, June 30, 2004 3:40 PM
> To: LazyDBA Discussion
> Subject: Recommended block size
>
> Hi
>
> Are there any recommendations on the block size on a
> SAN realted disks when setting up an Oracle database.
>
> I use and have been using 8k as a rule of thumb. I
> have searched metalink etc. and failed to find any
> white papers.
>
> If you can point me to any web sites for justificaiton
> etc. that will be great.
>
> Ta
> Tj
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page