Re: Oracle and Memory

Joe Trubisz 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

The instructor was probably referring to when you make your sga so large that there is not enough space to keep active pages in memory. Programs and even the sga can begin to page/swap out. What is the right size/setting for the sga on any given configuration, that’s the $64,000.00 question. You need to balance the OS and Oracle. If you have the time, monitor paging using sar or vmstat before, during, and after you enlarge the sga. The Oracle7 Server Tuning manual provides rules, from an Oracle perspective, on when to increase the various parts of the sga.

                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo

I think I've got the hang of it now .... :w :q :wq :wq! ^d X exit ^X^C ~. system X Q :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT ^[zz ^[ZZ man help ^C ^c help exit ?Quit ?q CtrlShftDel "Hey, what does this button d..." Received on Thu Aug 15 1996 - 00:00:00 CEST