PGA limits and PL/SQL Arrays
Date: Tue, 21 Feb 2023 09:45:02 +0100
Message-ID: <959d2824-6229-0cdc-5835-675fd01708a8_at_bluewin.ch>
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-lReceived on Tue Feb 21 2023 - 09:45:02 CET