4 Replies Latest reply on Nov 4, 2015 12:32 AM by Venkat.S

    EBS R12 (DB 11g) performance analysis

    Venkat.S

      HI Experts,

       

      I have a requirement to assess the current production performance and recommend steps to better performance

      I have below configuration

      1 DB node with 11.2.0.3 DB (on ASM)

      2 Apps nodes with EBS 12.1.3 shared application tier but no PCP enabled

       

      $>  free -m

                   total       used       free     shared    buffers     cached

      Mem:         32186      31832        354          0         20      12508

      -/+ buffers/cache:      19303      12883

      Swap:        32766       1624      31142

       

       

       

       

      sga_max_size                         big integer 12G

      sga_target                           big integer 12G

       

       

      Could you please provide me the any documents that I can use as a reference for further analysis.

       

       

      Thanks in advance appreciate your help.

       

       

      Thanks,

      Venkat