PGA 的大小可以这么算吗 : (hash_area_size + sort_area_size ) * 并发的session 数 ?
还有lock_sga=true 好像对Linux AS2.1 没有作用 ?
如何 “ 降低 oracle 对内存的使用量 ” ? 主要从SQL优化着手还是适当的减少SGA ?
-------------------------------------------------------------------------------------------
是的,可怜的3.6 G Mem .
我的系统是 Linxu AS2.1+ Oracle 8.1.6.0
OLTP , 实时系统
Dedicated Server
应用是大多数是一些调用procedure 的实时程序 , 还有web report 报表程序(jsp开发)
下面是我的init.ora 部分内容 :
db_name = "intel"
instance_name = intel
service_names = intel
control_files = ("/u01/product/oradata/intel/control01.ctl", "/u01/product/oradata/intel/control02.ctl", "/u01/product/oradata/intel/control03.ctl"
open_cursors = 6000
max_enabled_roles = 30
db_block_buffers = 307200
shared_pool_size = 524288000
large_pool_size = 10485760
java_pool_size = 5242880
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 1015
log_buffer = 1048576
db_block_size = 4096
remote_login_passwordfile = exclusive
os_authent_prefix = ""
utl_file_dir = /u01/product/oradata/intel
# The following parameters are needed for the Advanced Replication Option
job_queue_processes = 36
job_queue_interval = 60
distributed_transactions = 60
open_links = 30
# Added for SGA and SWAP
lock_sga = true
# The following parameters are needed for locks
dml_locks = 4096
enqueue_resources = 4000
compatible = "8.1.6"
sort_area_size = 2097152
sort_area_retained_size = 2097152
parallel_min_servers=4
parallel_max_servers=60
-----------------------------------------------------------------------------------------------------------
看了看vmstat
intelsfcdb$vmstat 2 30
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
4 0 0 567660 5076 62508 790204 0 0 1 0 0 1 0 1 1
6 0 0 567660 12116 62524 784584 0 0 106 568 1267 1501 51 4 45
4 1 0 567660 14140 62524 783944 0 0 118 450 1099 1315 44 9 47
0 1 0 567660 13748 62524 783232 0 0 202 144 840 909 32 8 60
3 1 0 567660 13636 62536 783408 0 0 506 446 1067 1235 31 1 69
4 0 0 567660 13044 62536 783052 0 0 146 146 1001 1067 30 3 67
3 0 1 567660 10680 62544 783456 0 0 56 436 950 1068 41 1 59
2 0 0 567660 8996 62544 783940 0 0 68 450 1130 1359 39 3 57
1 0 0 567660 5096 62548 787268 0 0 2768 242 1011 1092 31 4 65
3 0 0 567660 5096 62548 787260 0 0 46 388 917 1044 32 1 67
4 1 0 567660 5096 62552 786524 0 0 1472 286 967 1142 29 1 70
1 0 0 567660 5096 62572 780640 0 0 106 284 910 1039 28 2 70
3 0 0 567660 5092 62580 775000 0 0 110 444 956 1151 31 3 66
1 0 0 567660 9572 62596 771452 0 0 48 198 786 854 22 2 76
1 0 0 567660 9572 62596 772080 0 0 144 418 1056 1215 32 1 67
2 1 0 567660 16040 62604 770576 0 0 2148 530 1421 2291 28 4 68
3 0 0 567660 17900 62612 770968 0 0 134 386 1361 2212 44 9 46
5 0 0 567660 17660 62612 771484 0 0 116 346 895 993 50 4 46
5 0 0 567660 11476 62624 772000 0 0 112 312 822 909 47 7 46
1 0 0 567660 14664 62624 772436 0 0 122 238 912 1019 49 2 50
2 1 0 567660 14680 62624 773300 0 0 228 494 945 1099 30 2 68
1 0 0 567660 14680 62632 773640 0 0 94 256 825 881 39 3 57
1 0 0 567660 12660 62632 774080 0 0 62 386 1048 1173 23 1 76
5 0 0 565304 14092 62656 774600 0 0 86 526 1098 1257 33 3 64