3 Replies Latest reply on Mar 25, 2016 1:33 PM by Bashar.

    Recommended Database Parameters

    Ramaraju

      Hi,

      Could anyone please help what are the recommended database parameters.

       

      We have EBS R12.2.4 with 11.2.0.4 database.

       

      $ free -m

                   total       used       free     shared    buffers     cached

      Mem:         32064      21684      10380          0        781      11873

      -/+ buffers/cache:       9030      23034

      Swap:        30717          0      30717

       

      tmpfs                  16G  3.0M   16G   1% /dev/shm

       

      Please help, how much value we need to set for the SGA, PGA, sessions, processes etc ... parameters. And what other parameters we need to set for performance.

       

      Thanks,

      Ramaraju