Statistics Collection — 2 Technical Articles

Sep 9, 2025 · Databases

Master OceanBase Slow Query Optimization: From Trace IDs to Manual Stats

This article walks through practical techniques for optimizing slow queries in OceanBase, covering essential data collection, distinguishing trace_id, sql_id, and plan_id, handling multiple sql_id scenarios, and manually gathering statistics across versions, with detailed SQL examples, tables, and visual aids.

OceanBasePlan IDSQL ID

0 likes · 27 min read

Master OceanBase Slow Query Optimization: From Trace IDs to Manual Stats

ITPUB

Aug 17, 2016 · Databases

How to Disable and Re‑Enable Oracle 11g Automatic Statistics Collection

This guide explains why Oracle 11g's automatic optimizer statistics collection can affect 24‑hour systems, shows how to check its status, and provides step‑by‑step commands to disable, re‑enable, and verify the task, including differences from Oracle 10g.

DBMS_AUTO_TASK_ADMINDatabase AdministrationOracle

0 likes · 5 min read

How to Disable and Re‑Enable Oracle 11g Automatic Statistics Collection