Category: Architecture

dbms_shared_pool

Understanding DBMS_SHARED_POOL Package

The DBMS_SHARED_POOL package provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects…

dbms_shared_pool

Row Migration Vs Row Chaining

Oracle database allocates logical space for all data in the database. Logical storage structures are recognized by Oracle DB and…

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…

dbms_shared_pool

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…