This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 11, 2012 7:11 AM by Girish Sharma RSS

How much data canbe cache in SGA

BenK Newbie
Currently Being Moderated
Hai everybody,

my company using Oracle 11g 11.2.0.1.0 - 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

Legend

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