Here’s everything you need to know about Oracle SQL query parsing in one detailed mini-series.

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking

Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.…

03 February 2017 8 min read

Oracle

Aman Sharma in Oracle

Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing

In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help…

20 January 2017 9 min read

Oracle

Aman Sharma in Oracle

Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics

Oracle parent and child cursors explained – how the library cache shares SQL execution plans across identical statements while maintaining…

12 December 2016 11 min read

Oracle

Aman Sharma in Oracle

Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

Oracle SQL query parsing explained – the query processing workflow from SQL statement to execution plan, the difference between hard…

05 September 2016 16 min read