Database Memory & 4030/4031 (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center