David Njoku

JSON For Absolute Beginners: Part 5 – Generating JSON in Oracle

In this fifth article in our series on JSON and the Oracle database we’ll be pulling the curtains back on...

11 October 2016 7 min read

Jonathan Lewis

Hacking Indexes

Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure...

03 October 2016 14 min read

David Njoku

JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle

There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar...

03 October 2016 11 min read

Anju Garg

Migrate Oracle Database To ASM Using ASMCMD

Introduction Oracle Database 10g Release 1 introduced Automatic Storage Management (ASM), a new framework for managing Oracle database files. ASM...

29 September 2016 9 min read

Jonathan Lewis

Investigating Indexes

Rebuilding indexes is an activity that you shouldn’t need to do often. There are always a few special cases –...

28 September 2016 16 min read

Anju Garg

Oracle Database 12.1.0.2c: Hot Cloning Of Pluggable Databases

Cloning of a Pluggable Database (PDB) in Oracle Multitenant is a great feature and is very useful. Oracle Database 12c Release 1 has...

20 September 2016 8 min read

David Njoku

JSON For Absolute Beginners: Part 3 – Storing JSON in Oracle

Welcome to part three in this series of articles about Oracle and its uneasy romance with JSON. Uneasy? Well, that’s...

16 September 2016 7 min read

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

Oracle

Aman Sharma in Oracle

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

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