I recently took over managing an Oracle 11g database (Only used MSSQL in my career up to this point).
I noticed one of our production servers it is allocating more memory to the PGA than SGA. Is that normal or is something not right?
Total memory is set to 70GB
AMM is enabled.
OEM Histogram (what my manager uses to view memory allocation) says PGA usage is around 50GB. Actual usage is around 6GB.
Initialization Parameter: pga_aggregate_target = 0 (No history of revisions listed in OEM)
SP File: pga_aggregate_target = empty (No history of revisions listed in OEM)
v$pgastat shows: aggregate PGA target parameter = 51539607552 bytes
V$MEMORY_DYNAMIC_COMPONENTS shows: 51539607552 bytes and that it was modified at 10/29/2013 8:39:36 PM. I have asked everyone and no one says they touched it.
Thanks for your help.
Message was edited by: 2f4561d8-2e83-419e-87e2-e3161447dd47 added PGA information.