3 Replies Latest reply: Mar 26, 2013 3:11 AM by fac586 RSS

    Slower Login to PRD than UAT

    Postie
      Hi am logging into my production APEX and it will take 15secs.. versus my UAT takes less than a sec

      I find the Production system slower, even in low use periods.. esp in the dev area (eg application builder)

      I am using
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      Product Build:     4.1.1.00.23
      Schema Compatibility:     2011.02.12
      PLSQL_GATEWAY     WebDb
      GATEWAY_IVERSION     3
      SERVER_SOFTWARE     Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server

      Any Thoughts on any settings I may have wrong?

      Dean
        • 1. Re: Slower Login to PRD than UAT
          fac586
          Postie wrote:
          Hi am logging into my production APEX and it will take 15secs.. versus my UAT takes less than a sec

          I find the Production system slower, even in low use periods.. esp in the dev area (eg application builder)

          I am using
          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
          Product Build:     4.1.1.00.23
          Schema Compatibility:     2011.02.12
          PLSQL_GATEWAY     WebDb
          GATEWAY_IVERSION     3
          SERVER_SOFTWARE     Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server

          Any Thoughts on any settings I may have wrong?
          If the web server is EPG the most likely cause is an incorrectly set <tt>SHARED_SERVERS</tt> parameter. If you're using EPG check the configuration<tt>SHARED_SERVERS</tt> configuration.
          • 2. Re: Slower Login to PRD than UAT
            Postie
            No.. I am not using EPG.. I have explored the Shared_servers parameter issue
            I am using OHS..
            • 3. Re: Slower Login to PRD than UAT
              fac586
              Postie wrote:
              No.. I am not using EPG.. I have explored the Shared_servers parameter issue
              I am using OHS..
              Sorry, misinterpreted the "PLSQL_GATEWAY WebDb" entry.