Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PGA allocation larger than SGA

datsun80Oct 30 2013 — edited Nov 4 2013

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.

This post has been answered by datsun80 on Nov 4 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2013
Added on Oct 30 2013
37 comments
5,593 views