标题: About SHARED POOL SIZE [打印本页] 作者: kfxvpqkc 时间: 2014-9-1 10:06 标题: About SHARED POOL SIZE 当我用SHOW SGA命令,得出以下结果:
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
这说明,在SGA中:
SHARED POOL=Fixed Size+Variable Size=84168656 bytes (约80.3M)
当我用SHOW PARAMETER shared_pool_size时,得出以下结果:
NAME TYPE VALUE
------------------------------------ ----------- ----------------
shared_pool_size big integer 46137344
其中:46137344=44M
show parameter db_cache_size时:
NAME TYPE VALUE
------------------------------------ ----------- ---------
db_cache_size big integer 33554432
其中:33554432=(32M) 与SHOW SGA中Database Buffers 一致.
show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ----------
log_buffer integer 524288
与SHOW SGA中Redo Buffers的值也不一致.
请问:参数shared_pool_size的值与show sga得出的结果是什么关系?
还有参数log_buffer?