Re: Oracle and Memory
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,
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.
> >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
--
=============================================
= 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