From: À̼±Çü (shlee73@nate.com)
Date: Fri Jul 04 2003 - 05:34:31 EDT
[IMAGE]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.....
[IMAGE]
[IMAGE]
D+5e?,C< / 0aA&1] @e:NGR:N
D+5e:z <133,:PGR;sH/GO<<?d!
[IMAGE]
3W@LF.4eDD 8^@O
1z2}GQ 8^@O H/0f@; A&0xGU4O4Y.
_______________________________________________
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