RE: Paging problem in SunOS

[Ji, Richard]

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-----
From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Paging problem in SunOS

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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Li
Sent: Friday, May 03, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Paging problem in SunOS

I think your SGA is too small. It should be around 200-250MB totally.

-----Original Message-----
From: Pradyut Mitra [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L
Subject: Paging problem in SunOS

 

 

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

***************************************************************************

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.

***************************************************************************