Connection close issue

[sreedhar Lackka]

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]

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]

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 ]