Here is the query to find the locked object, mode of locks etc.
Providing 2 different queries.
SQL Query
Hot Topics
- How to Find out / Check SGA and PGA size of Oracle Database?
- SQL Query to Find Out Oracle Session Details for a Past Time Period from the History tables
- Stop / Drop Scheduled / Running jobs in Oracle
- Oracle NO_INDEX hint: Syntax, Purpose and Example
- Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user
- How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?
- How to Check Flash Recovery Area Usage for Oracle(10g, 11g) Database?
A thousand may fall at your side, ten thousand at your right hand, but it will not come near you. (Psalm 91:7)
acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer