SGA STAT NOTES:
  • Statistic Name - SGA component name
  • Pool - Designates the pool in which the memory in NAME resides. Value can be LARGE POOL - Memory is allocated from the large pool or SHARED POOL - Memory is allocated from the shared pool
  • Bytes - Memory size in bytes

  • The "free memory" value is an indicator of the free contiguous memory in the shared pool. If this value is constantly low or is reduced in a short period of time after database startup, it is a good indicator that your shared pool should be increased. In the case where free memory is low, a stored package or procedure may result in an error, since there may not be enough contiguous memory to load the object into the shared pool.
  • Pay close attention to highlighted items