Oracle memory problem
All of a sudden we are observing that the Oracle.exe is consuming a lot of memory (150MB) in our server (which holds 256mb Rram). As a result our EAI tool application keeps hanging very frequently and this has now become a major problem. How to clean the table space and how can we free more memory?
Thanks in advance
Has there been any changes to the SGA parameters for the DB or is there a sudden increase in the number of users or the the size of the queries they are executing?
256Mb seems small to be running both Oracle and an EAI tool on the same box.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Rebuild Indexes and other database mantainence activities.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
By the way what is EAI, is it Enterprise Application Integrator from IPLANET ??
"There is a difference between knowing the path and walking the path."
Is this (EAI) a SIEBEL specific tool ?
OCP 8.0, 8i, 9i
Re: Oracle memory problem
What do you mean by clean the table space ????
Originally posted by lavanya_s How to clean the table space and how can we free more memory?
The cleaning of tablespace is not at all the criteria, remedy is either extending the space in the datafile allocation or monitor the transaction level and moreover the regularised EAI which is consuming 150MB is small amount considering the application size,......understandable. So it is your prerogative to enhance the SGA size since your application is growing.
Click Here to Expand Forum to Full Width