RE: Paging problem in SunOS

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 03 May 2002 07:58:38 -0800
Message-ID: <F001.00457637.20020503075838@fatcity.com>

('binary' encoding is not supported, stored as-is)
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 <pradyutmitra_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com

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: ListGuru_at_fatcity.com (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).

Received on Fri May 03 2002 - 10:58:38 CDT