BestHub
Sign in
Tagged articles
20 articles
Page 1 of 1
ITPUB
ITPUB
May 1, 2026 · Databases

A DBA’s 3‑Night Deep Dive: Comprehensive Oracle I/O Performance Diagnosis and Hands‑On Tactics

The article walks through Oracle response‑time analysis, compares service and wait time, presents two real‑world cases (Statspack pre‑10g and AWR post‑10g) that show I/O waits often contribute less than 6% of total time, and then details step‑by‑step methods, parameters, and storage techniques for diagnosing and reducing I/O‑related performance problems.

ASMAWRDatabase Tuning
0 likes · 32 min read
A DBA’s 3‑Night Deep Dive: Comprehensive Oracle I/O Performance Diagnosis and Hands‑On Tactics
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
ITPUB
ITPUB
Dec 18, 2025 · Databases

Why Did Our Oracle RAC Cluster Stall? A Real‑World AWR Diagnosis

A client reported sudden Oracle database slowdown, prompting a post‑mortem analysis using AWR and TFA data that revealed GC bottlenecks, RAC heartbeat packet loss, and an intermittent storage link failure, ultimately resolved by disabling the faulty port and restarting the affected node.

AWROracleRAC
0 likes · 5 min read
Why Did Our Oracle RAC Cluster Stall? A Real‑World AWR Diagnosis
ITPUB
ITPUB
Jul 13, 2024 · Databases

How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting

A single runaway SQL caused a 12‑hour outage of a core Oracle system; the article walks through the fault symptoms, AWR and ASH analysis, abnormal SQL identification, execution‑plan changes caused by partition operations, and the step‑by‑step remediation that restored performance.

AWRDirect Path ReadOracle
0 likes · 8 min read
How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting
Python Crawling & Data Mining
Python Crawling & Data Mining
Jul 18, 2021 · Databases

How Indexing Can Slash Oracle Query Time from Minutes to Seconds

This article examines a real‑world Oracle SQL query, identifies costly full‑table scans and low‑selectivity columns, and demonstrates how creating an index on a key column reduces execution time from 24 minutes to just one second, highlighting essential SQL performance‑tuning techniques.

AWRDatabase OptimizationOracle
0 likes · 7 min read
How Indexing Can Slash Oracle Query Time from Minutes to Seconds
ITPUB
ITPUB
Dec 18, 2019 · Databases

Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs

This tutorial walks you through preparing a virtual‑machine environment, generating workload and AWR snapshots with HammerDB, capturing and exporting SQL tuning sets, performing a manual upgrade from Oracle 11.2 to 19c, and comparing performance before and after the upgrade, all with detailed commands and screenshots.

19cAWRDatabase Upgrade
0 likes · 12 min read
Step‑by‑Step Guide to Upgrading Oracle Database 19c with Hands‑On Labs
Architects' Tech Alliance
Architects' Tech Alliance
Apr 1, 2018 · Databases

Understanding Oracle AWR Reports and Key Performance Metrics

The article explains how to generate and interpret Oracle Automatic Workload Repository (AWR) reports, detailing key sections such as DB Time, Cache Sizes, Load Profile, parsing behavior, instance efficiency percentages, shared pool statistics, and top wait events to diagnose database performance issues.

AWRDatabase PerformanceInstance Efficiency
0 likes · 16 min read
Understanding Oracle AWR Reports and Key Performance Metrics
dbaplus Community
dbaplus Community
Nov 5, 2017 · Databases

Uncovering Oracle’s Hidden Parse Failures: Why AWR Shows 99% Parse Time

A customer’s Oracle 11g RAC experienced chronic high CPU usage; deep AWR analysis revealed that massive parse time was attributed to mutex waits and a hidden hard‑parse failure caused by a missing column, which triggered Bug 16175381 and forced process spin, ultimately resolved by correcting the faulty SQL.

