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

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_at_gcrta.org> wrote:

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

> >>> Chris Taylor <christopherdtaylor1994_at_gmail.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l