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
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

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 11.2.0.3 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?

Thanks
Prashant
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: 68625
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: Thu Mar 28 14:45:39 CDT 2024