11:18:11 SQL> select pool,sum(bytes) from v$sgastat group by pool;
POOLSUM(BYTES)
----------- ----------
java pool 20971520
large pool 4194304
shared pool 50331648
17885444
11:18:21 SQL> show sga
Total System Global Area 93394180 bytes
Fixed Size
451844 bytes
Variable Size
75497472 bytes
Database Buffers 16777216 bytes
Redo Buffers
667648 bytes
11:23:17 SQL> show parameter shared_pool
NAME_COL_PLUS_SHOW_PARAM
TYPE
---------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
----------------------------------------------------------------------------------------------------
shared_pool_reserved_size
big integer
1677721
shared_pool_size
big integer
33554432
1。v$sgastat 中的shared_pool为什么不等于show parameter shared_pool中的shared_pool呢?????
2。show sga中的fixed_sga 是什么?
Acturally, TOM has given answer since his first book.
IN:
select pool,sum(bytes) from v$sgastat group by pool;
the shared pool does not mean the real size, it contains some miscellaneous section.eg.some control file consumption
So useshow parameter shared_pool to get the real size
10g中情况如下:
SQL> select pool,sum(bytes) from v$sgastat group by pool;
POOL SUM(BYTES)
------------ ----------
java pool 8388608
large pool4194304
shared pool46137344
105897956
SQL> show parameter shared_pool;
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
__shared_pool_size
big integer 44M
shared_pool_reserved_size
big integer 2306867
shared_pool_size
big integer 0
SQL>