Re: Oracle and Memory
Date: 1996/08/19
Message-ID: <3218AF31.5702_at_ibm.net>#1/1
Richard Hu wrote:
>
> >This might sound like a totally idiotic question, since it
> >flys in the face of reason. But, an associate of mine just
> >came back from a Oracle class where the statement was made that
> >'having too much memory can cause problems with Oracle'. I
> >thought that this was totally absurd and the person in the
> >class didn't ask the obvious question, why?
> >Does this make sense to anyone or was the instructor out to lunch?
> >Thanks,
> >Joe
>
> More memory=ORACLE heaven...I cant see how more memory could ever
> really hurt. AT best you can have a large mahority of your database
> in RAM...this would not HURT at all and be lightning fastWhat instructor could means is not too much RAM but rather too much RAM
assigned to SGA. The tuning of Oracle to achieve the best performance
out of the available system resources is quite complex task and
very often more/bigger does not mean better. Many factors needs to be
balanced and it is system and site dependant.
There are numerous books providing info on the Oracle tuning issue.
Halina Monka
Received on Mon Aug 19 1996 - 00:00:00 CEST