Overview of Oracle DB partition features Overview of Partitions

Overview of Oracle DB partition features Overview of Partitions

Overview: in Oracle databases, partitions can break into very large tables or indexes into small, manageable blocks ), these blocks are called partitions ). each partition must have the same logical structure, such as the column name, data type, and constraints. However, each partition can have its own physical structure.

Benefits of partitioning:

1. Increase availability:

2. Easy mode Object Management

3. reduce competition for resources in the OLTP system

4. Improve the query performance in the data warehouse

Partition Key)

The partition key is one or more columns used to determine the partition to which each row goes.

Partition policy:

1. Range Partition)

For example, partition by date.

2. List Partition)

Used when the partition key is a discrete column value.

3. Hash Partition)

Features: the built-in hash function distributes rows evenly to each partition to balance the number of rows in each partition.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian