Hi,

SAP recommends only 8192 blocksize (default),
if you choose another blocksize you'll get unsupported with SAP.

/K.


-----Ursprüngliche Nachricht-----
Von: Mir Aijaz A [mailto:oracledba-ezmlmshield-x25321665.[Email address protected]
Gesendet: Donnerstag, 6. September 2007 10:50
An: LazyDBA Discussion
Betreff: FW: Db_block_size?


hi all,
I have to install oracle 10G R2 on HP-UX machine (itenium)

what shall be the size of db_block_size

documentation says range is 2048 to 32768 and default 8192. what value is optimal. this oracle will support SAP application with aroung 3000 users.

Thanks and Regards,
Aijaz



DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is confidential to the addressee and may also be privileged. If you are not the intended recipient of this e-mail, you may not copy, forward, disclose or otherwise use it in any way whatsoever. If you have received this e-mail by mistake, please e-mail the sender by replying to this message, and deleting the original and any printout thereof.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html



----------------
Vorsitzender des Aufsichtsrats: Hans-Georg Härter
Geschäftsführung: Egon Behle (Vorsitz), Bertram Hoffmann, Wolfgang Runge, Karl-Heinz Schrödl, Wolfgang Zeitz
Sitz: Schwäbisch Gmünd - Handelsregistereintrag: Amtsgericht Ulm HRB 701678

Oracle LazyDBA home page