This discussion is archived
10 Replies Latest reply: Sep 3, 2010 2:35 PM by 506791 RSS

APEX 4.1 Applicaton Performance issue!

506791 Newbie
Currently Being Moderated
Problem:
Virtual Circuit wait is running high.
Apex application pages loads much slower comparing to our old environment APEX 3.0 on 10g, apache server.

Issues after installing apex with embedded PL/SQL ... OEM showing Virtual Circuit wait is running high ... APEX application pages loads with significant delays specially when first loaded.

Environment:
New 11g server with New apex 4.0 and updated to 4.1 with embedded pl/sql, windows server 2008 64 bit.
Migrated old application from 3.0 to 4.0 ---- No problems other than performance issue, slow pages load.

The reason why I went with the embeded pl/sql and not the apache because Windows server 2008 R2 and the apache HTTP server (conpanion cd) could not be installed on this version.


We did not have this issue with 10g apex 3.0 running with an apache server?

Where can I find HTTP server for windows server 2008 R2 64 bit?

Is this an embedded PL/SQL issue install on windows server 2008 x64?

Others ...
There is no Companion Disk for the Oracle Database 11g Release 1 (11.1.0.7.0) for Microsoft Windows Server 2008 x64 therefore the Http server is not included in the install or packaged software (companion or examples). The Oracle database 10g had the HTTP server in the companion disks. The 11 g examples download does not include the APACHE HTTP Server !!!!! Did anyone find a solution for this problem, or is the prior version of Oracle database 10 R 2 -HTTP SERVER (Companion Disk) windows server 2008 x64 compatable with 11g Release 1 installed. Can I install the companion disk included in the 10g R2 (Http server) with Oracle 11 g Release 1. Again for windows server 2008 x64.


Thanks,
Mhnd
  • 1. Re: APEX 4.1 Applicaton Performance issue!
    506791 Newbie
    Currently Being Moderated
    No one is interested in finding a solution for the above problem, where are the Oracle supporters? Guru, Experts?!

    Edited by: Mhnd on Sep 2, 2010 11:34 PM
  • 2. Re: APEX 4.1 Applicaton Performance issue!
    Dimitri Gielis Oracle ACE Director
    Currently Being Moderated
    Hi Mhnd,

    The problem is the EPG as now everything comes from the database (images, files etc). When you ran Apache, it didn't need to go to the database for everything in /i/.
    Especially when you are in a multi-user environment it's not recommended to go with the EPG.

    So my recommendation is to install the APEX Listener which you find here: http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/apex-listener-155260.html
    From APEX 4.0 onwards you have 3 choices for the webserver: EPG, Apache and APEX Listener.

    I don't use Windows myself, but I believe Apache 2 runs fine on Windows Server 2008, so alternatively you can download that, install mod/plsql and go with that.

    Hope that helps,
    Dimitri
    http://dgielis.blogspot.com
    http://www.sumneva.com
  • 3. Re: APEX 4.1 Applicaton Performance issue!
    mobra Journeyer
    Currently Being Moderated
    I don't use Windows myself, but I believe Apache 2 runs fine on Windows Server 2008, so alternatively you can download that, install mod/plsql and go with that.
    Or, since you are running on Windows, you can check out the free Thoth Gateway, a mod_plsql replacement for IIS:

    http://ora-00001.blogspot.com/2010/07/apex-on-thoth-gateway-and-iis-7.html


    - Morten

    http://ora-00001.blogspot.com
  • 4. Re: APEX 4.1 Applicaton Performance issue!
    jkallman Employee ACE
    Currently Being Moderated
    Mhnd,

    1) What are the values of your database initialization parameter SHARED_SERVERS and MAX_SHARED_SERVERS?

    2) How many concurrent users are there of your instance when you experience this performance degradation?

    Joel
  • 5. Re: APEX 4.1 Applicaton Performance issue!
    506791 Newbie
    Currently Being Moderated
    Dimitri,

    Thanks for taking the time to answer my question. So you are saying the listener which is my third choice should eliminate this issue. I know oracle have three choices for the web server but I'm only familiar with the two mentioned above, the APEX installation document provide information about the listener but haven't gone that path yet. The apache 2 only comes packaged for 32 bit systems (last I checked 2.16), and they don't have the 64bit version. I'm going to try the listener approach and see how it goes. Hopefully this will solve the issue with page loading slow. Should I uninstall the embedded PL/SQL or just continue with the listener install?

    Mobra,

    Thanks for your suggestions but I'm going to stick with the Oracle suggested methods for now. Hopefully some will work out for our environment.

    Thanks,
    Muhannad.
  • 6. Re: APEX 4.1 Applicaton Performance issue!
    506791 Newbie
    Currently Being Moderated
    SQL> show parameter shared_servers

    NAME TYPE VALUE

    max_shared_servers integer
    shared_servers integer 1

    We are still in testing environment (11g - APEX 4.1) and haven't released the new server yet (USED THE EPG SERVER) about 2 to 3 users. Our production still using the old server Oracle 10g - 3.0 APEX (No problem here we are using the APACHE SERVER)

    Edited by: Mhnd on Sep 3, 2010 9:07 AM
  • 7. Re: APEX 4.1 Applicaton Performance issue!
    jkallman Employee ACE
    Currently Being Moderated
    Well, that's your problem right there.

    1) Connect as SYS in SQL*Plus
    2) Issue the statement: ALTER SYSTEM SET SHARED_SERVERS = 10
    3) Sit back and watch your performance skyrocket

    http://download.oracle.com/docs/cd/E17556_01/doc/install.40/e15513/otn_install.htm#CHDEGJBF

    Joel
  • 8. Re: APEX 4.1 Applicaton Performance issue!
    506791 Newbie
    Currently Being Moderated
    WooOoow!

    That definitely did it for us!

    Thank you so much and can’t thank you enough! I was going to go a totally different approach; I don't know how I missed that!!!!

    Thanks again,
    Mhnd

    Edited by: Mhnd on Sep 3, 2010 9:55 AM
  • 9. Re: APEX 4.1 Applicaton Performance issue!
    mobra Journeyer
    Currently Being Moderated
    jkallman wrote:
    3) Sit back and watch your performance skyrocket
    Also known as the "FAST = TRUE" parameter :-)

    - Morten

    http://ora-0001.blogspot.com
  • 10. Re: APEX 4.1 Applicaton Performance issue!
    506791 Newbie
    Currently Being Moderated
    Very creative thanks for your help.

    :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points