Table Lock in Oracle
The challenge was to find out which OS user, through which DB login and from which machine the table has been locked and the type of lock that has been applied.
Situation: Application performance issue; Table Lock
Solution: Two options to find out,
1. Lock query: Sample query and sample output.