Your SGA is pretty small by usual standards - which is not, in itself, a cause for alarm, and, in any case, you shouldn't experience the SGA being swapped in and out. In practice, it means that Oracle leaves lots of memory to other processes. I would look for the culprit on the client side - you may have a process boldly attempting to load a mega table in memory or something of the kind. Can't you check with 'top' or ps with the right -o options which processes are guzzling the most memory? Could be a good place to start.
>----- Original Message ----- >From: Pradyut Mitra <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Fri, 03 May 2002 04:38:27 > > > > > > >Hi,I am experiencing a massive performance problem >due tohigh page-in operation In Sun OS 5.6/Oracle >8.1.7.The RAM is 512 M and SGA is around is 50M and >no otherprocess is running on that m/c. > > > >Any suggestions. > > > >Thanks in advance. > > > >Pradyut > > > >--------------------------------- >Do You Yahoo!? >Yahoo! Health - your guide to health and wellness Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
