7 Replies Latest reply on Oct 20, 2016 9:10 AM by Kanda-Oracle

    Performance Issues


      Hi ALL,


      EBS R12.1.3



      We encountered performance issues in our EBS,

      Aside from checking alert logs and programs running, along with CPU and Memory usage.

      Is there logfiles in the apps tier that captures performance issues?


      Kind regards,


        • 1. Re: Performance Issues

          Hi JC


          Exactly what is the problem you are facing?


          Login slow or forms slow or concurrent issue


          Check is there any long running concurrent programs,

          Check what is the process causing load on server with TOP command.


          You can check opmn logs under $LOG_HOME/ora/10.1.3/opmn


          application.log & server.log under $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_*




          • 2. Re: Performance Issues

            Hi JC,


            1. Need to examine 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. Check out the output of bde_chk_cbo.sql as per note 174605.1  to check whether init.ora are in tact.


            3. Do you see any IO wait at OS level (you can use sar command to check this).


            sar 2 20 (from DB & Apps tier )








            N Kandasamy

            • 3. Re: Performance Issues

              Thanks ALL,


              We login at forms, and view the transactions. When the detail line reached 500 or more and we browse the last line to update or insert data, it will hang for a long time. It seems it is extracting lots of parent and child record links?

              We also monitor the Memory and CPU usage using "top" but the resource usage is just very minimal.

              How can a FORM process be too slow but does not show in CPU or Memory usage, or does not eat CPU & Memory


              Below image is sample screen shot with batch details module. The navigation for this module is  OPM Process Execution User>Batch Details.



              As the lines increase more, the browsing will start to hang.


              Please help....


              Kind regards,

              • 4. Re: Performance Issues



                Can you enable Trace with Wait event to see if the delay was due to DB side (or) Forms Side



                N Kandasamy

                • 5. Re: Performance Issues
                  Pravin Takpire

                  When you try to fetch records, database will have to provide you lot of records and this requires fetching of records from database. I would suggest you take forms trace and find out where exactly time is being spent.

                  Also need to check if this is happening only with this form or other forms also. It may be forms issue, based on forms version.


                  R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications (Doc ID 438652.1)


                  Check above note for forms trace




                  • 6. Re: Performance Issues

                    Hi Kanda,


                    Re > Check out the output of bde_chk_cbo.sql as per note 174605.1


                    Why is that its output did not capture our EBS server's total  RAM?

                    But the CPU was listed.


                    • 7. Re: Performance Issues

                      Hi JC,


                      It mainly checks whether init.ora are in tact or not.  If you find any discrepancy in the report, you need to fix .


                      To know RAM you may check AWR report or OS tools


                      Hope this answers!




                      N Kandasamy