Aman Sharma Getting started with Oracle Database 12c Multitenant Architecture Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In... 22 February 2017 15 min read
Aman Sharma Understanding SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking In the 3rd part of this series, I introduced you to the concept of the bind variables. We also learned... 03 February 2017 8 min read
Oracle Aman Sharma in Oracle Understanding SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In the first and the second parts of this series, we learned what query parsing is, how hard and soft... 20 January 2017 10 min read
Aman Sharma 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
Aman Sharma 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
Aman Sharma Oracle SCN (System Change Number): How It Works Learn how Oracle's System Change Number (SCN) maintains read consistency and data integrity. Covers SCN structure, where it's stored (control... 23 May 2016 13 min read
Aman Sharma GoldenGate – An introduction In the last few years, GoldenGate has become the preferred choice for DBAs to handle the replication requirement of their... 30 April 2015 11 min read
Aman Sharma RAC One Node In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are... 25 April 2013 20 min read
Aman Sharma An Introduction to 11.2 RAC Server Pools Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle,... 18 April 2012 19 min read
