I think already most of the memory space(appx. >80%) is already used by
Oracle Instance itself.Check the sga_max_size. If other applications are
running in the server. Those applications will be what causing the
Paging(because of lack of physical memory). You please tune the sga
properly and release the space from sga if that is not used by oracle.


Simmi_ocp

-----Original Message-----
From: Jeff Chirco
[mailto:oracledba-ezmlmshield-x87296890.[Email address protected]
Sent: Thursday, September 28, 2006 8:54 PM
To: LazyDBA Discussion
Subject: a lot of pagging going on

We just upgraded from AIX 5.1 running 9.2 to AIX 5.3 ML4 running 10g
today. This machine as 5gb of memory and I have paging space set to
5gb. I am noticing a lot of paging going on right now. When I do an
lsps -a it is showing paging spaced used at 60%. Any idea on why I am
paging so much.

Db_cache_size = 2500M

Shared_pool = 1000M

Large_pool = 100M



PGA = 500M



Jeff Chirco

Oracle Database Administrator





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

Oracle LazyDBA home page