One-stop resource for everything related to
Oracle Database

log4plsql_prc_fnc

Log Sub-Program Parameter Values Using LOG4PL/SQL Framework In Oracle Database 19c

LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…

join_methods

Understanding Global Temporary Table In Oracle

GLOBAL TEMPORARY TABLE Applications often use some form of temporary data store for processes that are too complicated to complete…

split_partition

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…

autonomous_transaction_isolation

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…

log4plsql_prc_fnc

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…

index_compression

Understanding LOCKING In Database

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

split_partition

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…