Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Swap Space getting used Up on DB server : ora-04030 Out of Process Memory

User_I8BAAOct 1 2016 — edited Oct 2 2016

Hello Team,

,My Oracle database on Solaris 10 keeps crushing when i bring it up with the error below

ORA-04030: Out of Process Memory when trying to allocate 328136 byes (PLS PAG hp, PL/SQL STACK)

Also my swap on the server get swallowed up and the db crushes.

Swap space is 64 GB and Memory is 64 GB.

There is no error in the alert log.

Kindly help with your kind suggestions.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2016

Added on Oct 1 2016

#general-database-discussions

10 comments

1,088 views