Vivek, You also need to consider what the impact of multiple block sizes will do to your overall memory utilization. To use multiple block sizes you need to set DB_nK_CACHE_SIZE which reserves memory from your SGA and DB_CACHE specifically for that tablespace(s). While a part of that specific application might benefit from the larger block size the rest of it and your database in general may suffer. Dick Goulet, Senior Oracle DBA 45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795 RGoulet@xxxxxxxxxx : POWERING TRANSFORMATION ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA Sent: Tuesday, December 19, 2006 5:41 AM To: oracle-l@xxxxxxxxxxxxx Subject: Use of Multiple BLOCK Sizes ? Folks Does use of Multiple BLOCK sizes (for different Tablespaces) help in Performance of a Hybrid Application? Any best practices, Links, Docs? Thanks indeed **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***