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

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

ITPUB

Nov 29, 2017 · Databases

Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations

This article explains the most common Oracle wait events—including buffer busy waits, buffer latch, control file parallel write/read, various DB file reads and writes, latch free, and library cache lock—detailing their causes, parameters, and how to query them for performance analysis.

Database I/OLatchOracle

0 likes · 15 min read

Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations

ITPUB

Nov 7, 2016 · Databases

Understanding Oracle’s Top 30 Wait Events: Causes, Parameters, and Tuning Tips

This article enumerates Oracle's most common wait events, explains the underlying reasons each event occurs, lists the associated parameters, provides sample queries for inspection, and offers practical guidance on diagnosing and mitigating performance issues caused by these waits.

Database PerformanceOracleSQL

0 likes · 26 min read

Understanding Oracle’s Top 30 Wait Events: Causes, Parameters, and Tuning Tips

dbaplus Community

Nov 1, 2016 · Databases

Understanding Oracle Wait Events: Types, Causes, and Optimization Strategies

This article explains the evolution of Oracle performance metrics, categorizes wait events into idle and non‑idle types, details common wait events with their parameters and causes, and provides practical guidance on using Oracle views to monitor and tune these events for better database performance.

Database MonitoringI/O bottlenecksOracle

0 likes · 22 min read

Understanding Oracle Wait Events: Types, Causes, and Optimization Strategies

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

Feb 15, 2016 · Databases

How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes

This guide walks through a rapid 10‑minute troubleshooting workflow for MySQL and Oracle databases, covering resource checks, log inspection, wait‑event analysis, SQL identification, and feedback best practices to quickly pinpoint performance problems without relying on external monitoring tools.

OraclePerformance MonitoringSQL Analysis

0 likes · 9 min read

How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes