From: À̼±Çü (shadow@daelimins.com)
Date: Sun Jul 06 2003 - 21:12:54 EDT
dear all
I have a Enterprise 5500 running solaris 8 with the kernel patch version 108528-21 and oracle 9i.
The physical memory size is 3072MB and the swap space size is 6.5GB.
Then the IPC parameter for oracle is setup below
3221225471 max shared memory segment size (SHMMAX)
1 min shared memory segment size (SHMMIN)
500 shared memory identifiers (SHMMNI)
100 max attached shm segments per process (SHMSEG)
When I try to check the memory usage using the top utility, the almost of 3167MB swap space is
using by the oracle process and the 1137MB physical memory is free.
In this point, I have the first question Why the oracle process is not use the remained physical memory space?
I think that the reason of question is the virtual memory management policy on solaris os.
But, our DBA ask to me that "when the many free memory is remain, the oracle process must using
the physical memory. isn't it? In this case, when the oracle processing the trasaction sunch as
sort or build a index, the system performance was very slow. It have a some problem"
The outout of top utility is below
last pid: 7882; load averages: 0.00, 0.03, 0.04 11:35:20
58 processes: 57 sleeping, 1 on cpu
CPU states: 99.5% idle, 0.0% user, 0.3% kernel, 0.2% iowait, 0.0% swap
Memory: 3072M real, 1137M free, 3167M swap in use, 4621M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
7728 ora9i 258 58 0 3149M 20M sleep 0:03 0.00% oracle
7730 ora9i 21 58 0 3148M 14M sleep 0:04 0.00% oracle
7792 ora9i 11 55 0 3145M 28M sleep 0:30 0.00% oracle
7732 ora9i 11 58 0 3140M 12M sleep 0:01 0.01% oracle
7726 ora9i 1 59 0 3139M 12M sleep 0:00 0.00% oracle
7798 ora9i 1 58 0 3138M 20M sleep 0:00 0.00% oracle
7734 ora9i 1 58 0 3138M 15M sleep 0:00 0.00% oracle
7860 ora9i 1 51 0 3138M 18M sleep 0:01 0.00% oracle
7740 ora9i 1 58 0 3138M 15M sleep 0:01 0.01% oracle
7738 ora9i 1 59 0 3138M 13M sleep 0:00 0.00% oracle
7736 ora9i 1 58 0 3138M 13M sleep 0:00 0.00% oracle
7742 ora9i 1 0 0 3082M 1032K sleep 0:05 0.00% oradism
7748 ora9i 1 58 0 17M 7048K sleep 0:00 0.00% tnslsnr
7859 ora9i 4 48 0 16M 8200K sleep 0:00 0.00% sqlplus
300 root 5 50 0 5128K 2128K sleep 0:00 0.00% dtlogin
308 root 5 58 0 3680K 2512K sleep 0:00 0.00% snmpXdmid
Is the reason of first question right?
If the first question is ringt Can I change the virtual memory management policy on solaris os?
Please, anyone help me.....
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:43 EDT