标题: ORACLE设置内存参数后为什么在AIX中看到的有矛盾,是什么原因 [打印本页] 作者: wnoracle 时间: 2008-11-03 14:16 标题: ORACLE设置内存参数后为什么在AIX中看到的有矛盾,是什么原因 一台AIX小机32G内存,只运行ORACLE数据库,将ORACLE的db_cache_size设为16000M,sga_max_size高为20000M,
在AIX中
# vmstat -v
8192000 memory pages
7842742 lruable pages
6251198 free pages
2 memory pools
483766 pinned pages
80.0 maxpin percentage
20.0 minperm percentage
80.0 maxperm percentage
0.2 numperm percentage
22216 file pages
0.0 compressed percentage
0 compressed pages
0.2 numclient percentage
80.0 maxclient percentage
22216 client pages
0 remote pageouts scheduled
0 pending disk I/Os blocked with no pbuf
0 paging space I/Os blocked with no psbuf
2484 filesystem I/Os blocked with no fsbuf
0 client filesystem I/Os blocked with no fsbuf
0 external pager filesystem I/Os blocked with no fsbuf
0 Virtualized Partition Memory Page Faults
0.00 Time resolving virtualized partition memory page faults
# svmon -G
size inuse free pin virtual
memory 8192000 1941029 6250971 483769 1904313
pg space 4194304 5583
work pers clnt other
pin 207204 0 1759 274806
in use 1904313 0 36716
看到还有很我FREE空间,而占用的空间比db_cache_size的16000M要小不少,那么是不是说ORACLE的db_cache_size不是启动时就占用的,还是什么地方设置有问题?