Oracle10g V$OSSTAT 关于PHYSICAL_MEMORY_BYTES 的 Bug
|
PHYSICAL_MEMORY_BYTES |
Total number of bytes of physical memory |
----------------------------------- --------------------------------
PHYSICAL_MEMORY_BYTES 16,710,107,136
realmem 16318464 Amount of usable physical memory in Kbytes False
16710107136/1024=16318464 Kbytes 二者一致
HP-UX 11i
SELECT stat_name,value FROM V$OSSTAT where stat_name='PHYSICAL_MEMORY_BYTES';
$ uname -a
HP-UX benqora4 B.11.11 U 9000/800 2311437608 unlimited-user license
SQL> column stat_name format a30
SQL> column value format 9999999999999
SQL> SELECT stat_name,value FROM V$OSSTAT where stat_name='PHYSICAL_MEMORY_BYTES';
STAT_NAME VALUE
------------------------------ --------------
PHYSICAL_MEMORY_BYTES 17177772032
HP-UX Physical Memory:
# head -l -n 1200 /var/adm/syslog/syslog.log|grep Physical|grep avail|cut -c 35-|dos2ux
Physical: 16775168 Kbytes, lockable: 13423000 Kbytes, available: 15405824 Kbytes
SQL>select 17177772032/1024 from dual
16775168 Kbytes 二者一致
上面两个操作系统和Oracle White Paper 中说得一致。
下面我们来看看 RedHat AS4 看看如何：
RedHat AS4:
[root@itc-test9 ~]# uname -a
Linux itc-test9 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:29:47 EST 2005 x86_64 x86_64 x86_64 GNU/Linux
[root@itc-test9 ~]#
SQL> column stat_name format a30
SQL> column value format 9999999999999
SQL> SELECT stat_name,value FROM V$OSSTAT where stat_name='PHYSICAL_MEMORY_BYTES';
STAT_NAME VALUE
---------------------------------------------------------------- ----------
PHYSICAL_MEMORY_BYTES 87132
RedHat AS4 Physical Memory:
[root@itc-test9 ~]# more /proc/meminfo
MemTotal: 2056000 kB
MemFree: 87132 kB
Buffers: 139580 kB
Cached: 1419252 kB
所以在 Red hat Linux 64bit,Oracle Version=10.2.0.3 上 V$OSSTAT 的Physical Memory Bytes 显示的为
系统 Free Memory XXX KBits 的数量。
从测试状况来看应该是 Oracle 10.2.0.3 在 Red hat As4 Linux上的一个Bug.