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
server processes?

01-29-2003, 04:33 PM

marist89

Depends, look in v$session.server

01-29-2003, 05:16 PM

dorothy

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?

01-29-2003, 05:29 PM

marist89

Depends, are you using a connection pool?

01-29-2003, 05:50 PM

dorothy

Yes I'm using connection pool

01-29-2003, 05:52 PM

Mnemonical

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.