FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / Non-Coded Errors and Alerts / "jdbcclient" in V$session / Latest Posts

RE: "jdbcclient" in V$session

Admin — Wed, 26 May 2010 10:21:10 GMT

There are a couple of bugs filed for v$session info when using connection pooling. (bug# 1699087 and bug# 1290469) That is for previous releases of Oracle.

There are some new bugs : Bug 3735857 for newer releases of Oracle.

BUG:3735857 - OSUSER FIELD DOES NOT POPULATE IN V$SESSION USING JDBC 10G
NOTE:3735857.8 - Bug 3735857 - V$SESSION.OSUSER not populated for JDBC clients

Hope this information helps.

Thanks,

"jdbcclient" in V$session

Admin — Wed, 26 May 2010 10:18:36 GMT

I noticed in v$session, some of the sessions have "jdbcclient" under MACHINE column and "JDBC-1.0-Client" under PROGRAM column. I've searched through metalink, but found no one so far can really find a way to identify the source of these sessions. Some of the metalink posts said prior to 8.1.7, there is no way to identify where the sessions come from. However, I have 10.2.0.3 running on Red Hat Linux and I still see the same thing.

Is there anyone who has a way to identify which machines the sessions come from?