| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Paging problem in SunOS
My guess is that Mitra is not experience memory shortage if he has 1/2gb of
ram and Oracle
is the only thing running on it with SGA 50M. To verify, check whether the
paging is actually
doing swapping. Look for scan rate when doing vmstat.
If it's not memory shortage then the high paging activity is probably
because the SAG is too
small and oracle has to go to disk constantly to fetch data. Hence, Paul
suggestes to increase
the SGA size.
Rich
-----Original Message-----
Sent: Friday, May 03, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L
He is having paging problems and you are recommending that he increase his
SGA? Could
you explain how you feel that will solve his problem please? Thx
-----Original Message-----
Sent: Friday, May 03, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
I think your SGA is too small. It should be around 200-250MB totally.
-----Original Message-----
Sent: Friday, May 03, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L
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! <http://rd.yahoo.com/welcome/*http://health.yahoo.com> Health - your
guide to health and wellness
This electronic mail transmission contains confidential and/or privileged
information intended only for the person(s) named. Any use, distribution,
copying or disclosure by another person is strictly prohibited.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: Richard.Ji_at_MobileSpring.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Mon May 06 2002 - 10:53:35 CDT
--------------------------------------------------------------------
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).
 |
 |