Link dm_oracle Backend Thread to cm Thread
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.
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.
0