Oracle Ben Brumm in Oracle 10 Best Practices for Writing Oracle SQL There is often more than one way to write a query that returns the same results, but some methods may... 30 August 2018 13 min read
Oracle Mike Smithers in Oracle utPLSQL 3.0 – How To Have Your Cake and Eat It This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular... 08 May 2018 27 min read
Oracle Samuel Nitsche in Oracle Strongholds of Confidence: Self-Testing Your Database Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing... 04 April 2018 17 min read
Oracle Nick Buytaert in Oracle Validating naming conventions in Oracle Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of... 20 February 2018 8 min read
Containers and Virtualization Anand Joshi Yogesh Bhate in Containers and Virtualization Overcoming the Challenges of Microservices and Docker Containerisation A microservice architecture can provide great benefits to certain types of applications that have pronounced troughs and peaks in demand,... 19 September 2017 22 min read
David Njoku Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles I accidentally locked myself out of my house this evening, and so I had to climb up the wall like... 01 March 2017 11 min read
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
David Njoku JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2 In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating... 22 February 2017 6 min read
David Njoku Oracle for Absolute Beginners: Data Types All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2... 15 February 2017 11 min read
Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Anju Garg Policy-Managed Oracle RAC One Node Databases Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled... 09 February 2017 13 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
David Njoku Oracle for Absolute Beginners: Date, Timestamp and Interval All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy... 02 February 2017 12 min read
David Njoku Oracle for Absolute Beginners: Other SQL Functions Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,... 30 January 2017 8 min read
Anju Garg Duplicate Point-In-Time Recovered PDB Using Backup At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production... 25 January 2017 9 min read
Jonathan Lewis Snapshots While looking at the results from a query against the dynamic performance view v$active_session_history during a recent trouble-shooting assignment I... 24 January 2017 11 min read
Jonathan Lewis Index Costing Threat In the previous post I described a problem with the strategy that the optimizer uses for costing an index fast... 24 January 2017 9 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
Jonathan Lewis Problems with Indexes In my book “Cost Based Oracle – Fundamentals” (Apress 2005) I described a problem with the cost calculation for the... 20 January 2017 7 min read
Houri Oracle Data Type Implicit Conversion Hierarchy In Oracle, under certain circumstances, an implicit data type conversion precludes the use of indexes. Perhaps you have a vague... 09 January 2017 10 min read
