Performance Tuning
Introduction Performance improvement is an iterative process. Removing the first bottleneck might not lead to performance improvement immediately, because another […]
Oracle and SQL Server Architecture
Database Architecture Starting with a standard installation of both databases, there are a number of differences to be aware of […]
RMAN Recovery
STEPS FOR RESTORING AND RECOVERING DATAFILES FROM THE RMAN TAPE BACKUP TO THE NEW FILESYSTEM. Scenario: There was a file […]
Database CharacterSet Conversion
ORACLE DATABASE CHARACTERSET CONVERSION Pre – Steps 1. Stop the Listener 2. Check for any remote transactions on the database […]