Oracle Resource Manager Enhancements

In this article we will look at the new features introduced in Resource Manager of Oracle database 11g. Just to list them first here are the four new features in resource manager. This article will be about these new features. [arrow_list] I/O Calibration Per Session I/O Limits AWR Statistics for Resource Manager Built in Resource […]

Foreign Keys on Virtual Columns, IPv6 support and More

Although moving from 11gR1 to 11gR2 might seem a minor upgrade but it is actually not especially when you consider the number of features that 11gR2 brings with it. In today‚Äôs article we will look at few of those new features or enhancements over existing features. Foreign Keys on Virtual Columns In 11gR1 oracle introduced […]

Oracle Automatic SQL Tuning

When Oracle introduced automatic SQL tuning in 10g I was a bit reluctant to try it out because I personally felt that SQL tuning is one of the most daunting task as part of DBA job. There are thousands of queries that run on a production database everyday and to find out which are causing […]

Oracle 12c RAC New Features

Oracle has come a long way from its inception of the 9i RAC database to its current 12c version. I remember the days when we had to deal with RAC related issues, ranging from performance to stability which gradually improved as this product matured. Learn more about the new feature now available with RAC .

Automated Maintenance Tasks

One of the things that Oracle has been taking care of well are the repetitive database administration tasks making it easier for DBA. I can easily remember the days when the long path of Pfile was required to start the database. Pfile in itself is a lifesaver in certain situations but being able to use […]

OPATCH utility

The opatch utility provides the ability to run several commands to perform actions including checking for patches installed, verifying Checksum of Oracle home, to determining if a patch is rolling or not. Some of sample commands are below. 1. Opatch inventory: To get details on the current patch version and the history of when the […]

RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE

Ensuring that the system has been backed up and is fully “recoverable”, is a very important aspect of the DBA’s responsibility.An RMAN command which is usually used to test the availability of the all these required backup files, is the RESTORE DATABASE VALIDATE command. This command looks at the backup set files in the destination […]

How To Delete Specific Archivelogs and Backups Using RMAN

As part of the regular backup file log maintenance, the recovery window and redundancy commands are usually used within backup scripts to define how long the RMAN backups would stay on disk or on tape. For archive log retention, the DELETE ARCHIVELOG command is utilized. DELETE Archive Logs using RMAN To clean-up older archives the […]

Oracle 11g Invisible Indexes

While generating execution plans for queries, the optimizer decides at run time which indexes can be used to make query execute faster. The run time cost based optimizer is very efficient in its decisions. However, in the normal day to day operations there may be some situations where you would not like optimizer to use […]

Database Security – Managing Audit Trail Files

Why manage Database Security Audit Trail files? Changing location of Aaudit trails Purging Old Data Automatic Purge Audit Trail Properties Protecting Database Security Audit Trail Enabling Enhanced Auditing Why manage Oracle Database Security Audit Trail files? Oracle Database Security provides numerous ways to audit user actions in database itself. The mere concept that everything a […]