In this post I am going to explain you how to get the Oracle blocking session details.
SQL
Get details of which session is blocking and waiting.
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
- How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?
- Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
- How to Force Oracle RMAN to Delete All Archive log files
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