Monthly Archives: May 2018

Oracle GDS Licensing

Oracle Global Data Services (GDS) is a feature of Oracle Database 12c that provides connect-time and run-time load balancing, region affinity, replication lag tolerance based workload routing, and enables inter-database service failover across a set of replicas.

Here are the details of how Oracle GDS is licensed.

  • Databases in a GDS configuration:
    • Must be Database Enterprise Edition (EE) +  Licensed for Oracle Active Data Guard Option and/or Oracle GoldenGate
  • GSM Software
    • No separate license is required
  • GDS Catalog Database
    • No Database EE license is required, if this is a schema in an existing repository (e.g. Oracle Enterprise Manager) database
    • No Database EE license is required (same as Oracle RMAN/EM repository license), if hosted as a separate single instance database
    • If Oracle RAC / Data Guard is used, Oracle RAC Option and Database EE license (for the extra nodes and/or standby) is required

For more information on GDS, do visit OTN GDS portal –

AskTOM Office Hours: Oracle Sharding Session (April 23rd, 2018)

Exploring Oracle Sharding:
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Here is the recording of the Oracle Sharding session that I conducted on April 23rd, 2018.
Oracle Database with Sharding is a globally distributed multi-model (relational & document) cloud-native (and on-premises) DBMS. It is built on shared-nothing architecture where data is horizontally partitioned across databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for shard-amenable applications. Sharding does all this while rendering strong consistency, full power of SQL, and the Oracle Database ecosystem. Listen to this recorded session to learn how you can deploy a sharded DB and elastically scale your transactions, database capacity and concurrent users.



@1.52 – Introduction to Oracle Sharding

@4:08 – Benefits of Sharding

@6:28 – Architecture and Key Features

@21:02 – Data Modeling and Application Considerations for a Sharded Database (SDB)

@29.51 –  Sharded Schema Creation

@36:14 – Direct Routing against an SDB

@41:23 – Proxy Routing for reporting workload

@48:35 – Results of Oracle Sharding Scalability Characterization study

AskTOM Office Hours: Oracle GDS Session 1 (April 4th, 2018)

Exploring Oracle Global Data Services (GDS):
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Here is the recording of the GDS session that I conducted on April 4th, 2018.
Oracle GoldenGate and Oracle Active Data Guard allow for distribution of application workloads across replicated databases, but when applications are spread across geodistributed databases, it is a challenge to efficiently use all the databases for best performance and availability. In this AskTom Office hours session, hear from Oracle Product Development experts about how the Global Data Services feature of Oracle Database provides region-based workload routing, load balancing, and service failover across replicas while enabling a seamless distributed private data cloud for your IT. In this session, you will learn how to load-balance read/write workloads in active/active Oracle GoldenGate and to load-balance read-only workloads across Oracle Active Data Guard reader farms, among numerous other use cases.
Highlights: At 2:03, GDS is introduced. At 4:25, GDS architecture is discussed. At 8:15, Deployment steps are covered. For use cases, please go to 15:58.
For the upcoming GDS AskTOM Office Hours sessions, please visit