How to Reclaim Oracle High Water Mark Space and Boost Query Performance

This guide explains the concept of Oracle High Water Mark (HWM), why it grows with DML operations, and provides a step‑by‑step procedure—including pre‑check, shrink space, and post‑check—to reclaim unused blocks, reduce tablespace usage, and improve scan efficiency.

Database AdministrationOracleShrink Space

0 likes · 6 min read

How to Reclaim Oracle High Water Mark Space and Boost Query Performance

dbaplus Community

May 31, 2016 · Backend Development

How High-Watermark Throttling Saves MySQL in Flash‑Sale Scenarios

The article explains MySQL high‑watermark throttling, a technique that limits concurrent updates on hot rows to protect database performance during extreme flash‑sale traffic, and demonstrates its effectiveness with real‑world Alibaba Cloud RDS metrics.

Alibaba Cloud RDSconcurrencyflash sale

0 likes · 5 min read

How High-Watermark Throttling Saves MySQL in Flash‑Sale Scenarios