Re: swapping

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: Sarah_Chen@xxxxxxxxx
  • Date: Thu, 06 Jan 2005 13:44:45 -0500

Chen, Sarah wrote:

>Dear Experts
>
>I am encountering high swapping problem on Oracle database 9.2.0.4 with 16G
>RAM on Sun Sol 2.8 platform. 
>  
>

ALTER SYSTEM SET FILESYSTEMIO_OPTIONS=SETALL SCOPE=BOTH;
After that, restart both the machine and the database.



>Can anyone provide good UNIX commands/tips? I would also like to know how to
>find how much swap space for each running process?
>  
>

The best command to empty swap is "init 6", ran as root.  It will reboot 
your system. Other then
that, ps -el, top, sar, iostat, vmstat and alike is completely 
sufficient. Much of the swap usage will not be shown and does not belong 
to the processes. Much of the swap usage is a consequence
of dynamic unix buffer cache. Free memory is dynamically allocated to 
the file system buffers,
but when new process is started, those buffers are saved on the swap 
partition.  There is another
great command to save some memory space on database servers:

ps -ef|egrep -i "x11|mwm|openwin|emacs"|grep -v grep|perl -ne '@A=split 
/\s+/; print $A[2],"\n";'|xargs kill -9

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
//www.freelists.org/webpage/oracle-l

Other related posts: