BestHub
Sign in
dbaplus Community
dbaplus Community
Feb 8, 2026 · Databases

Why Oracle AWR Is the Gold Standard for DB Performance and How Domestic Databases Compare

The article explains Oracle's Automatic Workload Repository (AWR) as a comprehensive performance‑diagnostic tool, breaks down its core functions, and then evaluates how several domestic databases such as Kingbase measure up in terms of report completeness, metric richness, SQL analysis, wait‑event handling, OS integration, and usability.

AWRDomestic DatabasesMetrics
0 likes · 21 min read
Why Oracle AWR Is the Gold Standard for DB Performance and How Domestic Databases Compare
dbaplus Community
dbaplus Community
Sep 1, 2024 · Databases

How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?

The article examines Oracle’s comprehensive SQL management capabilities—such as parsing, plan caching, process tracing, execution plan handling, optimization, and runtime monitoring—and compares them with the features offered by major Chinese and open‑source databases, highlighting gaps, strengths, and practical recommendations for adopting domestic solutions.

Database ManagementDomestic DatabasesOracle
0 likes · 12 min read
How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?
dbaplus Community
dbaplus Community
Aug 7, 2022 · Databases

Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases

In this interview, senior database expert Kong Zaihua explains the main performance, functional, and usability shortcomings of domestic Chinese databases compared with Oracle, and outlines practical strategies, tools, and migration techniques to evaluate compatibility, handle DDL conversion, manage online/offline data transfer, and reduce reliance on stored procedures.

Database MigrationDomestic DatabasesOracle compatibility
0 likes · 10 min read
Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases
ITPUB
ITPUB
Mar 7, 2022 · Databases

Why Oracle’s Hidden Predicate Pushdown Alters SQL Plans – Lessons for Domestic Databases

The article examines Oracle’s unexpected predicate‑pushdown rewrite observed in trace files, shows how it alters execution plans through a virtual column index, and draws lessons for Chinese database vendors on product depth, architecture design, and after‑sales support to close the gap with global leaders.

Domestic DatabasesOraclePredicate Pushdown
0 likes · 8 min read
Why Oracle’s Hidden Predicate Pushdown Alters SQL Plans – Lessons for Domestic Databases