3 Replies Latest reply: Mar 22, 2012 7:58 PM by Hussein Sawwan-Oracle RSS

    Oracle applications overall performance issues

    user12069198
      Need help or any expertise suggestions are appriciated.

      We are getting overall performance issues in our oracle application after we upgrade the R12.1.3 applications from 11..5.10.2 with 11gR2.0.1 database.

      Before upgrade:
      -----------------
      11.5.10.2 applications with 11.2.0.1 database with 2 node rac and 2 node applications

      after R12.1.3 upgrade:
      ------------------------
      R12.1.3 applications with 11.2.0.1 database with 2 node rac and 2 node application.
      Here just we upgraded our applications from 11.5.10.2 to R12.1.3

      We we ran top command i observed once of RAC databse consuming high CPU usage.
      with forms sessions.

      Temporary solution:
      ------------------------
      We are bouncing the application services.Then the performance was normal
        • 1. Re: Oracle applications overall performance issues
          Hussein Sawwan-Oracle
          What is your OS?

          How many nodes of the application/database servers you have?
          Need help or any expertise suggestions are appriciated.

          We are getting overall performance issues in our oracle application after we upgrade the R12.1.3 applications from 11..5.10.2 with 11gR2.0.1 database.
          Which of the application services you have performance issues with? Web/Forms/CM?

          Do you have all the patches in (Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 [ID 823587.1]) applied?

          Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12 [ID 567551.1]
          How to monitor performance in Oracle E-Business suite R12 [ID 472443.1]
          Tuning performance on eBusiness suite [ID 744143.1]
          How Can I Diagnose Poor E-Business Suite Performance? [ID 864226.1]
          E-Business Suite Diagnostics Tips and Tricks [ID 398665.1]
          Concurrent Processing - Best Practices for Performance for Concurrent Managers in E-Business Suite [ID 1057802.1]

          Performance Tuning
          https://forums.oracle.com/forums/search.jspa?threadID=&q=Performance+Tuning&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

          Thanks,
          Hussein
          • 2. Re: Oracle applications overall performance issues
            user12069198
            The o.s was Redhat linux 5.4 version.
            Linux st2dlxkn62.connectria.com 2.6.18-164.el5PAE #1 SMP Tue Aug 18 15:59:11 EDT 2009 i686 i686 i386 GNU/Linux

            We have 2 node applications and 2 node RAC database.
            Applications are shared file system?

            Regards
            Narendra
            • 3. Re: Oracle applications overall performance issues
              Hussein Sawwan-Oracle
              What is the application process you have performance issue with?

              Have you reviewed the docs referenced above?

              Thanks,
              Hussein