Hi All,
Using Oracle 11.2.0.1 on windows.
After setting the pga_aggregate_target why is the value different in v$memory_dynamic_components and v$pgastat?
SQL> alter system set pga_aggregate_target=128M scope=spfile;
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 662700608 bytes
Database Buffers 398458880 bytes
Redo Buffers 5595136 bytes
Database mounted.
Database opened.
SQL> select component, (current_size/1024/1024) "Size(Mb)" from v$memory_dynamic_components;
COMPONENT Size(Mb)
---------------------------------------- ----------
shared pool 352
large pool 8
java pool 16
streams pool 0
SGA Target 768
DEFAULT buffer cache 380
KEEP buffer cache 0
RECYCLE buffer cache 0
DEFAULT 2K buffer cache 0
DEFAULT 4K buffer cache 0
DEFAULT 8K buffer cache 0
COMPONENT Size(Mb)
---------------------------------------- ----------
DEFAULT 16K buffer cache 0
DEFAULT 32K buffer cache 0
Shared IO Pool 0
PGA Target 256
ASM Buffer Cache 0
16 rows selected.
SQL> select * from v$pgastat;
NAME VALUE UNIT
---------------------------------------------------------------- ---------- ------------
aggregate PGA target parameter 268435456 bytes
aggregate PGA auto target 196982784 bytes
global memory bound 53686272 bytes
total PGA inuse 49675264 bytes
total PGA allocated 75768832 bytes
maximum PGA allocated 82322432 bytes
total freeable PGA memory 15728640 bytes
process count 34
max processes count 35
PGA memory freed back to OS 79167488 bytes
total PGA used for auto workareas 0 bytes
NAME VALUE UNIT
---------------------------------------------------------------- ---------- ------------
maximum PGA used for auto workareas 1483776 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 0 bytes
over allocation count 0
bytes processed 22456320 bytes
extra bytes read/written 0 bytes
cache hit percentage 100 percent
recompute count (total) 114