v$session

When I use v$session, i am able to see all oracle clients connected by m/c names etc. parameters. But when java clients are connected only jdbcclient shows up in all relevant columns. How can I see the machine or terminal names of java clients connected only via jdbc. Which other views and tables of the 1500+ help me.
LVL 17
k_murli_krishnaAsked:
Who is Participating?
 
dbasupportCommented:
I don't have jdbc users, but try this anyway

select decode(a.type,'BACKGROUND','BACKGROUND',a.username) "Username",
       a.sid "Session ID" ,
       a.serial# "Serial #",
       a.status "Status" ,
       a.osuser "OS User",
       b.spid "OS Process ID",
       a.machine "Machine Name",
       a.program "Program",
       TO_CHAR(a.logon_time,'dd-Mon-YYYY HH24:MI:SS') "Logon Time"
       from v$session a, v$process b where a.paddr=b.addr order by a.sid
0
 
dbaoraCommented:
Hi,
You can user the select caluse dbasupport suggested, but
you can also set four lines in your java code in order to log all clients connected:

try {
CallableStatement cs = connection.prepareCall("begin dbms_application_info.set_client_info(?); end;");
cs.setString(1,"ApplicationName - "+InetAddress.getLocalHost().toString());
cs.execute();
cs.close();
} catch(Exception e) {
System.out.println("did not manage to get local host");
}

Then you can use:
select
  client_info "Client Application Info",
  logon_time "Logon Time"
from
  v$session
where
  program like '%JDBC%';

regards,
dbaora.
0
 
k_murli_krishnaAuthor Commented:
I am sorry, dbaora i can give answer to only one. dbasupport's answer which came first solves my problem. Your's could also have but we are using atg dynamo in which we write RQL and not jdbc. thanx a lot to both of you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.