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 ? Thanks Tanka
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.
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.
Tanka, 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="http://www.auptyma.com" target="_blank" rel="nofollow">The Peak of Performance</a>