Memory allocation question

[MCubitt]

This is probably going to be a vague question since my understanding of the problem is equally vague.

Our CRM product is returning errors apparently linked to memory allocation.

ORA-04030 out of process memory when trying to allocate 37376 bytes (callheap, temporary memory) (ODBC)


We have limited UNIX and Oracle knowledge (but learning fast!) and would appreciate guidance of what I need to do and how to decide how much allocation.

Thanks

 

[DSMARWAY]

Hi ,

How much memory have you got installed ?

check /etc/security/limits file and check data rss and stack
entries , for the user who is running the oracle program

e.g if user fred

fred :
stack =
rss =
data =

if not unlimited i.e -1 then set them to unlimited i.e. -1
e.g rss= -1

you will then have to logout and log back in as that user to
activate those changes. to check type ulimit when logged in as that user.

The other thing to check , even though you have oracle as the underline dbase , check the application which manipulates the dbase , what settings if any can be changed
, what query are you running , is the query hammering the
box i.e. have your tables got indexes , is the query doing a sort , what is your SGA set to ?

How big is your dbase?


hope this gives you a few ideas ?

 

[MCubitt]

Thanks for your reply...

My limits file is:
default:
fsize = 2097151
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000

root:

daemon:

bin:

sys:

adm:

uucp:

guest:

nobody:

lpd:


The DB application uses "oracle" for access so should this be added?

We have 18GB memory.


Not sure how to check SGA, sorry.
We have 4 Dbs and the one in use is fairly large, 8GB I think in total.