What Is Sharding? Oracle Sharding is a technology that distributes user data across multiple databases, called shards, within the same or different datacenters. In a shared-nothing architecture, the data is horizontally partitioned across a number of physically independent databases. Sharding is similar to the table partitioning. The difference between them is that the table partitioning…
Category: Oracle Sharding Workshop
Oracle Sharding Workshop – Introduction to Oracle Sharding
Oracle Sharding Workshop In this interactive section, we will present detailed instructions and real-life scenarios showcasing the implementation of Oracle Sharding with GDS. This practical approach will equip you with the necessary tools and commands to apply sharding techniques in your own environments. At the end of this section, you will have the opportunity to…
Creating the Catalog Database – Introduction to Oracle Sharding
Creating the Catalog Database On the gsmcat server, create the gsmcatdb database using DBCA from the RDBMS home and follow these instructions: \ 1.\ The shard catalog database gsmcatdb must use a server parameter file (spfile).\ 2.\ The database character set and national character set chosen for gsmcatdb must contain all the possible characters that…