| Author |
why the jdbc connection can't release in was5.0.2.8 ?
|
|
| was_forum 2006-04-27, 8:08 am |
| WAS 5.0.2.8 ND + solaris8 +jdbc +oracle9024
Today,I troubleshooting the jvm problem.After I update the jdk to 1.3.1_16b;modify some paremter permsize and newsize to 1/4 of jvm.
adding the http's presure. To my surprise,the jvm outofmemory wasn't appear.
but the brower http response is slower and slower.the jdbc num is reach
the max num,which is monitor with the tivoli performace tools in WAS.
but the database(oracle) is in good performance.
HOW can I determine the problem? Can i decide the situation is bottleneck is
jdbc or the problem is that jdbc connection can release in time?
thanks.
august guo
| |
| Ken Hygh 2006-04-27, 8:08 am |
| was_forum wrote:
> WAS 5.0.2.8 ND + solaris8 +jdbc +oracle9024
>
> Today,I troubleshooting the jvm problem.After I update the jdk to 1.3.1_16b;modify some paremter permsize and newsize to 1/4 of jvm.
> adding the http's presure. To my surprise,the jvm outofmemory wasn't appear.
> but the brower http response is slower and slower.the jdbc num is reach
> the max num,which is monitor with the tivoli performace tools in WAS.
> but the database(oracle) is in good performance.
>
> HOW can I determine the problem? Can i decide the situation is bottleneck is
> jdbc or the problem is that jdbc connection can release in time?
>
> thanks.
> august guo
The Tivoli Performance Viewer should be able to tell you how long each
connection is open, how long it is actually used, etc. This data should
help pinpoint the problem.
Ken
| |
|
|
| was_forum 2006-04-27, 8:08 am |
| normally,how long does the jdbc connection longer?
august guo
| |
|
| It's normally very short because you should have code like getConnection >
query database > format results > release connection.
So for a simple query, it would typically be less than a second.
| |
| was_forum 2006-04-27, 8:08 am |
| if the query is very simply sql,eg: select * from table_a; but the table_a have many items. otherway I only get 1000 items to the memory. SO the whole result will slice to some fetch.
in fact,the terrible thing is the sql ,which execute in oracle need a little long time. the most thing is how simplify the sql (or the funcation).
anybody would give me some advice to realize the funcation using more simple sql.
thanks.
august guo
|
|
|
|