1 2 Previous Next 15 Replies Latest reply on Oct 11, 2012 2:11 PM by Girish Sharma

    How much data canbe cache in SGA

      Hai everybody,

      my company using Oracle 11g - Production database, my os is RHEL 5.5 ,my server's physical memory is 30.9 GB ( cat /proc/meminfo ) ie the SGA size [ (30.9*40/100)=12.5 GB ] so i use 12.5GB SGA size for one instance, we need to cache some data for our application performance how much data can cache in SGA based on 12.5 GB or how to calculate how much data can cache in SGA without any performance degradation.

      Regards Benk
        1 2 Previous Next