Author: Shoumadip Das

with_optimization

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…

join_methods

Understanding SET Operations In NESTED TABLE

Out of the three collection types, NESTED TABLE collection type supports SET operations in Oracle. x MULTISET EXCEPT [DISTINCT] y…

Accessible By

Understanding Oracle 12c ACCESSIBLE BY CLAUSE

The ACCESSIBLE BY clause can be added to packages, procedures, functions and types to specify which objects are able to…

duplicate_in_collection

Understanding DBMS_OUTPUT Package

Oracle provides the DBMS_OUTPUT package to enable you to send information from your programs to a buffer. This buffer can…

ptt

Understanding Private Temporary Table In Oracle

PRIVATE TEMPORARY TABLE Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped…

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…

with_optimization

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…