Skip to content

My Tech Blog

My Tech Blog

  • Home

Month: August 2018

How to Monitor an Undo Transaction

August 1, 2018markLeave a comment

We can monitor the progress of an undo operation by running the query shown below: From the first session connected as SH we issue a DELETE statement While the delete process is in progress, we can monitor the usage of undo blocks from another session. As user SYS we issue the SQL statement…

Continue Reading

Recent Posts

  • Python to read Oracle alert.log
  • How to check MSSQL Backups
  • RMAN Backup with Python
  • Calculate RTO from Availability Group SQLServer
  • Backup Sizes

Recent Comments

  • Kesavamoorthy on How to stop and start RDS instance in AWS using Python
  • SAM on ASM Disk Usage
  • user on How to stop and start RDS instance in AWS using Python

Archives

  • October 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2018
  • September 2018
  • August 2018
  • June 2018
  • April 2018
  • January 2018
  • December 2017
  • November 2017
  • September 2017
  • August 2017

Categories

  • Alexa
  • AWS
  • Data Science
  • Enterprise Manager
  • MS SQL
  • MYSQL
  • Oracle AWS
  • Oracle Database
  • Oracle Rman
  • Python
  • RAC
  • UNIX
© 2021 My Tech Blog | WordPress Theme: Lontano Free by CrestaProject.