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 Understanding SQL Query Parsing – Part 2: Parent and Child Cursors In the first article of this series, we learned what query parsing is and what impact it has on query... 12 December 2016 10 min read
Aman Sharma Understanding SQL Query Parsing – Part 1 Introduction When it comes to tuning a badly-performing query, there are many things that need to be checked. There may... 05 September 2016 14 min read
Aman Sharma Oracle System Change Number: An Introduction For many people working with Oracle database, SCN (System Change Number) is a topic that interests them greatly – but... 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
