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.