Subscriber Count


Subscribe to Posts by Email


Oracle 12.2 New Features : Oracle Sharding on its Way

DBA's , Oracle is coming with Sharding.  The one killer feature that No-SQL databases claiming distributed processing with sharding aka a non-shared database storage.

Now with release 12.2 Oracle releasing Sharding feature, with new command "Create Sharded Table" and with a catalog schema, well hold on second , its basically distributed partitioning relied on partitioning feature and standby and you need a license for it :). Oh No common...

I really want to dirt my hands on this feature hearing of many new databases from past few years, and I want to tell "Hey Oracle supports this too" 🙂

From the internet sources and OOW presentations, what I understood from Oracle Sharding , Looks complex to me not a simple as like other databases.

  •  uses dbca for creating shards intially
  •  use a new catalog called GSM (global service manager a features introduced in 11.2)
  •  and catalog contains sharded nodes and key information(mongo config instance)
  •  can be created by using "Create Sharded Table" command
  •  uses consistent hashing with either Traditional hashing/Linear Hashing (even) 
  •  is based on Distributed Partitioning (licensing)
  •  needs standby databases (active dataguard and its licences)
  •  uses set of tablespaces for each shard
  •  uses dblinks for getting data from each shard
  •  use GSM service and clients need to use this service for their connection (like mongos )
  •  uses listener to redirect the connection to right shard for your data (ex: mongo router instance)

What best with this feature is , Unlike Many NoSQL featurs lack of capability having RDBMS and ACID complaince with distributed processing capabilities , whilst if Oracle can keep this sharding simple then this can be a whistle blower to all other new databases.


Geek DBA

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>