Most recent backup for each database Detailed list of backups Databases Missing a Data Back-Up Within Past 24 Hours
Author: mark
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…
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.
How to calculate DB time for a week
DB Time is a period demonstrate measurement that is the entirety of Oracle process CPU utilization and non-inert hold up time. While advancing Oracle frameworks we regularly center around decreasing “time”, however ordinarily database work is additionally part of the condition.
How many log switches per hour
Calculate the log switches per hour over the last week. We can also caculate how many log switches per hour using the following statement or this
Primary Keys without auto increment (MYSQL)
How do you check that all primary keys have an auto increment function? Well here is how to do it.