set echo off
set feedback off
set heading off
set line 300
col name format a50
col value format a20
select 'AUTOMATIC PGA MEMORY MANAGEMENT' from dual;
select p.name, p.VALUE/1024/1024 "Mb", s.VALUE/1024/1024 "sMb" from v$parameter p full outer join v$spparameter s
on p.name=s.name
where P.name in ('pga_aggregate_target','pga_aggregate_limit');
select p.name, p.VALUE, s.VALUE from v$parameter p full outer join v$spparameter s
on p.name=s.name
where P.name=('workarea_size_policy');
select '(ASMM) AUTOMATIC SHARED MEMORY MANAGEMENT' from dual;
select p.name, p.VALUE/1024/1024 "Mb", s.VALUE/1024/1024 "sMb" from v$parameter p full outer join v$spparameter s
on p.name=s.name
where P.name in (
'sga_target',
'sga_max_size');
select '(SGA) MEMORY MANAGEMENT ' from dual;
select p.name, p.VALUE/1024/1024 "Mb", s.VALUE/1024/1024 "sMb" from v$parameter p full outer join v$spparameter s
on p.name=s.name
where P.name in (
'sga_target',
'db_block_buffers',
'shared_pool_size',
'log_buffer',
'large_pool_size',
'java_pool_size',
'streams_pool_size');
select 'AMM AUTOMATIC MEMORY MANAGEMENT' from dual;
select p.name, p.VALUE/1024/1024 "Mb", s.VALUE/1024/1024 "sMb" from v$parameter p full outer join v$spparameter s
on p.name=s.name
where P.name in (
'memory_target',
'memory_max_target',
'sga_target',
'sga_max_size');
set echo on
set feedback on
set heading on
ADVISOR FRAMEWORK
PGA
V$PGA_TARGET_ADVICE DBA_HIST_PGA_TARGET_ADVICE
SGA (ASMM)
V$SGA_TARGET_ADVICE DBA_HIST_SGA_TARGET_ADVICE
MEMORY (AMM)
V$MEMORY_TARGET_ADVICE DBA_HIST_MEMORY_TARGET_ADVICE
DB Cache
V$DB_CACHE_ADVICE DBA_HIST_DB_CACHE_ADVICE
JAVA POOL
V$JAVA_POOL_ADVICE DBA_HIST_JAVA_POOL_ADVICE
STREAMS POOL
V$STREAMS_POOL_ADVICE DBA_HIST_STREAMS_POOL_ADVICE
SHARED POOL
V$SHARED_POOL_ADVICE DBA_HIST_SHARED_POOL_ADVICE
