Optimizing Distributed Transactions in CB‑SQL: From Two‑Phase Commit to Parallel and Pipeline Commit

This article explains how CB‑SQL improves distributed transaction performance by introducing a transaction record table, parallel prepare requests, one‑phase commit for single‑shard writes, latch‑based consistent reads, transaction pipelines, and a staged parallel‑commit mode, dramatically reducing latency and I/O overhead.

CB-SQLDatabase OptimizationDistributed Transactions

0 likes · 13 min read

Optimizing Distributed Transactions in CB‑SQL: From Two‑Phase Commit to Parallel and Pipeline Commit

ITPUB

Nov 29, 2017 · Databases

Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations

This article explains the most common Oracle wait events—including buffer busy waits, buffer latch, control file parallel write/read, various DB file reads and writes, latch free, and library cache lock—detailing their causes, parameters, and how to query them for performance analysis.

Database I/OLatchOracle

0 likes · 15 min read

Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations

ITPUB

May 6, 2016 · Databases

How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins

Oracle’s block access mechanism involves hashing block addresses to locate hash buckets, using CBC latches and buffer pins to coordinate logical and physical reads, and following distinct step‑by‑step procedures for non‑unique index reads, unique index reads, and write operations, ensuring concurrency safety.

Buffer CacheLatchLogical Read

0 likes · 9 min read

How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins