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




Oracle LazyDBA home page