Hallo,
My environment is Oracle 12.2 on windows 10.
My database has been running properly for over a year but suddenly, its having performance problems because of running out of memory. I have read in some articles that running;
alter system set pga_aggregate_limit = 0;
will reset the pga to pre-12c levels. I have done this and it doesn't seem to help. I cant even run a simple procedure or even a simple function that selects a single record. They all end up with
ORA-04030: out of process memory when trying to allocate 8216 bytes (PLS PGA hp,PL/SQL STACK)
I have tried to debug this issue for the last three days but nothing seems to work. I have run out of ideas on how to resolve this issue.
Any help is appreciated.
Eric.