Choose currency


Flash Recovery Area in Oracle 11g

Flash Recovery Area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations. From Oracle 11g release2, flash recovery area is called as fast recovery area.
Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database […]

Overview of Partitioning in Oracle 11g

Partitioning in Oracle

Oracle introduced partitioning with Oracle8.

Partitioning allows tables or materialized views or indexes(based on table or materialized view) or index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Each partition of a table or index must have the […]

How to monitor temp space usage in Oracle 11g

As more often we’ve noticed that temp usage hits max in certain situations and in order for DBA to proactively monitor and get notified, DBA can schedule script to monitor temp space usage and here is the sample script that can scheduled to run more often ( probably every 15 or 10 mins frequency […]

How to use Explain Plan Oracle 11g


When an SQL statement is passed to the server the Cost Based Optimizer (CBO) uses database statistics to create an execution plan which it uses to navigate through the data. Once you’ve highlighted a problem query the first thing you should do is EXPLAIN the statement to check the execution plan that […]

Procedure to Perform DR test using Snapshot STANDBY of Data Guard

The Snapshot standby is an Oracle 11g feature following which a physical standby database can be used in Read-Write mode for testing purposes mainly for short period of time.

Characteristics : (Ref Metalink Note: 443720.1)

1. Snapshot standby database receives and archives, but does not apply the redo data.

2. Redo data received from the primary database […]

What is OLAP and OLTP

On Line Transaction Processing  is processing of short and simple transaction data at operational sites i.e. day to day operations in the Source systems. The Database is designed as Application-oriented (E-R based) i.e Highly Normalized so as to efficiently support INSERT and UPDATE operations. Data stored in these systems are raw Current and Isolated […]

DBA Unix commands

Unix for the DBA

How to kill all similar processes with single command

ps -ef | grep eagle |grep -v grep | awk ‘{print $2}’ |xargs -i kill -9 {}
Locating Files under a particular directory
find . -print |grep -i test.sql
 Using AWK in UNIX
To remove a specific column of output from a UNIX command – for example […]

Determine who is running what SQL Query in Oracle database?

Do you know how to get information on all the active query in the Oracle database?  Do you want to know what query is being executed by which user and how long is it running?
 Oracle Current Activity
Given below is a small query that provides the following information about current activity in Oracle database

Which user […]

Incremental Loading in Data Warehouse

In almost all data warehousing scenario, we extract data from one or more source systems and keep storing them in the data warehouse for future analysis. The source systems are generally OLTP systems which store everyday transactional data. Now when it comes to loading these transactional data to data warehouse, we have 2 ways […]

Incremental data load in Fact tables of DW env

Here are few methods and issues of loading data incrementally in Fact tables of a data warehouse.
Generally speaking, incremental loading for Fact tables is relatively easier as, unlike dimension tables, here you do not need to perform any look-up on your target table to find out if the source record already exists […]