| Module not getting populated in V$SESSION [message #606571] |
Mon, 27 January 2014 02:28  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
