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.
Month: June 2024
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.