ORA-04030 error keep on coming in productive environment
Hi All,
Can anyone help me identify, why are we keep on getting ORA-04030 error in our Oracle database 12c enterprise edition installed on AIX machine. Last time when the error encountered I had doubled the size of below parameters,
alter system set sga_max_size=9G scope=spfile;
alter system set sga_target=9G scope=spfile;
alter system set pga_aggregate_target=3G scope=spfile;
However, the issue re-occurred again in a month, so then I set AIX OS ulimit parameter for data and files to -1 (unlimited). But it looks like the issue re-occurred again.
Now, I have no clue what to do, I had just restarted the database and for now it is working ok but I am not sure for how long. Can someone help me reach to the root cause of the issue?