RE: Use of Multiple BLOCK Sizes ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <rgoulet@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 14:54:48 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Richard J. Goulet
Sent: Tuesday, December 19, 2006 9:08 PM
To: oracle-l@xxxxxxxxxxxxx
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@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***
Other related posts:
