program column in v$session

[staffanmw]

How do 'set' my application name to the program column in the v$session view?

 

[Marco Kalter]

As far as I know you can only set the module and action columns through the dbms_application_info package.

------------------
Marco Kalter
Allround Automations

 

[staffanmw]

Well, I see what you meen .. but, if I run a query on v$session from PLSQL Dev I get the following result:

select terminal, program
from v$session
where schema# != 0

TERMINAL PROGRAM
--------- ----------------
SNAKE
SNAKE PLSQLDev.exe
SNAKE PLSQLDev.exe

The empty value in the program column is my own app running DOA.

The Module and Action is something else, as I see it.

 

[Marco Kalter]

In PL/SQL Developer we don't do anything to provide the plsqldev.exe program name. I assume this is a standard Oracle feature, and I'm not sure under which conditions this column would be empty. If I run the DeptEmp demo project, I see deptemp.exe in the v$session view.

------------------
Marco Kalter
Allround Automations