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?
- Stop / Drop Scheduled / Running jobs in Oracle
- How to Force Oracle RMAN to Delete All Archive log files
- How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet
- Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
- How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?
- Execute Oracle SQLs from Linux Command Prompt and Exit
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