Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 587
  • Last Modified:

Weblogic is giving time outs...

Hi,

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...
0
fouaddba
Asked:
fouaddba
1 Solution
 
yuseungkimCommented:
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 www.your-company.com, then you can ask the user to run

tracert www.your-company.com

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.




0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now