Resource manager session_pga_limit has it’s own limits
Recently we hit an issue with a complex SQL statement (formatted was 44,000 lines, maybe subject of a separate blog post), causing the CBO to struggle consuming large amounts of PGA memory, and the host to start swapping memory and impacting other database users. The pga_aggregate_limit parameter did not appear to be kicking in (maybe …
Resource manager session_pga_limit has it’s own limits Read More »