Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Very the JDBC Connection Pooling

Very the JDBC Connection Pooling

From: Sean <sean_bu_at_yahoo.com>
Date: 30 May 2003 08:47:15 -0700
Message-ID: <999ced66.0305300747.659c8d9d@posting.google.com>


By the theory, the connection pooling is a frame work for caches of database connections --- "Physically". Some of the connection have been "established", which can be verified from v$session, and others may be the open . These open connections in the pool are no way to be verified at the database level, because they have not been used for the database connections yet. How can I find/verify those have not been used the connections in the pool? Because they should be the "sockets" , can very find out at OS level. I used the following unix command, it gives all the established connections, but I want to find out not-yet connections:
 lsof -i TCP:1521.
If you or anyone could help to find out the open connections of jdbc at OS level, I will be very thankful.

As you might suggest to use 9iAS monitoring tools to find out the jdbc connection pooling infor, I used the OEM Website, it give very misleading results as such as
One time:
JDBC Usage:

Open JDBC Connections                    11,207
 Total JDBC Connections                    22,387
    Active Transactions                    0
   Transaction Commits                    0
  Transaction Rollbacks                    0

At a other time
JDBC Usage:

Open JDBC Connections                    0
 Total JDBC Connections                    0
    Active Transactions                    0
   Transaction Commits                    0
  Transaction Rollbacks                    0

We know the result were not correct/realistic. Received on Fri May 30 2003 - 10:47:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US