• Post Reply Bookmark Topic Watch Topic
  • New Topic

Tomcat Oracle issue

 
pra gho
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
In our web development project, we have Oracle 9i installed on Win2K Prof Server.Tomcat ver -5.0.28 is also installed on the same.
Project architecture is having Struts framework (v1.2), Spring (1.1.2) & Hibernate framework (2.1). All these components are installed on a Intel-P4, 512Mb Ram windows box.
We are facing follwoing issue -
After login, it takes lot of time (20 - 30 minutes) to load further subsequent pages. We have tried to find out but have no idea why this is happening. We would like to know whether this is a Tomcat issue or a Oracle 9i (on Win2K) or hibernate framework issue. Highly appreciate, if someone can throw lights on this & guide us in identifing the root cause.
Thanks in advance.
- Prashant
[ December 13, 2004: Message edited by: pra gho ]
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What did you do to try to find out until now, and with what findings?
 
Sivaraman Lakshmanan
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
This seems to ba a interesting problem. Are u trying to do any authentication with the login name if so, check if this reteives the expected result in the current duration.
Also check if somewhere something is going on infinite loop. so that the loops continues for say 20 mints after which the system may kill it(not sure).
Are u able to see the correct page after the time u specified, if yes then its some indexing issues in oracle or a logic problem (a guess)
Just try to refactor your code and try again.
 
kumar Reddy
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
just try to use some existing profilers and find out where most of the time is spent, that is whetehr in your code, or in the tomcat, or in hibernate, so that you could have a clear pic of which method is taking most of time..and drill down into details of the method..if the method which has query is taking more time..then use some tool to find out the retrival time of query..so you could findout where max time is consumed

hope that it helps
 
Allen Whirai
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I�ve got exactly the same problem, did you resolve it?

Have a nice day

Allen
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!