SQL Query to Find Out the Locked Objects and Type of Lock

Here is the query to find the locked object, mode of locks etc. 

Providing 2 different queries. 



SQL Query

Labels

Oracle (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer