Re: buffer advisor (has become: should there be a private sql area?)
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Sep 2014 13:23:40 -0600
On 12/09/2014 1:09 PM, Iggy Fernandez wrote:
How would permitting a private SQL area (for use in degraded mode)
degrade other ongoing processes?
If you have no room in the shared pool, it is likely that you are either
misconfigured or running at the edge of available resources. In either
case, it is conceivable that adding yet another process could bring the
entire system to, or over, the edge.
Hence the question: if it degraded all other ongoing processes, would
this be a good thing or bad thing?
While I agree that it "could be something to make optional", I note that
Oracle has traditionally tried to stay conservative. Unsuccessfully in
some cases, but they always seem to lean toward not allowing one process
to impact the apple cart.
That said, now that cpu and memory are rather inexpensive, with near
TByte RAM showing up, some of the decisions Oracle took years ago could
possibly be rethinked. Just give them a solid business case so they
know which of the 100,000 possible features to postpone for this one.
/Hans
Other related posts:
