2 Replies Latest reply: Apr 4, 2013 9:11 AM by Sharon RSS

    Application Express Response Time Slow

    Sharon
      Hello,
      I am brand new to being a DBA and have not really been trained in how to be a DBA. We have recently moved our system to a Windows Server 2008 R2 box with Application Express 4.2.1.00.08 and
      Listener 2.0 with ASM. During a certain time range we have several users trying to access the same program. It doesn't take very many users to lock up the system so that no one can get to it. I would
      really appreciate any help in trying to solve this problem. Thank you in advance!

      Sharon
        • 1. Re: Application Express Response Time Slow
          jariola
          Hi,

          Check web server and database logs if there is useful information about problem.

          You should try debug application
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/debug.htm#HTMDB10000
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/debug_tuning.htm

          These blog post might also help
          http://joelkallman.blogspot.fi/2011/12/high-cpu-usage-and-apex-again.html
          http://joelkallman.blogspot.fi/2011/10/high-cpu-waits-and-sql-from-oracle-apex.html


          Regards,
          Jari
          -----
          My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
          Twitter: http://www.twitter.com/jariolai
          • 2. Re: Application Express Response Time Slow
            Sharon
            Thanks! I will check them out. I am pushing time right now, but when I have a chance I will mark if the question has been answered or not. Thanks again!