Billing and Revenue Management (MOSC)

MOSC Banner

Link dm_oracle Backend Thread to cm Thread

edited Feb 10, 2012 2:54AM in Billing and Revenue Management (MOSC) 2 commentsAnswered
We have a situation where some of the sql sessions originated from dm_oracle are causing blocking locks in db and they are not getting released. Currently we are blindly killing such sql sessions in DB. But we would like to know which cm connection is linked to this particular sql session by linking a particular dm_oracle backend thread to cm thread?

We can link dm_oracle backend thread to dm_oracle frontend thread by looking into  output of " robj - database_number /status_dm 1 ".
But we are not able like dm_frontend thread to cm threads.
Can anyone suggest if this is possible to do and how.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center