What is meant by Orphan Lock and Orphan Sessions?
1
vote
1
answer
1355
views
I have came across this term ***Orphan locks*** and ***Orphan sessions*** and I really have *no idea* what that is. I have tried to *search* it on *Google* and I still haven't got any useful info/results regarding what it mean.
*All I get till now is that orphan locks are some kind of session locks which results in deadlocks after executing query or queries.* (please correct me if I get it wrong)
*Can someone please explain this a bit ? What are Orphan Locks ? Are they the same as Orphan sessions ? How do they form and what they have to do with sessions ?*
p.s: I am still newbie to this so I apologise if it sounds all too basic.
Asked by Mohammad Zain Abbas
(111 rep)
Sep 12, 2018, 10:14 AM
Last activity: May 30, 2025, 11:04 AM
Last activity: May 30, 2025, 11:04 AM