6 Replies Latest reply on Feb 8, 2018 4:09 AM by Kanda-Oracle

    EBS Performance

    966638

      EBS version R12.2.5 and DB 11.2.0.4

       

      Instance is performing very slow , navigating from one page/form to another form is taking 5-10 min. But after the restart of the service, performance came to normal.

      The same issue occur after somedays and restart of service bring normal.

       

      Please suggest how to trouble shoot?

      What all need to check ?

        • 1. Re: EBS Performance
          Shaik

          Hi

           

          Gather stats concurrent program scheduled on weekly basis?

           

          if not run the program and check the performance

           

           

          Regards

          Shaik

          • 2. Re: EBS Performance
            966638

            Yes, it is running

            • 3. Re: EBS Performance
              mdtaylor

              Describe your architecture please.

               

              Are you using a separate middle tier from the database tier?

               

              Are you using Linux? HugePages/Large Pages on other Operating Systems?

               

              If on Linux, please run free -m and report memory usage next time before you restart services and after.

              • 4. Re: EBS Performance
                966638

                Database is in one node and application in other server.

                 

                If memory (free -m) high, such case what need to check?

                • 5. Re: EBS Performance
                  mdtaylor

                  You need to look at -/+ buffers/cache line.  In this case, the server had 256G and about 108G is used, so about 150G free.

                   

                  free -m

                              total      used        free     shared    buffers    cached

                  Mem:        258445    257492        953          0        145    149149

                  -/+ buffers/cache:    108196     150248

                  Swap:        16385       748      15637

                  • 6. Re: EBS Performance
                    Kanda-Oracle

                    Hi,

                     

                    As mentioned, Gather Stats & CPU/RAM utilization at OS level to be checked for any resource crunch.

                     

                    1. Please go through AWR report (for 60 min interval) during the problematic period. This is to check any expensive DML/Query in the system (or) Concurrent Manger sub-system.

                     

                    2. Please go through the output of bde_chk_cbo.sql as per note 174605.1  to check whether init.ora are in tact.

                     

                    Thanks

                     

                    N Kandasamy