In our environment, we have an application that runs queries and they block each other for some tables. I want to know which all sessions and which all tables are in blocked state with that ID? i went to table dbc.monitorsession_hst_TZ and pulled the data. I can see that there are columns like - blk3objdbid and blk3objtid that i think contains the databaseid and tableid of the blocked tables. My questions are below :
1.how to map these IDs to the tablename and databasename ?
2. Is this the right table where i am looking into ? is there another/better way to find this ?
Solved! Go to Solution.