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…
Author: mark
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…
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