21 lines
526 B
SQL
21 lines
526 B
SQL
set linesize 120
|
|
set pagesize 9999
|
|
|
|
column component format a40
|
|
column curr_mb format 99G999D99
|
|
column min_mb format 99G999D99
|
|
column max_mb format 99G999D99
|
|
column user_mb format 99G999D99
|
|
column granule_mb format 99G999D99
|
|
|
|
compute sum of curr_mb on report
|
|
|
|
break on report
|
|
|
|
select component, current_size/1024/1024 curr_mb, min_size/1024/1024 min_mb, max_size/1024/1024 max_mb,
|
|
user_specified_size/1024/1024 user_mb, granule_size/1024/1024 granule_mb
|
|
from v$sga_dynamic_components
|
|
order by component;
|
|
|
|
clear breaks
|