Tagged articles
AWR
21 articles · Page 1 of 1

ITPUBMay 22, 2026 · Databases
This guide outlines step‑by‑step procedures for diagnosing Oracle database performance problems, covering how to collect ADDM, AWR, and ASH reports, capture high‑CPU error stacks, obtain 10046 trace files for single or multiple sessions, and use Oracle hang‑analysis documents to differentiate true hangs from CPU spinning.
10046 TraceADDMASH
0 likes · 10 min read


ITPUBMay 1, 2026 · Databases
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.
ASMAWRI/O performance
0 likes · 32 min read

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.
AWRMetricsOracle
0 likes · 21 min read


ITPUBDec 18, 2025 · Databases
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

An Oracle 10g database froze at 10 am due to a massive log file sync wait, traced through AWR analysis to I/O performance problems and excessive commit activity, with root‑cause verification via LGWR switch frequency, parallel‑write latency, and alert log errors, leading to practical remediation steps.
AWRIO bottleneckLog File Sync
0 likes · 5 min read


ITPUBJul 13, 2024 · Databases
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

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.
AWRIndexingOracle
0 likes · 7 min read


ITPUBDec 18, 2019 · Databases
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

When a critical Oracle 10g database on AIX spikes to 100% CPU, this detailed case study walks through emergency actions, AWR analysis, hidden bottlenecks, and practical tuning steps that reduced CPU usage by half and restored system stability.
AIXAWRHigh CPU
0 likes · 13 min read

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

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.
AWRCPUMutex
0 likes · 10 min read

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

This article provides a comprehensive guide to Oracle performance tools—including AWR, ASH, ADDM, AWRDD, and AWRSQRPT—explaining how to obtain and interpret their reports, key metrics to monitor, and real‑world case studies that illustrate effective database optimization for both simple and complex scenarios.
ADDMASHAWR
0 likes · 20 min read

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

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

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

An Oracle RAC performance analysis shows that delayed commits on a configuration table cause frequent gc buffer busy acquire and gc cr block busy waits, dramatically slowing SELECT statements, increasing LMS/LGWR CPU usage, and prompting short‑ and long‑term mitigation strategies.
AWROracle RACcache fusion
0 likes · 17 min read


ITPUBMar 30, 2016 · Databases
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

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

This comprehensive guide explains the concepts of database baselines and capacity management, outlines DBA skill levels, provides real‑world examples, details data collection methods, and offers actionable strategies for performance analysis, threshold setting, and automated monitoring.
AWRBaselineDBA
0 likes · 30 min read

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.
AWRKEEP PoolOracle
0 likes · 24 min read
