3 Replies Latest reply on Dec 30, 2012 12:22 PM by Srini Chavali-Oracle

    SGA TUNING

    941949
      can anybody please tell me,how can i tune SGA which includes
      1)tuning of buffer cache(min value,max value and when to increase its size),
      2)tunning of shared pool(min value,max value and when to increase its size),
      3)tuning of library cache(min value,max value and when to increase its size),
      4)tuning of dictionary cache(min value,max value and when to increase its size),
      5)tunning the redo log buffer(min value,max value and when to increase its size) and
      6) tuning the sort area(min value,max value and when to increase its size).

      your help appreciated,thanks.