SQL> set linesize 130
set pagesize 1000
column name format a30
column value format a30
select name, ismodified, value/1024/1024 as size_mb
from v$parameter
where name IN ('sga_target',
'pga_aggregate_target',
'memory_target',
'memory_max_target'
)
order by name;
NAME ISMODIFIED SIZE_MB
------------------------------ ---------- ----------
memory_max_target FALSE 0
memory_target FALSE 0
pga_aggregate_target FALSE 500
sga_target FALSE 12288
SQL> set linesize 130
set pagesize 1000
column name format a30
column value format a30
select name, ismodified, value/1024/1024 as size_mb
from v$parameter
where name IN ('db_cache_size',
'shared_pool_size',
'large_pool_size',
'java_pool_size',
'streams_pool_size'
)
order by name;
NAME ISMODIFIED SIZE_MB
------------------------------ ---------- ----------
db_cache_size FALSE 128
java_pool_size FALSE 32
large_pool_size FALSE 32
shared_pool_size FALSE 4096
streams_pool_size FALSE 64
SQL> set linesize 130
set pagesize 1000
column name format a30
column value format a30
select name, ismodified, value/1024/1024 as size_mb
from v$parameter
where name IN ('sga_target',
'pga_aggregate_target',
'memory_target',
'memory_max_target',
'db_cache_size',
'shared_pool_size',
'large_pool_size',
'java_pool_size',
'streams_pool_size',
'log_buffer'
)
order by name;
NAME ISMODIFIED SIZE_MB
------------------------------ ---------- ----------
db_cache_size FALSE 128
java_pool_size FALSE 32
large_pool_size FALSE 32
log_buffer FALSE 19.9609375
memory_max_target FALSE 0
memory_target FALSE 0
pga_aggregate_target FALSE 500
sga_target FALSE 12288
shared_pool_size FALSE 4096
streams_pool_size FALSE 64
10 rows selected.