哪位大哥能讲讲，下面内存管理相关视图的意义

显示全部楼层 · 2007-10-20 08:38:44

v$sgastat 和v$sgainfo
SQL> select name,bytes/1024/1024 size_mb from v$sgainfo;
NAME
SIZE_MB
------------------------------ ----------
Fixed SGA Size
1.16685867
Redo Buffers
6.83203125
Buffer Cache Size
412
Shared Pool Size
132
Large Pool Size
4
Java Pool Size
12
Streams Pool Size
0
Granule Size
4
Maximum SGA Size
1024
Startup overhead in Shared Poo 40
Free SGA Memory Available
456
11 rows selected.
POOL
SIZE_MB
------------ ----------

419.99889
java pool
12
shared pool119.709736
large pool
4
v$sga_dynamic_components
SQL> select component,current_size/1024/1024 size_mb from v$sga_dynamic_components;
COMPONENT
SIZE_MB
-------------------- ----------
shared pool
132
large pool
4
java pool
12
streams pool
0
DEFAULT buffer cache404
KEEP buffer cache
8
RECYCLE buffer cache
0
DEFAULT 2K buffer ca
0
DEFAULT 4K buffer ca
0
DEFAULT 8K buffer ca
0
DEFAULT 16K buffer c
0
COMPONENT
SIZE_MB
-------------------- ----------
DEFAULT 32K buffer c
0
ASM Buffer Cache
0
SQL> select name,value/1024/1024 size_mb,isdefault from v$parameter where name like '%size';
NAME
SIZE_MB ISDEFAULT
------------------------------ ---------- ---------
sga_max_size
1024 FALSE
shared_pool_size
0 TRUE
large_pool_size
0 TRUE
java_pool_size
0 FALSE
streams_pool_size
0 TRUE
shared_pool_reserved_size7.59999943 TRUE
java_max_sessionspace_size
0 TRUE
db_block_size
.0078125 FALSE
db_cache_size
0 TRUE
db_2k_cache_size
0 TRUE
db_4k_cache_size
0 TRUE
NAME
SIZE_MB ISDEFAULT
------------------------------ ---------- ---------
db_8k_cache_size
0 TRUE
db_16k_cache_size
0 TRUE
db_32k_cache_size
0 TRUE
db_keep_cache_size
8 FALSE
上面信息似乎都不能联系起来

千问 · 2007-10-20 08:38:44

没有愿意讲，只得自己顶起来。