Pages

Friday, May 1, 2015

Database Performance Tuning Tips



Contents:- Performance Tuning of a Database.

Performance Tuning During Backup Related Activities.

Tuning the Database During Backup Activities (Incremental Backup)

We can enable block change tracking at the time of incremental backup. So CTWR Process records the changed blocks to a file since last backup. So at the time of taking backup need to read that file to take backup of changed blocks not need to scan whole file. This makes the incremental backup faster.
RMAN Does not support the backup and recovery of block change tracking file.

Tuning the Backup when Backing up very large Data file by taking MultiSection Backup.


Multisection backup take backup of very large file into multipiece backup sets. Multisection backup divides large file into multiple section and backup each section individually into a separate multipiece backupset.

No comments:

Post a Comment