RE: Use of Multiple BLOCK Sizes ?

Thanks Dick for responding.  

A small Clarification please.  

Dick Wrote "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."

Are you trying to communicate that "the rest of Database may generally suffer" for want of enough SGA due to insufficient RAM space?  

Would this be a NON-issue if the DB Server has a Huge RAM & thus Memory / SGA size are NOT a constraint?  

Cheers  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Richard J. Goulet
Sent: Tuesday, December 19, 2006 9:08 PM To: oracle-l_at_freelists.org
Subject: RE: Use of Multiple BLOCK Sizes ?  

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_at_kanbay.com
: POWERING TRANSFORMATION    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Tuesday, December 19, 2006 5:41 AM To: oracle-l_at_freelists.org
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***

--
http://www.freelists.org/webpage/oracle-l