Find out DB locks in a DB account or Instance and kill the process

 To find out the DB  lock on a particular DB account  

 To find out the DB  locks on all the Databases of a DB instance  

 To  create commands to kill the DB locked sessions  - fire below alter commands to kill 

respective DB sessions& locks