BestHub
Sign in
Tagged articles
4 articles
Page 1 of 1
dbaplus Community
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
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
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 24, 2016 · Databases

Why Your SQL Execution Plans Fail and How to Optimize Them

This article explains what execution plans are, why seemingly identical SQL statements can produce different plans, and offers practical tips—such as standardizing query syntax, simplifying nested queries, using temporary tables, bind variables, appropriate transaction scopes, and careful use of NOLOCK—to improve database performance and avoid common pitfalls.

Bind VariablesDatabase OptimizationSQL Server
0 likes · 13 min read
Why Your SQL Execution Plans Fail and How to Optimize Them