How effectively we can use temporary tables in Oracle?

Hello guys, This is quite long back I am writing this post! In between there were…

Common challenges while using bulk collect and techniques to to deal with it

Bulk collects are nothing but select statements that retrieve multiple rows from single fetch into declared…

What are best practices while using data warehouse recovery methodology?

In data warehouses backup and recovery can be very crucial task when you have 100’s of…

How to use SQL Access Advisor?

SQL Access Advisor suggests proper set of materialized views,partitioned tables,indexes for given workload. Complex tasks such…

What are outlines and how these are used?

Outlines categories are nothing but group of hints associated with a particular SQL statement. Oracle chooses…

Autonomous transactions benefits

An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions do…

What are moving data methods in oracle and how it works?

Here I will first load data using Sql * Loader utility and then by using external…

How to multiplex control files?

Control file is small binary file that describes the structure of database.It must be available when…

How to manage undo data?

Undo is copy of original, premodified data. Its captured for every transaction that changes data. Capturing…

How to take RMAN backup?

RMAN is the component of oracle database that is used to perform backup and recovery operations.It…

Enable Notifications    Ok No thanks