JDBC and dedicated server processes
I have 10 Java (JDBC) connections to one database.
These connections are always opened 24/7.
Questions: Does Oracle see these connections as 10 separate dedicated
Depends, look in v$session.server
Thanks Jeff, that helpled.
So, the assumption is that 10 users can use one JDBC connection to the database.
So in this case the JDBC connection is seen as a pool for 10 different users to use to connect
through one dedicated server process, right?
And from the database point of view, this is seen as just one dedicated Server process. Right?
Depends, are you using a connection pool?
Yes I'm using connection pool
in java, 10 users can use just one connection to the database if you are using design patter techniques, in other words, connection pools. You can do it using OracleConnectionCacheImpl along the singleton design patter, for example.
every DriverManager.getConnection(..) is a connection to the database, in other words, a server session.
Click Here to Expand Forum to Full Width