Performance Tuning Using AWR, ASH and ADDM

Performance Tuning Using AWR, ASH and ADDM

Performance Tuning Using  AWR, ASH and ADDM From Oracle10g onwards, the  Automatic Workload Repository has provided powerful tools to help the DBA identify and resolve performance issues without the hassle of analyzing complex statistical data and extensive reports. Performance Tuning for Oracle 10g/11g database In Oracle 10g and onwards, the …

Read More »

Performance Tuning

Performance Tuning

The common tuning tools are explain plan – lets you see the execution plan used by the query autotrace – automatically produces an execution plan when you execute any SQL. SQL trace – traces the execution of SQL statements TKPROF – formats the trace files into a readable form dbms_monitor …

Read More »

Transportable Tablespaces

Transportable Tablespaces

We can use the transportable table spaces feature to copy/move subset of data (set of user table spaces), from an Oracle database and plug it in to another Oracle database. The table spaces being transported can be either dictionary managed or locally managed. With Oracle 8i, Oracle introduced transportable table …

Read More »

Compressed Backups

Compressed Backups

1.Compressed Backups RMAN has been enhanced to provide binary compression for backup sets, reducing the amount of disk space required to make a backup. In many cases, the additional overhead required to compress the backup set is offset by the reduced I/O load when writing the backup set to disk. …

Read More »

Types of Recovery Manager Backups

Types of Recovery Manager Backups

1.Types of Recovery Manager Backups The backup_type applies to all backup_specifications in the backup_specification_list. The following two backup types are available: 1.1 FULL This is the default if neither full nor incremental is specified. A full backup copies all blocks that have never been used. No blocks are skipped when …

Read More »

Improving Incremental RMAN Backup Performance: Change Tracking

Improving Incremental Backup Performance: Change Tracking

Improving Incremental RMAN Backup RMAN’s change tracking feature for incremental backups improves incremental backup performance by recording changed blocks in each datafile in a change-tracking file. If change tracking is enabled, RMAN uses the change-tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every …

Read More »

Oracle RMAN Backup Commands

RMAN Commands

1.Allocate Channel: To manually allocate a channel, which is a connection between RMAN and a database instance. Each connection initiates an Oracle server session on the target or auxiliary instance this server session performs the work of backing up, restoring or recovering backup sets and copies. Each channel operates on …

Read More »

Recovery Manager

Recovery Manager

Create Recovery Catalog Create tablespace Create catalog owner Grant privileges(Recovery_catalog_owner) Create catalog Connect to target database Register target database EXAMPLES This example connects to the target database ORCL without a recovery catalog: $rman target sys/[email protected] NOCATALOG Example to make a connection to the target database and recovery catalog database: $rman …

Read More »

Backup & Recovery Scenario

Types of Recovery Manager Backups

CASE 7: DATABASE CRASH DURING HOT BACKUPS: On Friday afternoon, while taking hot backups the machine crashed bringing the database down. Once the machine was booted, he tried to start the database and Oracle asked for media recovery starting from log file sequence number 540. The current online log file …

Read More »

Oracle database Hot Backups

WHY HOT BACKUPS? In some companies because we can’t afford to bring the instance down.(e.g. Credit Card Companies, Stock Market or where we have 24 hours of DB operations) we have to make the DB available to end-users for 24 hours. At the same time we need to backup the …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe