Author: Shoumadip Das
- Performance Tuning
- April 25, 2022
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…
- Architecture
- March 28, 2022
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…
- PL/SQL
- February 20, 2022
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…
- PL/SQL
- December 19, 2021
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…
- PL/SQL
- October 17, 2021
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…
- PL/SQL
- August 29, 2021
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…
- PL/SQL
- August 29, 2021
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…
- Architecture
- July 25, 2021
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…
- SQL
- July 4, 2021
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…
- Performance Tuning
- May 30, 2021
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…