Sample Header Ad - 728x90

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