查询Oracle资源使用情况

SELECT trim(NAME) ||'            '|| VALUE from v$parameter
WHERE NAME IN ('sga_max_size','db_cache_size','shared_pool_size',
'shared_pool_reserved_size','large_pool_size','java_pool_size',
'db_block_size','db_block_buffers','log_buffer','sort_area_size',
'sort_area_retained_size','hash_area_size','sessions','open_cursors')
ORDER BY NAME;
TRIM(NAME)||''||VALUE
--------------------------------------------------------------------------------
db_block_buffers                        0                        0          
db_block_size                               8192                           8192       
db_cache_size                                   2,281,701,376                 8,589,934,592 
hash_area_size                                4194304                       131072     
java_pool_size             &