Re: Trying to understand PGA usage (20GB) for ONE process/session

  • From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • To: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>
  • Date: Mon, 13 Nov 2017 11:42:16 -0600

Maybe - so here's the crux of my question/curiosity.

Are there KNOWN things (such as pl/sql tables/collections) that can force
more usage of PGA that are NOT limited by _PGA_MAX_SIZE ?

I "thought" that _PGA_MAX_SIZE would limit processes but it sounds like
there are known items that can exceed _PGA_MAX_SIZE ?

Chris


On Mon, Nov 13, 2017 at 11:36 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>
wrote:

Does the program have a large pl/sql table or doing bulk collect without a
limit?




Chris Taylor <christopherdtaylor1994@xxxxxxxxx> 11/13/17 12:33 PM >>>
That query confirms the usage:

SID
SPID
TOTAL_ALLOCATED
PID
SERIAL#
CATEGORY
ALLOCATED
USED
MAX_ALLOCATED
CON_ID
100
161947
27389800644
805
172
SQL
69598064
24
87929160
0
100
161947
27389800644
805
172
Other
27320114452
27320114452
0
100
161947
27389800644
805
172
PL/SQL
88128
9216
95288
0

Now I need to understand how one session can be allocated that much
(outside of a bug/memory leak).

Chris


Other related posts: