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…

Gateway Hotel ,Visakhapatnam

Gateway hotel, Visakhapatnam was the first Taj hotel I ever had a stay and it was…

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…

How to tune database buffer cache?

ย  Mechanism of database buffer cache: Before tuning lets understand the mechanism of database buffer cache.Database…

How to tune instance recovery in Oracle?

For tuning instance recovery,you need to have knowledge about database architecture.Log writer(LGWR) process flushes redo log…

How to manage database storage structures?

To Manage database storage strutures first we should know what are logical structures and what are…

How to resolve lock conflicts in Oracle?

For resolving locks first we will have to understand how locks are created. Suppose two sessios…

Enable Notifications    Ok No thanks