File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes Performance Issue on a application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "Performance Issue on a application " Watch "Performance Issue on a application " New topic

Performance Issue on a application

Tanka Banerjee
Ranch Hand

Joined: Aug 16, 2006
Posts: 64
Dear Friends,
One of my company's application is now having performance issue.
It is made in JSP 1.2, Java 1.4, Oracle 8.1.7. It is running for 2 years
but now it is logging out automatically and also user are getting login,
they have take many tries. Mostly this problem is severe at 5 pm.
What should be my approach in solving this issue ?
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13037
Naturally my first question would be "what has changed?" - is the user load bigger, has the network configuration changed?

My next question would be "what monitoring capability do you have?" Can you watch the CPU load, disk activity, memory use, network traffic, etc. etc. to see what changes around 5pm.

Then there are always the hardware related possibilities - have the disk(s) been defragmented.

Chris Beckey
Ranch Hand

Joined: Jun 09, 2006
Posts: 116

In addition to the previous suggestions, look at the database. If memory serves correct Oracle auto-optimization was implemented or significantly improved after version 8 so the execution plans could be sub-optimal.
prasad kulkarni
Ranch Hand

Joined: Mar 19, 2006
Posts: 66
1] As the application is running from last 2 yrs, the Database size might have increased & so your sql queries are taking lot of time to access the records from database. Try to optimise the sql queries.
2] At 5 pm , the user-load might be increasing. Please verify.
3] There is possiblity that , in your application there might be a code-cache or any other cache, which might be scheduled to refresh at 5 pm everyday. Please verify this also.

scjp, scwcd
Virag Saksena
Ranch Hand

Joined: Nov 27, 2005
Posts: 71
What application server are you using ?
Download Auptyma's Java Application Monitor, deploy it and observe the JVMs in question at 5 PM ? What do you see happening ? Do you see a lot of requests waiting for a lock ? Or are folks waiting for a database wait or network wait ?

It will tell you where the bottleneck is happening.



<a href="" target="_blank" rel="nofollow">The Peak of Performance</a>
Rahul Toaikani
Ranch Hand

Joined: Feb 14, 2007
Posts: 36

Was it resolved? Any updates?
I agree. Here's the link:
subject: Performance Issue on a application
It's not a secret anymore!