5 Replies Latest reply: Feb 17, 2013 1:35 AM by JohnWatson RSS

    oracle 10g, how to determine allocated memory is healthy or sufficient.

      Hi Guys,

      I have a production database.
      Currently my server has 8GB physical RAM.
      3GB is allocated to the SGA and 1GB to the PGA.
      Let's say one day there is a requirement from application (eg, weblogic) to increase connection pool from 20 to 50.
      How are we able to know whether the memory allocated is sufficient for existing load and also the increased load?
      CPU is quite straightfoward as we can generate out the cpu utilization. If utilization is low, i supposed is quite safe to increase the connection.
      Kindly share ur experiences tackling such situation.