Oracle Forms initial report screen very slow

Posted on 2007-07-27
Last Modified: 2013-12-01
I am running an application that uses Oracle Forms version  I have a demo server and a couple of production servers running the same application.  On my demo server anytime I attempt to bring up a report screen it takes about a full 2 minutes for the initial screen to run - the screen where I enter the initial report parameters.  The actual reports will run in just a few moments but everytime I bring up an initial report screen I have that nearly 2 minute delay.

All of my data entry screens come up very quickly, even the ones that are pre-populated with data.  I am not sure how to troubleshoot this at this point and am willing to to take just about any suggestion at the moment.....

Question by:jmdowling
    LVL 3

    Expert Comment

    If this does not happen on your production version I would check:

    1. The demo servers firewall settings.
     - turn on reject logging to see if any connections are being thrown out.

    2. Check all httpd.conf parameters
     - make sure all the parameters in the httpd.conf for demo and production servers are the same.
    LVL 6

    Accepted Solution

    You're calling a report from a form right?  Can you show the code that calls that report?  And what format are you calling the report to be in (e.g. pdf, html, etc.)?  Can you provide the URL to the report once it comes up?  

    What do you have set in the $ORACLE_HOME/reports/conf/{rep_server_name}.conf for the reports servlet engine?  Can you include those engine settings in your response?

    More - do you have reports tracing enabled?  you can set this in $ORACLE_HOME/reports/conf/  Set the ff params:


    Output will be in $ORACLE_HOME/reports/logs/{rep_server_name}/rwserver.log

    LVL 6

    Expert Comment

    BTW - be sure to bounce the app server after making those changes....

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
    There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now