Category: Architecture

Database Locking

Understanding LOCKING In Database

CONCURRENT access is accessing same data by multiple users at the same time. • SHARED lock is acquired when user…

Understanding TRANSACTIONS In Database

What Is A Transaction ? Transaction is logically joining multiple SQL statements (unit of work) which we can either commit/rollback.In…

Oracle-Flashback

Understanding FLASHBACK Technology

In Oracle database,under SGA there is an optional memory component known as – Flashback buffer.When Flashback Database is enabled, the…