Re: jdbc - connection pool and connect frequency

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Fri, 3 Dec 2010 12:01:00 +0800
Message-ID: <AANLkTi=oUqjnGwEYa+8+B2tR9FZpAdnYn1kcwuergVJ0_at_mail.gmail.com>

These are *fresh* connections happening every time. They are NOT in a connection pool. It may well be that most of your application sessions are in a CP but some (separately defined) apps services are not using the CP. These may be short-lived sessions,running very quick queries and disconnecting almost imediately -- that would explain why they do not appear in V$SESSION. If you have SESSION AUDIT enabled you would see them in DBA_AUDIT_SESSION. Another possibility is that they are rogue connections that connect but not authenticate, thus not creating database sessions at all.

Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone

On Dec 3, 2010 12:59 AM, "Radoulov, Dimitre" <cichomitiko_at_gmail.com> wrote:

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

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 02 2010 - 22:01:00 CST