Excessive Paging&Swapping!


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Excessive Paging&Swapping!
# 1  
Old 02-28-2003
Excessive Paging&Swapping!

Hi all!

Working on Oracle v8i/9i on Unix Sun Solaris v8.0.

I am experiencing excessive paging & Swapping.Would like to know the cause.

I guess:could be due to inappropriate setting of Unix Kernel Parameters...

Please correct me if I am wrong!

Thanks&Regards,

Amit.
# 2  
Old 02-28-2003
How much memory does the system have? How much swap space? Has the /etc/system file been updated with the required parameters for Oracle? How long has the problem been occuring? (and what changed when it started - more users, more databases, new searches being launched daily...)

This isn't something one of us can just say "Yea, you need more memory" You have to work with your Oracle DBA and IT team to find out what was happening and what is happening, know/investigate any changes happening on the system be it OS or Oracle.

Give more details of what you have found and possibly a 'best guess' can be given back.

Post output from any of the monitoring tools showing your problem. If you haven't been watching your servers or at least have sar running and collecting information, turn it on to have some clue of what the server is doing at what times. Check for new cron jobs, increase in users utilizing the database, changes in your volume management (if you are using Vertias or any other volume manager, losing a disk drive and having it 'automatically' place databases on different disks that had the space (but really could not handle the increased load of hits) could cause problems (if you didn't have hot spares).
# 3  
Old 03-05-2003
Thanks RTM!

Hi RTM,

Thanks you for your time.

My Guess is that SGA could be larger in size or too much of memory.

May be the Unix Kernel Parameters are not set appropriately like LOTSFREE,DESFREE, MINFREE which are Paging & Swapping Parameters.

Any idea!May be checking on these could give me the clue.

Thansk & regards,

Amit.
# 4  
Old 03-05-2003
Re: Thanks RTM!

Quote:
Originally posted by Amitstora
Any idea!
Please reread RTM's post. He asked that you post the answers to several questions. We really need that information.

Also use our search function. Search for paging and swapping. You will get a lot of threads that discuss this.
# 5  
Old 03-13-2003
It really isn't as complicated as people are making it.

If your experiencing excessive paging and swapping like you said, get a verification report from the output of commands like iostat, vmstat, sar -wpgr 5, ps and then send it to the person in charge of adding memory to the system. Have him study the report and determine if a memory upgrade is needed.

If you find out that the excessive swapping or whatever problem your having is because of memory shortage, you might wanna try a few things (for the main time) before deciding to buy and install new memory. I suggest you take a good look at ps and find out the processes that take up a lot of memory or processes that accumulate a lot of time. Contact the Users who owns this processes and ask if you can reschedule the processes to run at a later time when the load on the system is light. Or you can ask the user if you can renice the job to run at a lower priority.

Thats all there is to it, my man.
# 6  
Old 03-19-2003
Amit
The default sizes of the rollback segments and redo logs are very small. Do you have all these tablespaces on single disk. Use system tools like iostat etc. and locate which is causing the excessive IO. Also you can use oracle tracing and tkprof tool to estimate the statistics of the database operations. This will give you the details of CPU time, disk usage, indexing issues if any
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Monitoring Paging and Swapping

Hi all, This might sound silly but i am trying to determine if i have sufficient memory or not. My definition of sufficient memory = no swapping + no paging to physical swap file. I know i can use vmstat to monitor swapping and paging and using the SR column as well. But wouldn't it be... (28 Replies)
Discussion started by: javanoob
28 Replies

2. Solaris

Sol10 + OpenLDAP = excessive logging & full file system??!!

Hello all, new to this forum (member of many others). Hopefully I can find help here. SERVER: Brand new server Oracle Enterprise SPARC T4-1 Loaded Solaris SPARC 10 u10, patched to 147440-27 Loaded OpenLDAP v2.4.30 Loaded Berkley DB 4.7.25.NC Loaded OpenSSL 1.0.1c Note: All packages are... (2 Replies)
Discussion started by: Wraith_G2IC
2 Replies

3. UNIX for Dummies Questions & Answers

AIX & DB2 paging issues

AIX & DB2 paging issues Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem.. Thanks in advance (2 Replies)
Discussion started by: nedkao
2 Replies

4. AIX

Excessive interrupt disablement time

Has anyone seen this error before? On the IBM website they suggest updating to AIX 6.1.0.0 TL2, but we are already at that level. Any help or suggestions are appreciated! Thanks! />errpt -a --------------------------------------------------------------------------- LABEL: ... (2 Replies)
Discussion started by: troym72
2 Replies

5. AIX

Why using "%" of Paging size increases & how to decrease this percentage?

Hi I have found a problem on my AIX 5.1 server. day by day the paging size is increasing,what is the reason behind it and if percentage is at 100 what will happen. Oracle 9i is running on my server. PAGING SPACE size,mb 5632 % used 14.6 % free 85.3 How can i decrease the using... (6 Replies)
Discussion started by: dearsumon
6 Replies

6. UNIX for Advanced & Expert Users

virtual memory management, swapping paging

can anybody explain me the concepts virtual memory mangement, swapping and paging? although i roughly know what they are , i need more solid distinction between them, and also i want to figure out the relations between them? do you have any well-defined definitons for this concepts? (2 Replies)
Discussion started by: gfhgfnhhn
2 Replies

7. AIX

Excessive Page INs

Gurus, What does excessive Page Ins indicate for the memory status on the machine. Or, in another form, Reardless the OS, does excessive Page INs reflects memory shortage ? (6 Replies)
Discussion started by: Negm
6 Replies

8. UNIX for Dummies Questions & Answers

excessive IOWAIT

i have a server constantly have high iowait, but i am not able to tell which process generate the most of io. none commands, such as iostat, sar, top will give me this kind of information. hope there is some command can help me to spot the process generate the most of io let to know input... (1 Reply)
Discussion started by: giantpanda77
1 Replies

9. Filesystems, Disks and Memory

Paging and Swapping

Hi Guys: Would like to know how to check system swapping and paging and some theory on how they function. I am an oracle dba and my environment is 8171 on AIX 433. We have a 1GB of RAM on the box and I am educating myself to see how much more SGA can be accommodated on the box and what are the... (2 Replies)
Discussion started by: ST2000
2 Replies

10. UNIX for Dummies Questions & Answers

paging space & monitor

Hi folks, Lately my RS 6000 server is giving some problems. Needs a reboot from time to time (4-8 days):mad: Specs: IBM/RS6000 Unix 4.3 3 gigabyte memory I keep getting messages like : " The fork function failed " I have raised the paging space from 1 gigabyte to 3 gigabyte,... (2 Replies)
Discussion started by: Erik Rooijmans
2 Replies
Login or Register to Ask a Question