How can I set the application information on a session using the Oracle thin JDBC driver?

Question

I'd like to change the application information that is shown when inspecting Oracle 10g sessions using the Oracle Enterprise Manager application:

Application Information  
  Program       'my program'  
  Module        'something'  
  Command       UNKNOWN

I'm using the JDBC thin driver to connect, and I have to admit I'd rather not use the OCI driver if at all possible. Can I do this with the thin driver, and if so, how?

score 2 · Accepted Answer · answered May 08 '09 at 20:55

2

DBMS_APPLICATION_INFO should take care of that:

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_appinf.htm

answered May 08 '09 at 20:55

Pop

3,932
1
17
12

score 1 · Answer 2 · answered May 08 '09 at 18:29

1

use the appropriate method within the DBMS_APPLICATION_INFO package (.SET_ACTION, .SET_CLIENT_INFO, .SET_MODULE

answered May 08 '09 at 18:29

dpbradley

11,645
31
34

uh... at risk of coming off as dense, what is the "DBMS_APPLICATION_INFO" package? – Chris R May 08 '09 at 20:24

How can I set the application information on a session using the Oracle thin JDBC driver?

2 Answers2