| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Huge Swap area being used despite having available ram (Solaris 8 , ora9.2.)
Hello.
I am relatively new to Oracle as a DB, but we use Oracle 9i under the
following conditions.
A sun e6500 ten processor system is direct connected to a sunfire V240 two processor system with 8 GB RAM.
Here is my problem. The V240 has high IO wait times when large numbers of processes are underway. The swap in use number goes through the roof when oracle is running and I still have some 60+% of system memory listed as free. I also cannot seem to increase the total SGA size beyond what it presently is without crashing oracle
My three questions are:
1) why is oracle using so much swap?
2) is there a way to tell oracle on solaris not to use swap (or at least
curb its appetite for it)
3) how can I use more of the system ram (and hopefully decrease the use of
swap)
I am attaching the sample output from startup and top commands for context.
As I have indicated, I am somewhat new to oracle, so forgive my ingnorance of what might be obvious to my learned collegues.
Mike Rowland
308-255-6694
====output from top on DB server=======
last pid: 27538; load averages: 0.03, 0.05, 0.04
06:42:03
163 processes: 162 sleeping, 1 on cpu
CPU states: 98.8% idle, 0.0% user, 1.1% kernel, 0.1% iowait, 0.0% swap
Memory: 8192M real, 5219M free, 3382M swap in use, 1624M swap free
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
1104 root 6 59 0 4464K 3680K sleep 382:02 0.09% picld 26596 root 1 59 0 2960K 1880K cpu/0 1:22 0.07% top 27376 oracle 1 59 0 3149M 1098M sleep 0:12 0.03% oracle 1791 root 1 59 0 28M 14M sleep 2:56 0.00% Xsun 1208 root 1 59 0 4928K 1944K sleep 1:01 0.00% skipd 27378 oracle 1 59 0 3149M 1097M sleep 0:09 0.00% oracle 1392 root 1 59 0 6216K 3648K sleep 0:08 0.00% nsrexecd 1391 root 1 59 0 6008K 2880K sleep 0:03 0.00% nsrexecd 27366 oracle 1 59 0 3094M 1081M sleep 0:02 0.00% oradism 1327 root 24 59 0 3616K 2920K sleep 0:02 0.00% nscd 1561 root 7 59 0 2672K 2232K sleep 0:02 0.00% mibiisa 1355 root 1 59 0 1056K 672K sleep 0:02 0.00% utmpd 27374 oracle 1 59 0 3150M 1103M sleep 0:01 0.00% oracle 1479 root 3 59 0 2744K 2088K sleep 0:01 0.00% vold 1249 root 1 59 0 2528K 1488K sleep 0:01 0.00% rpcbind =====================
The startup of oracle gives the following output Total System Global Area 3222770856 bytes
Fixed Size 734376 bytes Variable Size 2382364672 bytes Database Buffers 838860800 bytes redo buffers 811008 bytesdatabase mounted
-- Message posted via http://www.dbmonster.comReceived on Wed Mar 30 2005 - 07:55:33 CST
 |
 |