Author: Shoumadip Das

RealTime Mview

Understanding RealTime Materialized View In Oracle Database 19c

In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…

RealTime Mview

Understanding SET TRANSACTION In Oracle 19c

The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…

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…

set

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…

RealTime Mview

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…

set

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…

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…

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…