关于Oracle的pre_page_sga参数

原创 Linux操作系统作者：is.x 时间：2012-12-12 20:45:16 0 删除编辑

基础环境：SUSE Linux 11SP2 HA + Oracle 11.2.0.2

事情是这样的，同事反映说系统上有个Oracle实例无论启动、关闭还是sqlplus登录，都比这个系统上的其他实例要慢。我登录看了下，确实比较慢，一般的sqlplus登录都是毫秒级的，这个实例sqlplus登录下需要3秒钟左右。

一开始怀疑这是不是Oracle bug，因为这个系统上有3个oracle实例，sqlplus登录时间有鲜明对比，所以直接对sqlplus进行了strace。

$ ps –ef|grep sqlplus

$ ps –ef|grep –I lsnrctl

$ strace -frT -o /home/app_lsnr.log -p 7854

$ strace -frT -o /home/app_sqlplus.log -p 6075

正常实例输出摘要：

6075 0.000000 read(0, "conn system/oracle@app\n", 1024) = 23 <7.381178>

6075 7.381772 write(9, "\0\r\0\0\6\0\0\0\0\0\3\t\21", 13) = 13 <0.000225>

6075 0.000331 read(9, "\0\21\0\0\6\0\0\0\0\0\t\1\0\0\0\0\0", 8208) = 17 <0.003855>

