查oracle资源,查询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                                  33,554,432                   50,331,648

large_pool_size                         0                                   0

log_buffer                                      14,302,208                   14,469,120

open_cursors                              800                               800

sessions                                  96                               400

sga_max_size                                    4,613,734,400                 13,304,332,288

shared_pool_reserved_size               227,143,581                232,364,441

shared_pool_size                        2,281,701,376               4,647,288,832

sort_area_retained_size                 0                        0

sort_area_size                                  2,097,152                  65,536