In this post I will demonstrate how a normalized relational data model which is in 3rd Normal Form (3NF) evolves to a dimensional data mod...

Have you ever heard industry jargon like Data Warehouse, Data Mart, Data Mining, OLAP and more. Did you ever wanted to know in one sentence ...

The following unix shell script will do a full RMAN hot backup to your database and will copy the backup files compressed to the directory y...

This post is all about making historical data read only in the data warehouse. By making historical data read-only the aim is to reduce stor...

Some Quick RMAN monitoring commands I find useful and their explanations 1. LIST commands To show the incarnation of the database after the ...