Oracle also supports Hash based partitioning for fragmentation. It can do so in order to create the main partitions or for sub-partitions it further in conjunction with RANGE-HASH, HASH-RANGE, LIST-HASH, HASH-LIST, or HASH-HASH partitioning.
Author: Dhiraj
He specializes on Database Technologies, from Analysis and Design of Enterprise Level Database Architecture to it's implementation. He is responsible for implementation of Oracle 19C or 21C On premises and Cloud, Backup and Recovery, Performance Tuning and Query Optimization.
He also has hands-on experience as a PL/SQL Developer on enterprise level application. Apart from Oracle, he conducts lectures, seminars and workshops on MySQLi Replication, High Availability, Persona, Postgres and MongoDB. His current research is based on Scalability using CockroachDB.
As a technology enthusiast, he primarily develops solutions as a back-end developer using PHP/Laravel framework. He is more inclined towards FOSS and an admirer of Linux System Administration and secretly practices DevOps as a remote Engineer.
Lab on LIST PARTITIONING in ORACLE 18C
Partitioning in Oracle allows to subdivide a whole large logical object like table into smaller physical objects termed as partitions using some list of values as well .
Lab on Partitioning using Oracle 18C
Partiotioning in Oracle allows to subdivide a whole large logical object like table into smaller physical objects termed as partitions. The working principles of these physical partitioning helps to improve the performance, availability and manageability of applications that is built using this feature.
LAB on Object-Relational Database using Oracle 18C
The objects are naturally extensible, meaning that the attributes and methods of one object can be made available to one or more objects. This property is called as inheritance. The object which inherits the behavior of other objects is called as a Subtype and the object which is being inherited is called as the Supertype. When an instance is created for the subtype, the instance inherits the behavior of both the supertype and the subtype.
Replication Using CockroachDB
Replication is important in distributed databases. The cockroachDB uses minimum of three node quorum to establish replication in clusters. A single-node cluster is not appropriate for use in production or for performance testing. To run a multi-node cluster with replicated data for availability, consistency and resiliency, including load balancing across multiple nodes, use cockroach start and cockroach init to start a multi-node cluster with a minimum of three nodes instead.