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 -- //www.freelists.org/webpage/oracle-l