Thanks for the question, Gyan.
Asked: October 04, 2019 - 9:13 am UTC
Last updated: October 07, 2019 - 1:32 am UTC
Version: 12c
Viewed 1000+ times
You Asked
In our production environment, sometimes table lock occurs. During table lock, i have identified the blocker and holder session, and sqls. While checking one session is on inactive session, and query for both sessions are like "SELECT" statements. How can we track each rows, datafiles level tracking, and actually why/how the one session cause table lock for other session??
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment