Author: Shoumadip Das

rowchn_rowmgr

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…

mv_query_rewrite

Understanding Materialized View Query Rewrite

When base tables contain large amount of data, it is expensive and time-consuming to compute the required aggregates or to…

oracle_index_scan

Understanding Oracle Index Scan Methods

INDEX SCAN define how the Optimizer will traverse the index block to get the result. It is a access path…

deterministic_result_cache

Behavior Of DETERMINISTIC & RESULT_CACHE Function In Oracle 19c

Oracle Database Cache improves the scalability and performance of applications that access Oracle databases by caching frequently used data on…

iot

Index Organized Tables In Oracle

Index Organized Tables ( IOT ) have their primary key data and non-key column data stored within the same B*Tree…

collection_column_datatype

Collection As Table Column Datatype

In PL/SQL,we can use both VARRAY & NESTED TABLE collection type as table column datatype. The difference between these implementation…

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…

rowchn_rowmgr

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-collection-method

PL/SQL Collection Methods

WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…

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…