02 September 2016
02 September 2016

JSON For Absolute Beginners: Part 2 – Why Use Oracle?

3
In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database.  The first part was an introduction to JSON itself, and was, admittedly, very light on Oracle.  But now it’s probably time to bring Oracle more into the story and talk about how the database has adapted to handle this new format. Or, actually,… Read more
02 September 2016
02 September 2016

JSON For Absolute Beginners: Part 1- Introduction

17
Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s for – something to do with data-interchange – perhaps you even suspect that the J stands for Javascript… or is that Java? The rise in JSON’s popularity has been pretty meteoric, from its early days back in the year 2001… Read more
29 June 2016
29 June 2016

Incomplete / Complete recovery using RMAN cold backup

3
Offline backups (also known as Cold or consistent backups) are taken when the database is in a consistent state, i.e. the database has been shut down with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. As part of a consistent shutdown, redo has been applied to the data files and the System Change number (SCN) in the data f… Read more
16 June 2016
16 June 2016

Defragmentation Can Degrade Query Performance

3
As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented free space. This free space is wasted space as it is insufficient to hold new data. Moreover, it can impact performance of the database as a higher number of sparsely-populated blocks need to be visited. Oracle 11g introduced online segment… Read more
23 May 2016
23 May 2016

Oracle System Change Number: An Introduction

14
For many people working with Oracle database, SCN (System Change Number) is a topic that interests them greatly – but despite that it’s a fascinating topic, it’s confusing as well. In this article we will learn the nitty-gritty of SCN: what it is, where it is used, and how it works. It’s worth mentioning that this is not and cannot… Read more
11 May 2016
11 May 2016

Oracle Flex Cluster: Leaf Node Failover

2
Oracle 12c has introduced Flex Clusters which use hub-and-spoke technology, allowing the cluster to scale much beyond the pre-12c clusters as it requires fewer network interactions between nodes in the cluster, and Less contention for key Clusterware resources like OCR and voting disks. A Flex Cluster has two types of nodes: Hub Nodes and Leaf Nodes. Hub Nodes These… … Read more

Running Siebel CRM on Non-Standard Versions of Internet Explorer

0
Traditionally Siebel CRM has been heavily dependent on ActiveX controls. Oracle offers lifetime support on any Siebel version post version 8.0 (launched in February 2007). As of Siebel 15 (Innovation Pack 2015), almost all of the Active X controls have been replaced by Java scripts as a part of the Open UI enablement. New customers deploying Siebel are truly browser-independent… … Read more
26 April 2016
26 April 2016

Siebel CRM Part 12: Upgrading a Non-Development Database

1
In the last two articles we covered the process of upgrading a development database. The steps involved were as follows: Upgrade the Development Database. Run the incremental merge. Resolve the conflicts. Run the post-merge utilities. Update the physical database with the custom objects. The steps above are only required to upgrade a development database. This article covers the upgrade process… Read more
25 April 2016
25 April 2016

Siebel CRM Part 11: Performing the Siebel incremental Repository Merge

2
As mentioned in the last article in this series, the Siebel upgrade process is split into 3 separate parts: Upgrade the Non-Production Database (Development Database). Perform the Database Upgrade. Perform the Incremental Repository Merge and any bug fixes. Upgrade the production database (Non-Development instances). We previously covered the first part of the upgrade, which was performing the database upgrade. During… Read more
15 April 2016
15 April 2016

Siebel CRM Part 9: Upgrading the Application Servers for 8.1.1.X Deployments

2
In the first article in the series we talked about having multiple paths for a Siebel upgrade. In a nutshell: For Siebel versions 8.0.X and early 8.1 customers the best possible route is to re-implement Siebel rather than upgrade. For this purpose we had suggested that a sandbox environment be set up so that the existing business processes can b… Read more
13 April 2016
13 April 2016

Automatic Big Table Caching in RAC

0
In an earlier article, I discussed Automatic big table cache (ABTC) which is a new feature introduced in Oracle Database 12.1.0.2c. Automatic big table cache is an optional section of the buffer cache reserved for storing large objects. It tracks only big tables and automatically caches scanned big objects in big table cache thereby avoiding direct path reads. It caches… Read more
13 April 2016
13 April 2016

Siebel CRM Part 8:- Configuring and Starting the Siebel Sandbox

1
In the last article in this series, we completed the installation of all of the Siebel components for our sandbox. In this article we will configure all those components so that we can start the Siebel application up. Siebel has to be configured in a specific sequence: Create a Gateway Name Server. Configure an enterprise in the Gateway Name Server… Read more
05 April 2016
05 April 2016

Siebel CRM Part 7: Installation of the Siebel Application Software

1
As mentioned in the last article in this series, we have completed all the tasks necessary to create the Siebel Sandbox environment, except for the installation of the Siebel Application software itself. Up to now we have completed the following tasks: Setup of an Amazon Instance with 3 servers. Setup of Java and IIS. Setup and configuration of the Orac… Read more
05 April 2016
05 April 2016

Massive Deletes – Part 3

2
In the previous installment of this series we looked at methods for seeing the pattern of the changes that would appear in a table and its indexes after a large delete. In this installment we move on to the workload implied by different patterns, then think about strategies or, indeed, the need for strategies for reducing that workload at t… Read more
01 April 2016
01 April 2016

Siebel CRM Part 6: Configuring the Siebel Database

4
The final step before we can start the Siebel Server installation is to configure the database server. In the last article in this series we completed the following tasks: Installation of the Oracle Database server on the Amazon server called Siebel Database Server. Creation of an Oracle Database called “SiebelDB”. Installation of the Oracle Client on all the servers. Befor… Read more
29 March 2016
29 March 2016

Siebel CRM Part 5: The Ancillary Software

2
Before we can start installing the Siebel Application software we have a few more steps to complete. Just to recap the steps we have completed so far, we have: Set up a 3-server instance using Amazon AWS. We have downloaded all the installation software. We have extracted the software for the Database Server and the Siebel application. We have created… Read more
21 March 2016
21 March 2016

XQuery for Absolute Beginners: Part 3 – FLWOR

0
This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle developers interested in learning about Xquery. And – confession time – I’ve left the best part for last. However, you really should start with Part 1. Good things come to those who wait. In the first article we talked about… Read more