 Posted 5/26/2010 10:18:36 AM
|
|
|
|
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?
|
|
|
Posted 5/26/2010 10:21:10 AM
|
|
|
|
| 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,
|
|
|
|