Re: PGA limits and PL/SQL Arrays

Hello Lothar,
I think you are looking for session_pga_limit provided by Oracle's Resource Manager.

By the way PGA_AGGREGATE_LIMIT is not a "kill hard limit" as well as it kicks in a little bit later ( e.g. see Frit's analysis here: https://fritshoogland.wordpress.com/2014/12/15/oracle-database-operating-system-memory-allocation-management-for-pga/ ).

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Lothar Flatz <l.flatz_at_bluewin.ch> hat am 21.02.2023 09:45 CET geschrieben:
>
> Hi,
>
> a very basic question this time:
> Suppose I have a large number of sessions and each of those are running a PL/SQL code that fills a PL/SQL array,
> such that PGA_LIMIT is jeopardized.
> Can the database under such circumstance prevent PGA from overshooting the LIMIT?
> I suppose no, when I read: SYS processes and background processes other than job queue processes will not be subjected to any of the actions described in this section. Instead, if they are using the most untunable memory, they will periodically write a brief summary of their PGA usage to a trace file. (https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/PGA_AGGREGATE_LIMIT.html#GUID-E364D0E5-19F2-4081-B55E-131DF09CFDB3)
> I happy to learn more on this topic though.
>
> Thanks
>
> Lothar

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