check memory_target and memory_max_target

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26664718/viewspace-2212416/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26664718/viewspace-2212416/