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.…

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...

Aman Sharma in Oracle

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

Aman Sharma in Oracle

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