6075 0.004350 setsockopt(9, SOL_SOCKET, SO_SNDTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0 <0.000200>

6075 0.000479 setsockopt(9, SOL_SOCKET, SO_RCVTIMEO, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0 <0.000201>

6075 0.000488 write(9, "\0\n\0\0\6\0\0\0\0@", 10) = 10 <0.000209>

6075 0.000428 close(9) = 0 <0.000185>

6075 0.000517 munmap(0x7f15a5ba7000, 528384) = 0 <0.000057>

6075 0.000315 stat("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=695, ...}) = 0 <0.000056>

6075 0.000350 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000022>

6075 0.000161 getuid() = 201 <0.000031>

6075 0.000117 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000023>

6075 0.000325 getcwd("/oracle", 256) = 8 <0.000036>

6075 0.000185 stat("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=695, ...}) = 0 <0.000035>

6075 0.000249 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000025>

6075 0.000154 getuid() = 201 <0.000022>

6075 0.000107 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000022>

6075 0.000243 getcwd("/oracle", 256) = 8 <0.000027>

6075 0.000173 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000024>

6075 0.000153 getuid() = 201 <0.000021>

6075 0.000108 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000021>

6075 0.000235 getcwd("/oracle", 256) = 8 <0.000025>

6075 0.000171 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000025>

6075 0.000130 getuid() = 201 <0.000015>

6075 0.000087 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000298 socket(PF_NETLINK, SOCK_RAW, 0) = 9 <0.000032>

6075 0.000086 bind(9, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0 <0.000017>

6075 0.000062 getsockname(9, {sa_family=AF_NETLINK, pid=6075, groups=00000000}, [12]) = 0 <0.000014>

6075 0.000058 sendto(9, "\24\0\0\0\26\0\1\3\247\1\274P\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20 <0.000049>

6075 0.000119 recvmsg(9, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"8\0\0\0\24\0\2\0\247\1\274P\273\27\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 352 <0.000030>

6075 0.000111 recvmsg(9, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\247\1\274P\273\27\0\0\0\0\0\0\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20 <0.000017>

6075 0.000081 close(9) = 0 <0.000046>

慢的实例输出摘要：

6075 0.000000 read(0, "conn system/oracle@portal\n", 1024) = 26 <163.276677>

6075 163.277480 access("/oracle/.tnsnames.ora", F_OK) = -1 ENOENT (No such file or directory) <0.000035>

6075 0.000196 access("/etc/tnsnames.ora", F_OK) = -1 ENOENT (No such file or directory) <0.000035>

6075 0.000116 access("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", F_OK) = 0 <0.000034>

6075 0.000148 stat("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=695, ...}) = 0 <0.000032>

6075 0.000156 open("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", O_RDONLY) = 9 <0.000040>

6075 0.000112 fcntl(9, F_SETFD, FD_CLOEXEC) = 0 <0.000034>

6075 0.000102 fstat(9, {st_mode=S_IFREG|0644, st_size=695, ...}) = 0 <0.000021>

6075 0.000086 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f15a9c22000 <0.000031>

6075 0.000093 read(9, "# tnsnames.ora Network Configura"..., 4096) = 695 <0.000030>

6075 0.000147 read(9, "", 4096) = 0 <0.000022>

6075 0.000078 close(9) = 0 <0.000022>

6075 0.000066 munmap(0x7f15a9c22000, 4096) = 0 <0.000038>

6075 0.000148 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000154 getuid() = 201 <0.000021>

6075 0.000105 open("/proc/self/cmdline", O_RDONLY) = 9 <0.000044>

6075 0.000109 read(9, "sqlplus\0\0\0\0\0\0\0\0", 255) = 15 <0.000032>

6075 0.000092 close(9) = 0 <0.000020>

6075 0.000070 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000019>

6075 0.000232 getcwd("/oracle", 256) = 8 <0.000022>

6075 0.000107 stat("/oracle/app/oracle/product/11.2/network/admin/tnsnames.ora", {st_mode=S_IFREG|0644, st_size=695, ...}) = 0 <0.000025>

6075 0.000134 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000033>

6075 0.000136 getuid() = 201 <0.000019>

6075 0.000096 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000160 getcwd("/oracle", 256) = 8 <0.000034>

6075 0.000120 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000108 getuid() = 201 <0.000019>

6075 0.000074 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000156 getcwd("/oracle", 256) = 8 <0.000025>

6075 0.000101 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000024>

6075 0.000147 getuid() = 201 <0.000048>

6075 0.000114 uname({sys="Linux", node="portaldb02", ...}) = 0 <0.000020>

6075 0.000157 getrlimit(RLIMIT_NOFILE, {rlim_cur=65535, rlim_max=65535}) = 0 <0.000021>

6075 0.000135 open("/oracle/app/oracle/product/11.2/lib/libnque11.so", O_RDONLY) = 9 <0.000035>

6075 0.000092 read(9, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\24\0\0\0\0\0\0"..., 832) = 832 <0.000021>

6075 0.000083 fstat(9, {st_mode=S_IFREG|0644, st_size=59085, ...}) = 0 <0.000020>

6075 0.000092 mmap(NULL, 1090528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 9, 0) = 0x7f15a5c5d000 <0.000030>

6075 0.000083 fadvise64(9, 0, 1090528, POSIX_FADV_WILLNEED) = 0 <0.000021>

6075 0.000066 mprotect(0x7f15a5c67000, 1044480, PROT_NONE) = 0 <0.000030>

6075 0.000080 mmap(0x7f15a5d66000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 9, 0x9000) = 0x7f15a5d66000 <0.000033>

6075 0.000097 mmap(0x7f15a5d67000, 992, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f15a5d67000 <0.000029>

6075 0.000079 close(9) = 0 <0.000021>

不过通过一阵排查，我初步排除了BUG的可能。于是我开始怀疑是不是系统、数据库参数有蹊跷。还有一个细节让我更确信这是数据库参数的问题，就是这台机器是双机，sqlplus慢的数据库实例只在一个节点上会缓慢，另一个节点上启动、关闭、sqlplus登录都很正常，这让我更加肯定应该是数据库参数的问题，而且spfile还没有同步至备机。

比对2个节点的spfile，发现了这个参数被修改过：pre_page_sga=true。

PRE_PAGE_SGA determines whether Oracle reads the entire SGA into memory at instance startup. Operating system page table entries are then prebuilt for each page of the SGA. This setting can increase the amount of time necessary for instance startup, but it is likely to decrease the amount of time necessary for Oracle to reach its full performance capacity after startup.

在Oracle实例启动时，只会在物理内存中首先加载SGA的各内存区的最小内存大小，而剩余的SGA内存只作为虚拟内存（Page File）分配，只有当进程touch到相应的page时，才会置换到物理内存中。而如果设置PRE_PAGE_SGA参数为TRUE，那么在实例启动时SGA会全部被分配至物理内存。由于每个进程在启动时都需要touch所有的SGA内存页，所以每个进程的启动时间会变长。如果SGA很大，会导致数据库的启动、关闭、会话登录都很慢。Page size是由操作系统决定的，不是所有操作系统都可更改此page size。

另外PRE_PAGE_SGA只是在启动时将物理内存分配给SGA，但并不能保证系统在以后的运行过程不会将SGA中的某些页置换到虚拟内存中，也就是说，尽管设置了这个参数，还是可能出现Page In/Out。如果需要保障SGA不被换出，就需要由另外一个参数LOCK_SGA来控制了。这个参数默认值为FALSE，当指定为TRUE时，可以将全部SGA都锁定在物理内存中。当然，有些系统不支持内存锁定，这个参数也就无效了。

系统实例的SGA开了27GB，pre_page_sga参数设置TRUE后，当数据库实例启动时，内存的消耗是这样的：

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

0 0 0 123444512 35064 6261092 0 0 0 368 3393 6554 0 0 100 0 0

0 0 0 123444692 35064 6261104 0 0 1 56 4019 7104 0 0 100 0 0

1 0 0 123453144 35064 6261112 0 0 0 48 3221 6304 0 0 100 0 0

0 0 0 123471952 35068 6261108 0 0 1 48 5129 8424 0 0 100 0 0

0 0 0 123478524 35068 6261116 0 0 0 48 3141 6240 0 0 100 0 0

0 0 0 123487488 35068 6261292 0 0 265 1368 4377 7771 0 0 100 0 0

0 0 0 123492508 35068 6261688 0 0 0 480 4729 7848 1 0 99 0 0

0 0 0 123590796 35076 6261700 0 0 1 184 5025 7742 0 0 99 0 0

0 0 0 123601900 35084 6261724 0 0 0 68 3114 5219 0 0 100 0 0

0 0 0 125227324 35092 4643904 0 0 9 76 3358 5532 0 0 100 0 0

0 0 0 125226392 35092 4643924 0 0 0 0 2186 4359 0 0 100 0 0

0 0 0 125226872 35100 4643856 0 0 1 92 2192 4391 0 0 100 0 0

0 0 0 125228552 35100 4643848 0 0 0 56 2204 4418 0 0 100 0 0

0 0 0 125229580 35100 4643824 0 0 1 0 2258 4473 0 0 100 0 0

0 0 0 125230708 35100 4643728 0 0 0 48 2211 4436 0 0 100 0 0

1 0 0 125231764 35100 4643652 0 0 9 64 2205 4386 0 0 100 0 0

0 0 0 125233892 35100 4643628 0 0 0 24 2229 4425 0 0 100 0 0

1 0 0 125233272 35100 4643636 0 0 1 48 3994 6455 0 1 99 0 0

2 0 0 125152976 35100 4724628 0 0 0 48 3026 5159 0 2 98 0 0

1 0 0 124290444 35100 5579624 0 0 65 24 3678 5895 1 1 98 0 0

1 0 0 122685680 35100 7180908 0 0 0 48 2736 4875 0 1 98 0 0

1 0 0 121081728 35100 8776056 0 0 1 76 3244 5443 0 1 99 0 0

2 0 0 119479140 35108 10372932 0 0 16 248 2624 4749 0 3 97 0 0

2 0 0 117880832 35116 11961180 0 0 1 68 4114 6460 0 2 98 0 0

1 0 0 116266160 35124 13573852 0 0 0 68 2490 4591 0 2 98 0 0

1 0 0 114631716 35124 15203652 0 0 1 8 2560 4632 0 1 99 0 0

1 0 0 113001824 35124 16824480 0 0 0 176 3280 5379 0 2 98 0 0

1 0 0 111366084 35124 18452900 0 0 1 48 3418 5678 0 2 97 0 0

1 0 0 109729496 35124 20084352 0 0 0 0 2991 5139 0 1 98 0 0

2 0 0 108100140 35124 21708800 0 0 1 48 3399 5491 0 1 99 0 0

1 0 0 106464236 35124 23341120 0 0 0 56 2505 4585 0 2 97 0 0

1 0 0 104792612 35124 25006648 0 0 1 12 2492 4522 0 2 97 0 0

2 0 0 103051764 35124 26741940 0 0 8 64 2538 4651 0 1 99 0 0

1 0 0 101316640 35124 28471924 0 0 1 64 2527 4654 0 1 99 0 0

1 0 0 99604208 35124 30178072 0 0 0 0 2463 4484 0 3 97 0 0

1 0 0 99130376 35124 30643824 0 0 1 48 2950 4969 1 1 98 0 0

1 0 0 99122152 35124 30643824 0 0 0 48 2483 4600 1 1 98 0 0

1 0 0 99105620 35132 30643824 0 0 9 116 3936 6343 1 1 99 0 0

1 0 0 99096956 35140 30644408 0 0 0 68 2860 5047 1 1 98 0 0

2 0 0 99088768 35148 30644404 0 0 1 96 3374 5424 1 1 97 0 0

0 0 0 99082032 35148 30644404 0 0 0 0 2484 4556 1 1 99 0 0

1 0 0 99079432 35148 30644408 0 0 1 48 3367 5531 0 0 100 0 0

1 0 0 99069816 35148 30644408 0 0 0 48 2425 4467 1 2 97 0 0

1 0 0 99056128 35148 30644412 0 0 1 0 3886 6208 1 1 98 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

1 0 0 99047364 35148 30644400 0 0 0 48 2507 4606 1 1 99 0 0

1 0 0 99039384 35148 30644408 0 0 9 64 2547 4660 1 1 99 0 0

1 0 0 99027868 35148 30644416 0 0 0 0 3228 5298 1 2 97 0 0

2 0 0 99013044 35148 30644428 0 0 1 48 4667 7765 1 1 98 0 0

1 0 0 99006400 35148 30644428 0 0 0 48 3887 7028 1 1 98 0 0

2 0 0 98997704 35148 30644428 0 0 9 8 4535 7460 1 1 99 0 0

1 0 0 98988952 35148 30644440 0 0 0 48 3550 6524 1 1 97 0 0

1 0 0 98980688 35148 30644440 0 0 1 64 3434 6423 1 1 98 0 0

2 0 0 98972524 35156 30644436 0 0 0 124 3736 6694 1 1 98 0 0

1 0 0 98963500 35164 30644436 0 0 1 68 3414 6424 0 1 99 0 0

1 0 0 98954404 35172 30644440 0 0 0 68 3384 6386 1 1 97 0 0

1 0 0 98945136 35172 30644444 0 0 1 8 3434 6369 1 1 97 0 0

1 0 0 98936436 35172 30644456 0 0 0 76 3447 6488 1 1 99 0 0

1 0 0 98918104 35172 30644460 0 0 1 48 5104 8460 0 1 99 0 0

7 0 0 98909076 35172 30644460 0 0 0 0 3547 6694 1 1 97 0 0

4 0 0 98903164 35172 30644472 0 0 9 56 4510 7511 1 1 98 0 0

1 0 0 98893308 35172 30644476 0 0 0 48 3576 6626 1 1 98 0 0

1 0 0 98883256 35172 30644476 0 0 1 0 4217 7271 1 1 99 0 0

2 0 0 98875080 35172 30644476 0 0 0 56 3505 6603 1 1 98 0 0

1 0 0 98857880 35172 30644476 0 0 1 48 4947 8292 1 1 98 0 0

1 0 0 98851448 35172 30644484 0 0 0 0 3437 6405 1 1 98 0 0

2 0 0 98842572 35172 30644484 0 0 1 56 3647 6630 1 1 99 0 0

1 0 0 98833128 35172 30644492 0 0 0 60 4361 7369 1 1 98 0 0

1 0 0 98818736 35180 30644492 0 0 1 80 4658 7773 1 2 97 0 0

2 0 0 98811840 35188 30644488 0 0 0 68 3780 6798 1 1 99 0 0

1 0 0 98801612 35196 30644504 0 0 1 68 4612 7801 1 1 99 0 0

1 0 0 98794220 35196 30644504 0 0 0 0 3772 6735 2 2 97 0 0

1 0 0 98783352 35196 30644512 0 0 9 92 3501 6599 1 1 98 0 0

1 0 0 98774068 35196 30644520 0 0 0 64 3569 6704 1 1 99 0 0

3 0 0 98765376 35196 30644524 0 0 1 0 3564 6606 1 1 99 0 0

1 0 0 98755964 35196 30644524 0 0 0 48 3702 6667 1 1 97 0 0

2 0 0 98748252 35196 30644528 0 0 9 64 3471 6524 1 1 98 0 0

1 0 0 98738584 35196 30644536 0 0 0 8 3427 6431 1 1 98 0 0

1 0 0 98724652 35196 30644536 0 0 1 48 4823 8168 1 1 99 0 0

1 0 0 98715288 35196 30644524 0 0 0 48 3427 6429 1 1 97 0 0

3 0 0 98696680 35196 30644540 0 0 9 24 4805 7932 1 1 98 0 0

1 0 0 98688552 35196 30644540 0 0 0 56 3808 6832 1 1 98 0 0

1 0 0 98679552 35196 30644544 0 0 1 48 4157 7292 1 1 99 0 0

1 0 0 98669924 35204 30644544 0 0 0 92 3550 6563 1 2 97 0 0

1 0 0 98654848 35212 30644536 0 0 1 68 4869 8242 1 1 98 0 0

1 0 0 98642044 35220 30644536 0 0 0 68 3757 6838 1 1 99 0 0

2 0 0 98632444 35220 30644548 0 0 1 16 3559 6558 0 1 99 0 0

1 0 0 98623108 35220 30644548 0 0 0 48 4199 7215 1 2 97 0 0

1 0 0 98610944 35220 30644552 0 0 1 48 4453 7587 1 1 97 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

2 0 0 98604180 35220 30644552 0 0 0 0 3386 6349 1 1 98 0 0

1 0 0 98594552 35220 30644556 0 0 1 56 4271 7490 1 1 99 0 0

1 0 0 98579360 35220 30644556 0 0 0 72 4230 7119 1 1 98 0 0

1 0 0 98571200 35220 30644556 0 0 9 8 3519 6575 1 1 98 0 0

1 0 0 98562056 35220 30644572 0 0 0 48 3525 6626 1 1 98 0 0

1 0 0 98552940 35220 30644572 0 0 1 48 3545 6662 0 1 99 0 0

1 0 0 98545716 35220 30644572 0 0 0 0 3514 6553 1 1 98 0 0

2 0 0 98530580 35220 30644576 0 0 1 48 3780 6806 1 1 98 0 0

1 0 0 98521380 35220 30644576 0 0 0 64 3449 6509 1 1 99 0 0

1 0 0 98503860 35228 30644576 0 0 1 68 4899 8260 1 1 99 0 0

2 0 0 98495408 35236 30644576 0 0 0 68 3403 6382 1 2 97 0 0

5 0 0 98486272 35244 30644580 0 0 1 76 4178 7367 1 1 98 0 0

1 0 0 98477880 35244 30644580 0 0 0 4 4023 6866 1 1 99 0 0

1 0 0 98462948 35244 30644584 0 0 1 48 4430 7525 1 1 99 0 0

1 0 0 98452616 35244 30644596 0 0 8 64 3524 6587 1 2 97 0 0

1 0 0 98436992 35244 30644596 0 0 1 0 4771 8161 1 1 98 0 0

1 0 0 98428804 35244 30644596 0 0 0 48 3477 6563 1 1 99 0 0

2 0 0 98420544 35244 30644608 0 0 9 88 3641 6788 1 1 99 0 0

1 0 0 98401984 35244 30644624 0 0 16 56 4415 7523 1 1 98 0 0

1 0 0 98391908 35244 30644632 0 0 1 96 4383 7593 1 1 98 0 0

2 0 0 98384828 35244 30644680 0 0 0 48 3572 6546 1 1 98 0 0

2 0 0 98375256 35244 30644680 0 0 1 0 4165 7159 1 1 99 0 0

1 0 0 98358800 35244 30644684 0 0 0 56 4153 7157 1 1 98 0 0

1 0 0 98344500 35244 30644684 0 0 1 56 3654 6668 1 1 98 0 0

1 0 0 98335844 35252 30644684 0 0 8 112 3709 6754 1 1 99 0 0

1 0 0 98327048 35260 30644676 0 0 1 68 3514 6653 0 1 99 0 0

1 0 0 98318852 35268 30644684 0 0 0 84 3548 6632 1 1 97 0 0

2 0 0 98310072 35268 30644684 0 0 1 20 3545 6583 1 1 98 0 0

1 0 0 98302060 35268 30644692 0 0 0 64 3501 6624 1 1 99 0 0

1 0 0 98280844 35268 30644684 0 0 1 48 5188 8570 1 1 99 0 0

2 0 0 98273232 35268 30644688 0 0 0 0 3517 6470 1 2 97 0 0

1 0 0 98263292 35268 30644704 0 0 9 88 4114 7179 1 1 98 0 0

2 0 0 98252120 35268 30644728 0 0 0 56 4811 10735 1 1 98 0 0

1 0 0 98244228 35268 30644772 0 0 1 0 4224 7658 1 1 99 0 0

2 0 0 98233144 35268 30644772 0 0 0 56 3705 6677 1 1 98 0 0

1 0 0 98217624 35268 30644776 0 0 1 48 5023 8279 1 1 98 0 0

1 0 0 98209596 35268 30644784 0 0 0 0 3452 6465 1 1 98 0 0

2 0 0 98201516 35268 30644788 0 0 1 100 3724 6754 1 1 99 0 0

1 0 0 98193876 35268 30644788 0 0 0 56 4290 7312 1 1 97 0 0

1 0 0 98183488 35276 30644784 0 0 1 56 4440 7550 1 2 97 0 0

1 0 0 98175476 35284 30644780 0 0 0 68 3807 6836 1 1 99 0 0

1 0 0 98164252 35292 30644776 0 0 1 84 4167 7341 1 1 99 0 0

1 0 0 98148764 35292 30644792 0 0 0 0 4171 7232 1 2 97 0 0

1 0 0 98140180 35292 30644788 0 0 9 56 3508 6630 1 1 98 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

1 0 0 98131232 35292 30644796 0 0 0 48 3545 6665 1 1 99 0 0

1 0 0 98123236 35292 30644804 0 0 1 0 3852 6900 0 1 99 0 0

1 0 0 98114724 35292 30644804 0 0 0 48 3367 6367 1 1 98 0 0

2 0 0 98106168 35300 30644800 0 0 1 112 3480 6563 1 1 97 0 0

1 0 0 98097112 35300 30644800 0 0 8 16 3493 6540 1 1 99 0 0

1 0 0 98080812 35300 30644800 0 0 1 48 4816 8201 1 1 99 0 0

1 0 0 98072624 35300 30644796 0 0 0 56 3408 6423 1 2 97 0 0

1 0 0 98063484 35300 30644800 0 0 1 8 4366 7406 1 1 97 0 0

1 0 0 98050736 35300 30644804 0 0 0 48 4159 7269 1 1 99 0 0

1 0 0 98040464 35300 30644808 0 0 1 56 4186 7331 1 1 99 0 0

2 0 0 98032728 35308 30644808 0 0 0 100 3585 6641 1 2 97 0 0

1 0 0 98017496 35316 30644808 0 0 1 68 4936 8339 1 1 98 0 0

1 0 0 98007836 35324 30644804 0 0 0 80 3793 6840 1 1 99 0 0

2 0 0 97999772 35324 30644836 0 0 9 24 3500 6510 1 1 99 0 0

1 0 0 97990080 35324 30644836 0 0 0 56 4160 7192 1 1 98 0 0

2 0 0 97978568 35324 30644840 0 0 1 48 4492 7665 1 1 98 0 0

1 0 0 97969588 35324 30644840 0 0 0 0 3403 6382 1 1 98 0 0

3 0 0 97962984 35324 30644844 0 0 1 48 4145 7270 1 1 99 0 0

3 0 0 97943208 35332 30644856 0 0 0 112 5025 7825 5 3 92 0 0

2 0 0 97929560 35332 30644872 0 0 1 8 4162 6806 4 5 91 0 0

3 0 0 97916988 35332 30644872 0 0 8 64 4071 6894 1 2 98 0 0

2 0 0 97904076 35332 30644888 0 0 1 48 4074 6911 1 2 98 0 0

2 0 0 97890388 35332 30644888 0 0 0 0 3984 6728 1 4 95 0 0

2 0 0 97876984 35332 30644892 0 0 1 60 4055 6858 2 3 96 0 0

4 0 0 97796576 35332 30644896 0 0 0 56 4808 7481 1 2 97 0 0

2 0 0 97942808 35340 30644900 0 0 1 140 5607 8387 1 3 96 0 0

2 1 0 97925356 35348 30644904 0 0 0 92 3995 6715 2 3 94 0 0

2 0 0 97903956 35356 30644908 0 0 9 104 4673 7443 1 2 97 0 0

3 0 0 97882428 35356 30644912 0 0 0 84 4620 7323 1 2 97 0 0

1 0 0 97862092 35356 30644924 0 0 109 68 4664 7588 1 1 98 0 0

0 0 0 97914848 35356 30644928 0 0 0 48 3442 6208 0 2 98 0 0

1 0 0 97907628 35356 30644932 0 0 1 0 4472 7882 0 0 99 0 0

0 0 0 97907284 35356 30644940 0 0 0 48 3140 6304 0 0 100 0 0

0 1 0 97908160 35356 30644944 0 0 9 520 3234 6456 0 0 100 0 0

2 0 0 97954032 35364 30644964 0 0 696 628 4984 7994 1 2 97 0 0

1 0 0 97943744 35364 30644964 0 0 1 96 4892 8069 1 1 98 0 0

3 0 0 97921060 35364 30644968 0 0 0 64 4572 7386 1 1 97 0 0

3 0 0 97892656 35364 30644968 0 0 9 16 4891 7519 2 2 96 0 0

3 0 0 97861244 35364 30644976 0 0 0 172 4752 7395 3 4 94 0 0

3 0 0 97837476 35364 30644980 0 0 1 584 4663 7423 2 4 94 0 0

3 0 0 97814708 35364 30644980 0 0 0 0 4276 6959 2 3 96 0 0

3 0 0 97792080 35380 30644976 0 0 1 232 4247 7099 1 2 96 0 0

8 0 0 97671412 35388 30644972 0 0 0 72 4327 7073 2 5 94 0 0

3 0 0 97855308 35388 30644984 0 0 1 8 4834 7261 2 4 94 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

3 0 0 97831052 35388 30644980 0 0 0 104 4054 6766 1 2 97 0 0

4 0 0 97720092 35392 30723900 0 0 41 992 5675 9052 2 2 97 0 0

3 0 0 97697092 35392 30723968 0 0 0 0 4178 6828 3 6 91 0 0

3 0 0 97671164 35392 30723976 0 0 9 256 4831 7621 2 4 94 0 0

3 0 0 97646464 35392 30723988 0 0 0 52 4964 7736 1 2 96 0 0

3 0 0 97595852 35400 30723984 0 0 1 32 4930 7650 1 3 96 0 0

3 0 0 97710608 35400 30723988 0 0 0 120 5198 7546 1 5 94 0 0

3 0 0 97679200 35400 30723992 0 0 1 48 5524 8548 2 4 94 0 0

3 0 0 97655236 35400 30723996 0 0 0 0 4138 6740 2 3 95 0 0

5 0 0 97616644 35400 30724004 0 0 1 120 5148 7738 2 3 96 0 0

6 0 0 97566024 35400 30724004 0 0 0 56 5496 8172 4 5 91 0 0

6 0 0 97523724 35400 30724000 0 0 1 0 5562 8384 5 8 88 0 0

5 0 0 97465852 35408 30724004 0 0 0 116 5326 7865 2 6 92 0 0

5 0 0 97621888 35424 30723992 0 0 1 200 7233 9178 1 4 94 0 0

7 0 0 97563008 35424 30724008 0 0 0 8 6122 8629 5 10 85 0 0

8 0 0 97447412 35424 30724016 0 0 9 104 5337 7797 5 9 87 0 0

5 0 0 97568972 35424 30724016 0 0 0 64 5530 7641 3 6 91 0 0

5 0 0 97521936 35424 30724016 0 0 57 304 5289 7892 3 4 93 0 0

5 0 0 97473132 35424 30724056 0 0 0 96 4666 7218 5 6 89 0 0

4 0 0 97420104 35424 30724060 0 0 25 156 5493 8190 3 5 93 0 0

5 0 0 97383784 35424 30724084 0 0 0 8 4563 7071 3 4 93 0 0

5 0 0 97337396 35432 30724084 0 0 1 120 5770 8816 2 3 95 0 0

5 0 0 97294876 35432 30724084 0 0 0 48 5034 7537 4 7 89 0 0

5 0 0 97251284 35432 30724092 0 0 9 24 5538 8113 5 7 88 0 0

6 0 0 97206048 35432 30724092 0 0 16 176 5458 8193 2 4 94 0 0

6 0 0 97163280 35432 30724124 0 0 17 104 5913 8461 3 4 94 0 0

4 0 0 97119164 35432 30724176 0 0 48 168 5268 7871 5 7 88 0 0

3 0 0 97076580 35440 30724188 0 0 1 132 5627 8701 2 3 95 0 0

5 0 0 97093312 35456 30724196 0 0 8 188 4930 7626 2 3 95 0 0

2 0 0 97065212 35456 30724204 0 0 1 128 4440 7108 2 3 96 0 0

3 0 0 97049104 35456 30724208 0 0 0 96 4586 7449 2 2 96 0 0

3 0 0 97032508 35456 30724212 0 0 1 48 5236 8159 2 2 96 0 0

1 0 0 97021176 35456 30724220 0 0 8 16 4333 7406 1 1 98 0 0

1 0 0 97009060 35456 30724220 0 0 1 104 4536 7673 1 1 99 0 0

1 0 0 96997136 35456 30724220 0 0 0 48 4272 7391 1 1 97 0 0

4 0 0 96987416 35456 30724220 0 0 9 8 3978 7112 2 1 97 0 0

1 0 0 96978640 35464 30724228 0 0 0 124 3521 6704 1 1 99 0 0

1 0 0 96970296 35464 30724240 0 0 1 64 3573 6833 1 1 99 0 0

1 0 0 96962428 35464 30724240 0 0 0 0 3672 6761 1 1 98 0 0

6 0 0 96943828 35464 30724240 0 0 1 104 4256 7297 1 1 98 0 0

2 0 0 96925508 35464 30724240 0 0 8 64 4083 6998 1 2 97 0 0

2 0 0 96904636 35464 30724232 0 0 1 0 5406 8616 1 1 97 0 0

2 0 0 96885144 35472 30724228 0 0 0 140 4026 6919 2 2 96 0 0

3 0 0 96865196 35480 30724224 0 0 1 84 4894 7887 2 2 96 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

4 0 0 96795068 35480 30724232 0 0 0 8 5049 7864 1 3 96 0 0

1 0 0 96888788 35488 30724224 0 0 1 164 4197 7329 0 1 99 0 0

1 0 0 96880644 35488 30724228 0 0 0 48 3464 6521 1 1 98 0 0

1 0 0 96866172 35488 30724228 0 0 1 0 4617 8005 1 1 98 0 0

1 0 0 96857952 35496 30724228 0 0 0 160 3395 6479 1 1 99 0 0

1 0 0 96850088 35496 30724236 0 0 33 140 3865 7058 1 1 99 0 0

2 0 0 96837652 35496 30724260 0 0 0 8 4081 7316 1 2 97 0 0

1 0 0 96823548 35504 30724252 0 0 1 116 4796 8037 1 1 98 0 0

2 0 0 96816720 35504 30724252 0 0 0 48 3565 6692 1 1 99 0 0

2 0 0 96800144 35504 30725764 0 0 401 16 4443 7722 1 1 98 0 0

1 0 0 96798460 35504 30725600 0 0 8 120 4278 7382 1 1 98 0 0

1 0 0 96841104 35504 30725664 0 0 313 120 4312 7274 2 2 96 0 0

2 0 0 96831812 35504 30725976 0 0 8 16 3689 6800 1 1 98 0 0

1 0 0 96823816 35512 30725976 0 0 1 116 3479 6642 1 1 99 0 0

1 0 0 96816736 35520 30725976 0 0 0 68 3524 6686 1 1 98 0 0

2 0 0 96801136 35520 30726692 0 0 265 28 4042 7205 1 2 97 0 0

4 0 0 96746668 35520 30726792 0 0 0 112 4121 7088 1 1 98 0 0

1 0 0 96833628 35520 30726792 0 0 1 48 4836 8210 1 1 98 0 0

1 0 0 96827780 35520 30726800 0 0 0 0 3422 6425 2 2 97 0 0

1 0 0 96817876 35520 30726804 0 0 9 136 4040 7178 1 1 99 0 0

2 0 0 96797408 35520 30726808 0 0 0 48 4721 7650 1 1 97 0 0

2 0 0 96776624 35528 30726892 0 0 449 44 4581 7347 1 2 97 0 0

1 0 0 96819408 35536 30726888 0 0 0 116 3810 6607 1 2 97 0 0

1 0 0 96808128 35536 30727264 0 0 9 56 4796 8134 1 1 98 0 0

1 0 0 96801104 35536 30727272 0 0 0 0 3399 6389 1 1 98 0 0

1 0 0 96791784 35544 30727264 0 0 9 148 3613 6826 0 0 99 0 0

0 0 0 96790072 35544 30727280 0 0 0 48 3666 6875 0 0 100 0 0

0 0 0 96847692 35544 30727280 0 0 1 8 5254 8115 0 2 98 0 0

2 0 0 96850004 35552 30727280 0 0 0 116 3186 6370 0 0 100 0 0

0 0 0 96849264 35560 30727272 0 0 1 80 4000 7111 0 0 100 0 0

1 0 0 96850756 35560 30727280 0 0 0 0 3923 6990 0 0 100 0 0

1 0 0 96850908 35560 30727280 0 0 1 104 3089 6208 0 0 100 0 0

0 0 0 96851312 35560 30727280 0 0 0 48 3118 6260 0 0 100 0 0

0 0 0 96853072 35560 30727280 0 0 1 0 3119 6224 0 0 100 0 0

1 0 0 96853928 35560 30727280 0 0 0 96 3094 6238 0 0 100 0 0

0 0 0 96855848 35560 30727288 0 0 9 92 3168 6350 0 0 100 0 0

0 0 0 96858468 35560 30727292 0 0 0 8 3132 6242 0 0 100 0 0

0 0 0 96850456 35576 30727292 0 0 1 156 4612 8098 0 0 100 0 0

0 0 0 96852532 35576 30727292 0 0 0 80 3082 6211 0 0 100 0 0

0 0 0 96854468 35576 30727300 0 0 9 16 3825 6865 0 0 100 0 0

0 0 0 96854052 35576 30727300 0 0 0 96 3989 7125 0 0 100 0 0

1 0 0 96853524 35576 30727300 0 0 17 96 3904 7112 0 0 100 0 0

0 0 0 96854556 35576 30727316 0 0 0 0 3248 6269 0 0 100 0 0

0 0 0 96849640 35592 30727308 0 0 1 188 4581 8004 0 0 100 0 0

procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------

r b swpd free buff cache si so bi bo in cs us sy id wa st

1 0 0 96851236 35600 30727308 0 0 0 68 3145 6342 0 0 100 0 0

0 0 0 96851988 35600 30727316 0 0 1 28 3147 6277 0 0 100 0 0

0 0 0 96851800 35600 30727316 0 0 0 104 3487 6751 0 0 100 0 0

0 0 0 96850272 35600 30727316 0 0 1 48 4664 7843 0 0 100 0 0

1 0 0 96853080 35600 30727316 0 0 0 0 3114 6215 0 0 100 0 0

0 0 0 96852608 35600 30727316 0 0 1 112 3987 7133 0 0 100 0 0

0 0 0 96841720 35600 30727312 0 0 8 64 3909 7030 0 0 100 0 0

0 0 0 96843200 35600 30727320 0 0 1 8 3107 6208 0 0 100 0 0

0 0 0 96844024 35608 30727316 0 0 0 132 3169 6370 0 0 100 0 0

0 0 0 96844348 35608 30727336 0 0 1 728 3257 6466 0 0 100 0 0

1 0 0 96844348 35608 30727340 0 0 0 0 3128 6236 0 0 100 0 0

0 0 0 96844580 35608 30727380 0 0 9 120 3153 6360 0 0 100 0 0

既然问题已经查明，修改回pre_page_sga=false，并同步spfile后，问题解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20750200/viewspace-750995/，如需转载，请注明出处，否则将追究法律责任。

上一篇： SQL Server2008 实例数据迁移步骤

下一篇：没有了~

请登录后发表评论登录

全部评论

is.x

注册时间：2011-04-27

博文量
73
访问量

256750

ITPub博客

关于Oracle的pre_page_sga参数

最新文章