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
- How to Copy File without Changing Last Modified Date, Time stamp and ownership in Linux / Unix?
- CAN FLASH to 111 Method to Disable / Stop / Turn off / Deactivate unwanted Vodafone Flash Messages
- How to Force Oracle RMAN to Delete All Archive log files
- Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded
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