10g开始，内存参数如shared_pool_size,db_cache_size在sqlplus中用show parameters都会显示为0，那么在当前状态下如何获得各个pool的值呢？[@more@]

1.data buffer pool：

SQL> select current_size from v$buffer_pool;

CURRENT_SIZE
------------
3312

2.其他的pool

SQL> select pool,sum(bytes)/1024/1024 from v$sgastat group by pool;

POOL SUM(BYTES)/1024/1024
------------ --------------------
3327.99767
shared pool 736.00457
large pool 16
java pool 16