Oracle Internals

** Oracle Internals **

Warning The following list is just speculation; no guarantee of accuracy.


Oracle internals are important for very large, heavy parallel transaction database design, trouble shooting and so on.

Hidden Init Parameters

Kernal Subsystems

Kernel Subsystems:
OPI Oracle Program Interface
KK Compilation Layer - Parse SQL, compile PL/SQL
KX Execution Layer - Bind and execute SQL and PL/SQL
K2 Distributed Execution Layer - 2PC handling
NPI Network Program Interface
KZ Security Layer - Validate privs
KQ Query Layer
RPI Recursive Program Interface
KA Access Layer
KD Data Layer
KT Transaction Layer
KC Cache Layer
KS Services Layer
KJ Lock Manager Layer
KG Generic Layer
KV Kernel Variables (eg. x$KVIS and X$KVII)
S or ODS Operating System Dependencies

Internal X$ tables and dictionary base ...$ tables

Memroy Structure


Lock (JP)

Oracle Lock

Storage Structure


Undocumented Commands

Oracle Construction Scripts

Oracle Database File

Block Modification