PMON performs process recovery when a client process fails.

During instance startup, PMON takes care of instance recovery.

PMON performs listener registration.

PMON restarts background and dispatcher processes when they fail.

PMON resolves failures of distributed transactions.

Redo is not generated while performing conventional path loads.

Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

No exclusive locks are acquired when the conventional path loads are performed.

Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.

INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

durability

consistency

concurrency

isolation

scalability

manageability

Automatic Storage Management (ASM)

OS file system

logical volume (LVM)

clustered file system

RAW

Real-Time ADDM uses AWR snapshots of the last 10 minutes.

Real-Time ADDM uses ASH recent activity from SGA data.

Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

Regular ADDM uses AWR snapshots that are not yet purged.