设置lock_sga引起ORA-27102

lijing

TO：xzh2000
你这个数据说明什么呢？

xzh2000

最初由 lijing 发布
[B]TO：xzh2000
你这个数据说明什么呢？ [/B]

8000也不是很大。

lijing

但是我在某些资料上看到：If free memory seems scarce, then you can
monitor the number of pages paged out per second. This metric is available from
the Performance Monitor under NT, or from the vmstat command under Unix. If
this metric is constantly nonzero, then your system is paging consistently and the
SGA should be locked into physical memory if possible. This applies particularly
to operating systems with a paged file system buffer cache, such as NT and
Solaris.
Note, however, that the page out rate is not a good indication of the intensity of
paging activity on operating systems with a paged buffer cache. This is because
buffered file system writes are handled by the paging subsystem and thus
exaggerate the page out rate. A better indication of the intensity of paging activity
on such systems is the scan rate. The scan rate is the number of pages that the
operating system has searched per second while looking for inactive pages. The
scan rate is reported by vmstat on Unix systems under the sr column heading.
Paging may be regarded as light if the scan rate is below 10 pages per second.

现在在redhat as3的vmstat命令中没有出现sr列，所以从page out per second可以看出页置换比较频繁，所以想用LOCK_SGA减少paging

lijing

不知各位对page out有何看法