3 Replies Latest reply: Dec 30, 2012 6:22 AM by Srini Chavali-Oracle RSS

    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.