Anju Garg Oracle Database 12.1.0.2c : Hot Cloning of Non-Container Databases In the initial release of Oracle 12c (12.1.0.1c), a non-Container Database (non-CDB) could be converted to a pluggable database (PDB)... 05 September 2016 7 min read
Jonathan Lewis Text Indexes The Oracle database has many features that are not spoken of frequently and a recent note by Connor McDonald reminded... 05 September 2016 14 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
Jonathan Lewis Massive Deletes – Part 4 In the previous installment of this series I produced some figures highlighting the main differences between doing a large delete... 05 September 2016 10 min read
David Njoku JSON For Absolute Beginners: Part 2 – Why Use Oracle? In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database. The first... 02 September 2016 5 min read
David Njoku JSON For Absolute Beginners: Part 1- Introduction Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s... 02 September 2016 5 min read
Anju Garg Incomplete / Complete recovery using RMAN cold backup Offline backups (also known as Cold or consistent backups) are taken when the database is in a consistent state, i.e.... 29 June 2016 12 min read
Anju Garg Defragmentation Can Degrade Query Performance As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented... 16 June 2016 15 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
Kartik Balachandran Running Siebel CRM on Non-Standard Versions of Internet Explorer Traditionally Siebel CRM has been heavily dependent on ActiveX controls. Oracle offers lifetime support on any Siebel version post version... 03 May 2016 5 min read
Kartik Balachandran Siebel CRM Part 12: Upgrading a Non-Development Database In the last two articles we covered the process of upgrading a development database. The steps involved were as follows:... 26 April 2016 10 min read
Kartik Balachandran Siebel CRM Part 11: Performing the Siebel incremental Repository Merge As mentioned in the last article in this series, the Siebel upgrade process is split into 3 separate parts: Upgrade... 25 April 2016 8 min read
David Njoku XQuery for Absolute Beginners: Part 5 – XQuery Update Facility There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or... 19 April 2016 7 min read
Kartik Balachandran Siebel CRM Part 10: Upgrading the Siebel Database In the nine previous articles in this series, we have learnt how to set up a Siebel Sandbox instance for... 18 April 2016 9 min read
Kartik Balachandran Siebel CRM Part 9: Upgrading the Application Servers for 8.1.1.X Deployments In the first article in the series we talked about having multiple paths for a Siebel upgrade. In a nutshell:... 15 April 2016 6 min read
Anju Garg Automatic Big Table Caching in RAC In an earlier article, I discussed Automatic big table cache (ABTC) which is a new feature introduced in Oracle Database... 13 April 2016 14 min read
Kartik Balachandran Siebel CRM Part 8:- Configuring and Starting the Siebel Sandbox In the last article in this series, we completed the installation of all of the Siebel components for our sandbox.... 13 April 2016 11 min read
David Njoku XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked... 12 April 2016 8 min read
Kartik Balachandran Siebel CRM Part 7: Installation of the Siebel Application Software As mentioned in the last article in this series, we have completed all the tasks necessary to create the Siebel... 05 April 2016 6 min read
Jonathan Lewis Massive Deletes – Part 3 In the previous installment of this series we looked at methods for seeing the pattern of the changes that would... 05 April 2016 16 min read
