Re: Oracle and Memory

From: Ted Do <theodore.do_at_trw.com>
Date: 1996/08/21
Message-ID: <321B8ECF.38FF_at_trw.com>#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 fast

Yes. There is one case that when you defined a bigger SGA (shared memory to be exact) that can cause performance degradation comparing to a smaller SGA.

Think about it!!!

-Ted.

Hint: disk space.

-- 
=============================================
= Theodore Do                               =
= Technical Consultant, UNIX/ORACLE         =
= TRW Information Technology Services       =
= theodore.do_at_trw.com                       =
=============================================
Received on Wed Aug 21 1996 - 00:00:00 CEST

Original text of this message