Is it possible for this wait event to activate/showup even when the PGA has not crossed over
I am continuously seeing this wait event in the ASH, but the PGA allocated stays well within the limit set by
I used the below queries to check.
Total PGA that is currently used:
select sum(pga_alloc_mem) from v$process;
Parameter value for
select * from v$parameter where name like '%pga%limit';
For what it is worth, the documentation seems to be scarce for this wait event and the only official source doesn't help either: https://support.oracle.com/knowledge/Oracle%20Database%20Products/2138882_1.html
PGA_AGGREGATE_LIMIT is set to 8 GB PGA_AGGREGATE_TARGET is set to 4 GB
I am getting this wait event with the following values in ASH
P1 (Limit) = 8.3 GB (approx) P2 (Margin) = 3.9 GB (approx) P3 (Growth) = 0 or some randomly large number
I am guessing P1 is the PGA_AGGREGATE_LIMIT and P2 is some sort of threshold used before the wait event fires, but I am not sure what these actually are.