Category: Architecture
- Architecture
- December 18, 2023
Understanding ROWID In Oracle Database
Every record has a unique ROWID (pseudocolumn) within a database representing the physical location on disk where the record lives….
- Architecture
- January 22, 2023
Understanding Index Compression In Oracle Database 19c
From Oracle 9i onward both non-unique and unique indexes can be compressed to save disk space. The COMPRESS [N] clause…
- Architecture
- November 28, 2022
Understanding DELETE vs TRUNCATE In Oracle Database
In Oracle, Segment Space Management is managing the space within a segment. In a segment generally you have USED block…
- 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…
- 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…
- Architecture
- January 14, 2021
Understanding LOCKING In Database
CONCURRENT access is accessing same data by multiple users at the same time. • SHARED lock is acquired when user…
- Architecture
- December 13, 2020
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…
- Architecture
- November 8, 2020
Understanding FLASHBACK Technology
In Oracle database,under SGA there is an optional memory component known as – Flashback buffer.When Flashback Database is enabled, the…