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