Database Memory & 4030/4031 (MOSC)

MOSC Banner

PGA usage/content

edited Oct 22, 2012 4:23AM in Database Memory & 4030/4031 (MOSC) 11 commentsAnswered
Hello,

Is there a way to find out what the PGA currently used by a process is made of? For example:

USERNAME        SID   SPID     LOGON_TIME         PROGRAM                PID_REMOTE                Used MB Allocated MB Freeable MB   Max MB
--------------- ----- -------- ------------------ ---------------------- ------------------------ -------- ------------ ----------- --------
USER1           1056  20789    06-JUL-12         PROGRAMx (              18000                       622.0        714.0         7.0    714.0

The current session is using 622M, allocating 714 but it can only free 7Mb

How do I know what it is using the memory in and how can I force it to release it? (killing the session wouldn't be an option)

thanks in advance!

Daniel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center