Weblogic is giving time outs...

Posted on 2006-05-16
Last Modified: 2013-12-10

My environment is weblogic and oracle 9i databases, for the last couple of days, we are getting complains from the clients (especially in UK), can't query from the web interface;
. earlier was not getting there login page
. now can't execute there queries, againts Oracle databases

can any one, assists over here, how to find the culprit, is it Oracle or Apps Server itself...

have already checked the Oracle statspack, nothing very critical the top 5 events are:

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
PL/SQL lock timer                                  45,108     451,799    33.74
CPU time                                                      422,734    31.57
db file sequential read                         6,932,960     238,700    17.83
db file parallel write                             80,753      78,172     5.84
enqueue                                            18,447      54,739     4.09

thanks in advance...
Question by:fouaddba
    1 Comment
    LVL 3

    Accepted Solution

    Hi There.

    When I got slowness problem in WebLogic Application, I usually check following bottlenecks:

    1. Network
    2. System Resource in Web Server and Application Server
    3. WebLogic
    4. Database

    1. Network

    Did you check any network delay between client and Web Server/Applicatoin Server ?

    One of easy way to check the network status is asking user to run tracert command from DOS prompt.

    For example, if your Application Server is, then you can ask the user to run


    Then it will display all of network hops and elpased time to get to your web Server/Application Server.
    (It might get failure/timeout if there is firewall).

    And also check whether there is TOO MANY CLOSE_WAIT and caused to out of file descriptor so system can't accept any new connection until
    it flush those CLOSE_WAIT connection. You can check by "netstat -an | grep "CLOSE_WAIT" | wc -l" command and this command will gives you
    the total number of CLOSE_WAIT connection. Check with your system admin for Max # of file descriptor.

    2. System Resource
    If you have utilities like as top or topas, please use it to monitor the system utilitization.
    You can also use vmstat to check system resource utilization

    3. WebLogic
    And also check Servlet Execution Time Average, WebLogic Throughput, Queue Length, and Memory Usage
    from WebLogic Administrative console.

    4. Oracle
    So you didn't find any High Buffer Gets SQL statement from statspack. If you didn't check, please try to
    identify high buffer gets SQL statement from statspack.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    Title # Comments Views Activity
    Script to start/stop Weblogic 11, 12 6 125
    Refresh JTable Content 6 193
    jersey import error 8 97
    Load testing - websockets 1 383
    This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
    Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now