AWRCPUOracle
0 likes · 10 min read
Uncovering Oracle’s Hidden Parse Failures: Why AWR Shows 99% Parse Time
dbaplus Community
dbaplus Community
Jul 13, 2017 · Databases

How to Slash SQL Tuning Time: One‑Click Database Insights & Scripts

This article explains why SQL tuning often wastes hours, identifies common inefficiencies, and provides a step‑by‑step, one‑click method—including ready‑to‑run scripts—to collect full database performance data and detailed SQL information, dramatically speeding up problem resolution.

AWROracleSQL Tuning
0 likes · 13 min read
How to Slash SQL Tuning Time: One‑Click Database Insights & Scripts
dbaplus Community
dbaplus Community
Jul 4, 2017 · Databases

Mastering Oracle Performance: A Guide to AWR, ASH, ADDM, and More

This article explains Oracle database performance tuning by introducing the five key performance reports—AWR, ASH, ADDM, AWRDD, and AWRSQRPT—detailing how to obtain them, what metrics to focus on, and how to apply them in real‑world case studies for both simple and complex optimization scenarios.

ADDMASHAWR
0 likes · 22 min read
Mastering Oracle Performance: A Guide to AWR, ASH, ADDM, and More
Qunar Tech Salon
Qunar Tech Salon
May 18, 2017 · Databases

Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans

This article explains how Oracle's bind variable peeking influences execution plan selection, demonstrates the performance differences between full table scans and index scans with skewed data distributions, and provides practical methods—including 10046 events, v$sql_bind_capture, and AWR views—to capture and analyze bind variable values for better SQL tuning.

AWRBind VariablesOracle
0 likes · 14 min read
Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans
dbaplus Community
dbaplus Community
Oct 18, 2016 · Databases

Mastering Oracle AWR: How to Decode and Optimize Database Performance

This comprehensive guide explains Oracle's Automatic Workload Repository (AWR), how snapshots are collected and retained, and provides step‑by‑step instructions for interpreting the most common AWR report sections, from cache sizes and load profiles to SQL statistics and RAC metrics, helping DBAs pinpoint bottlenecks and improve performance.

AWRDatabase PerformanceOracle
0 likes · 32 min read
Mastering Oracle AWR: How to Decode and Optimize Database Performance
ITPUB
ITPUB
Mar 30, 2016 · Databases

Understanding Oracle Wait Events: A Deep Dive into 33 Common Waits

This article explains Oracle's idle and non‑idle wait events, shows how to query the v$event_name view, counts and classifies events, introduces related performance views, and provides detailed descriptions and parameters for 33 frequently encountered wait events.

AWROracleSQL
0 likes · 31 min read
Understanding Oracle Wait Events: A Deep Dive into 33 Common Waits
dbaplus Community
dbaplus Community
Mar 6, 2016 · Databases

Sudden Daily Accounting Lag: DBA Forensics Reveal Oracle RAC Log I/O Bottleneck

On February 10, 2016 a provincial accounting database experienced severe daily‑batch delays despite other applications running normally; a senior DBA collected alert logs, AWR snapshots, ASH dumps, and OSW metrics, uncovered log‑file‑sync and redo‑IO degradation, increased rollbacks, and a faulty SAN link, pinpointing the root cause.

AWRDBAOracle
0 likes · 8 min read
Sudden Daily Accounting Lag: DBA Forensics Reveal Oracle RAC Log I/O Bottleneck
dbaplus Community
dbaplus Community
Oct 28, 2015 · Databases

Mastering Oracle System Optimization: Real‑World Case Study and Practical Lessons

This article presents a detailed case study of an Oracle RAC system performance bottleneck, walks through comprehensive monitoring, storage and partitioning analysis, and outlines a step‑by‑step optimization plan—including KEEP pool tuning and partition redesign—that dramatically improved I/O latency and overall throughput.

AWRDatabase OptimizationKEEP Pool
0 likes · 24 min read
Mastering Oracle System Optimization: Real‑World Case Study and Practical Lessons