This discussion is archived
4 Replies Latest reply: Jan 1, 2013 11:53 PM by 979666 RSS

memory optimization question

979666 Newbie
Currently Being Moderated
Hi all,

I'm new oracle administration and just started taking on the job. Sorry if similar thread have been posted. Kindly redirect me to the similar posts if there already are.

I'm currently administering oracle 9i and notice frequent database crashes generating core dump. In appears that there isn't enough memory to handle the queries, and sometimes connection pool limit also occurs.

Can I ask for help on how to check if the memory in my database are optimized, and how to increase the memory to the optimized value?

Let me know what information you need and the queries you need me to run to get the information.

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points