Archive Log Gaps
Here is some code to help identify what has been applied and what is missing. Archivelog gap Log Gap Check Get Archive Logs from Backup Stop and Start Apply Services
Database Locking
How to identify lockers This article will explain about locks on rows and on objects in ORACLE. Locks on rows can cause performance problems or even impede a transaction from finishing, when there are processes running for long time we need to validate that they are not waiting on a row(s). When there is a … Read more
Python to read Oracle alert.log
I’m used to working in a UNIX environment and when I was asked to build a database and manage on Windows, I was faced with some new challenges. One of them is searching through the Alert log and without standard UNIX grep I wanted to write something that could perform the same function. Also show … Read more
How to check MSSQL Backups
Most recent backup for each database Detailed list of backups Databases Missing a Data Back-Up Within Past 24 Hours
RMAN Backup with Python
I want to start using Python to perform my backups. Here is a simple script to perform it. Insde both the Incremental_backup.cmd and Full_backup.cmd, you can put any rman commands you like. Archive log backup archivelog all delete all input; backup current controlfile; delete noprompt expired archivelog all; delete noprompt obsolete; Incremental level 0 backup … Read more
Backup Sizes
How to calculate cumulative backups sizes in Oracle Database.
Database Growth – OEM
There are many ways to calculate database growth and I’ve certainly had a few, but this is probably the most accurate so far..
Automatic Shrink
The company I work for would rebuild their tables and indexes every quarter, this did cause some concern for me and they were adamant that this needed to be done. I compromised and came up with this script.