Home » RDBMS Server » Server Administration » Module not getting populated in V$SESSION (11g - Enterprise Linux)
Module not getting populated in V$SESSION [message #606571] Mon, 27 January 2014 02:28 Go to next message
Messages: 89
Registered: May 2005
Location: chennai

We have Oracle Database 10g and Oracle warehouse builder (OWB) configured in the same server(10g)- Enterprise Linux.

Now we have upgraded database and warehouse builder to version.

Before upgrade, when any jobs are triggered in the OWB side, we can track the session by module column in V$session (module will show the process Name).

Now after 11g, this module column is not getting loaded with expected output. so dev team have problem on identifying the session id (sub process flow) and kill it.

Could anyone please shed some light how to get this module column to be updated?

Re: Module not getting populated in V$SESSION [message #606591 is a reply to message #606571] Mon, 27 January 2014 03:53 Go to previous message
Michel Cadot
Messages: 62229
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This column is set by the application using DBMS_APPLICATION_INFO.SET_MODULE procedure.

Previous Topic: Archive log issue
Next Topic: Data missing
Goto Forum:

Current Time: Sun Nov 29 04:55:04 CST 2015

Total time taken to generate the page: 0.07694 seconds