Thread Pool: Shared vs Exclusive – How to Choose the Right Strategy for Critical Java Services

This article dissects the interview question “Should thread pools be shared or exclusive?” by exposing common pitfalls, presenting a systematic analysis of isolation versus reuse, and illustrating best‑practice designs with concrete RocketMQ examples, code snippets, and decision‑making guidelines.

IsolationJava concurrencyRocketMQ

0 likes · 22 min read

Thread Pool: Shared vs Exclusive – How to Choose the Right Strategy for Critical Java Services

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

Aug 29, 2017 · Databases

Unlock Oracle Performance: How Architecture Impacts SQL Optimization

This article explains Oracle's architecture—including the SGA, Shared Pool, Data Buffer, and Log Buffer—shows how each component influences SQL parsing, bind variables, result caching, direct‑path inserts, batch commits and logging, and provides step‑by‑step experiments and practical techniques for diagnosing and tuning performance bottlenecks.

Bind VariablesDatabase ArchitectureOracle

0 likes · 16 min read

Unlock Oracle Performance: How Architecture Impacts SQL Optimization

dbaplus Community

Nov 4, 2015 · Databases

Mastering Oracle Wait Events: How Latch Contention Impacts Performance

This article explains how Oracle wait events, especially latch contention such as cache buffers chains and LRU chain latches, reveal performance bottlenecks, and provides step‑by‑step methods, diagnostic tools, SQL examples, and tuning recommendations to locate and resolve database hotspots.

ADDMOracleSQL Tuning Advisor

0 likes · 30 min read

Mastering Oracle Wait Events: How Latch Contention Impacts Performance