Re: Oracle and Memory

Richard

I have seen cases where the sga is too large. Yes I did said too large 8-). (Not very often) I have also see cases that increasing the sga does not improve performance.

It does take a certain amount of time to go through the SGA looking for data. Oracle has to maintain memory structures that contain data about what is in the sga. As the sga grows so do the structures and so does the time it takes to review the internal structures. Therefore there is a point of demising return where the SGA is so large then it is quicker to go read the data off a disk using a selective index then reading millions of data blocks.

Take Care,

Bob Received on Mon Aug 19 1996 - 00:00:00 CEST