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

    EBS R12 (DB 11g) performance analysis


      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 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.