CODEWITHSUNDEEP
sqloracle-databasememory
iammuruga
iammuruga

Reputation: 61

ORA-4030 Oracle : How to resolve

In our oracle server(10 g), we are getting ORA-4030 error on sometimes.

ORA-04030: out of process memory when trying to allocate nn bytes

We understood it is related with memory size adjustment. We are trying some memory settings.

Other than this, wanted to know,

(1) Any specific SQL query usages will be cause this kind of error

(2) any Oracle SQL query tuning can be applied to avoid this

Your replies will help.

Thanks in advance.

Upvotes: 2

Views: 2994

Answers (2)

Aussie Craig
Aussie Craig

Reputation: 772

One thing which could be contributing to the error, is not freeing cursors. In .net a SQLStatement = a db cursor. Make sure that the applications are closing (and disposing) the SQL statements it is using.

Upvotes: 1

Sacx
Sacx

Reputation: 6392

1) The sorts,distinct, group and join hashes are the most probably to give you this error! 2) What OS do you use? In linux you can see what resources do you for your users with ulimit -a.

You should increase the memory per process for PGA.

Regards

Upvotes: 2

Related Questions