Fwd: jdbc - connection pool and connect frequency
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 02 Dec 2010 23:35:15 +0100
Just to add some questions: if the messages below represent "normal"
application
connection requests that use already established connection pool physical
connections, why the port, assigned by the listener, changes with every
request?
I mean, why this is happening more than once for a single physical
connection?
I don't seem to find an explanation/documentation on how exactly the
Oracle listener
handles jdbc connection pool requests.
Regards
Dimitre
-------- Original Message --------
Subject: jdbc - connection pool and connect frequency
Date: Thu, 02 Dec 2010 17:58:42 +0100
From: Radoulov, Dimitre <cichomitiko@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Hi all,
I'm trying to understand what exactly the following entries represent
(notice the frequency) ?
We have more than one application that use connection pooling through
jdbc and listener logs that contain many entries like the these:
02-DEC-2010 17:34:18 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=34505)) * establish *
<my_host> * 0
02-DEC-2010 17:34:18 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=34504)) * establish *
<my_host> * 0
02-DEC-2010 17:34:18 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=34506)) * establish *
<my_host> * 0
02-DEC-2010 17:42:03 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=44922)) * establish *
<my_host> * 0
02-DEC-2010 17:44:07 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=45124)) * establish *
<my_host> * 0
02-DEC-2010 17:44:10 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=45143)) * establish *
<my_host> * 0
02-DEC-2010 17:44:10 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=45144)) * establish *
<my_host> * 0
02-DEC-2010 17:44:10 *
(CONNECT_DATA=(SID=<my_host>)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=<my_host>)(PORT=45145)) * establish *
<my_host> * 0
I suppose these are connect requests that use already established
connections from the connection pool and not new connections given
v$session.logon_time does not reflect the timestamp reported in the
listener log file, am I right?
Does anybody know how these requests are/could be controlled?
Regards
Dimitre
Other related posts:
- » Fwd: jdbc - connection pool and connect frequency - Radoulov, Dimitre
