Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection close issue

 
sreedhar Lackka
Ranch Hand
Posts: 154
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
Thanks a lot in advance.
We are facing a serious problem with Connections.
How can I identify through programatically how many connections are opening and closing while browsing the application.

Is there any way to find out in Java/Oracle to find out open connections.
Without verifying line by line code beacuse we 1000 files.

Please help me .

Reagards,
Sreedhar
 
sudipto shekhar
Ranch Hand
Posts: 823
Chrome Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I went though the documentation and found no such method to do that.

Anybody, lease correct me if I am wrong.

Thank you.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are using a connection pool this may be able to tell you. Oracle has various management views you ca use (e.g. v$session) which will tell you a lot about active connections. Have a look through the Administrators Guide.

Neither of these are programatic. But using Oracle's admin stuff you should be able to find out if you are hitting the limit allowed and change that limit accordingly.
[ December 11, 2008: Message edited by: Paul Sturrock ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic