"Reproduced" Oracle partition table detailed

I. Overview of the partitioning table:

Oracle's table partitioning capabilities bring great benefits to a wide variety of applications by improving manageability, performance, and availability. In general, partitioning can greatly improve the performance of certain queries and maintenance operations. In addition, partitioning can greatly simplify common administrative tasks, and partitioning is a key tool for building gigabytes of data systems or ultra-high availability systems.
The partitioning feature can further subdivide a table, index, or index organization table into segments, where the segments of these database objects are called partitions. Each partition has its own name, and you can choose your own storage features. From the database administrator's point of view, a partitioned object has multiple segments that can be collectively managed or managed separately, which gives the database manager considerable flexibility in managing the objects after the partition.

1, the advantages of the partition table:

(1) The possibility of data corruption is reduced due to the dispersion of data into various partitions;
(2) A separate partition can be backed up and restored;
(3) The partition can be mapped to a different physical disk to disperse IO;
(4) Improve manageability, availability, and performance.

2. When to use the partition table

(1) The single table is too large, more than a certain range, the proposed calculation of the G table, you can consider using zoning
(2) Historical data need to be stripped
(3) The query features are very obvious, for example, by year, month or by a certain range!

3. Type of partition table

   1, range partition, by range
   2, list partition, list partition
   3, hash partition, hash partition based on hash value
    4, composite partition, 9i, Oracle includes 2 kinds of composite partitions, Range-hash and range-list. In 11g,oracle, 4 composite partitions are available: Range-range, List-range, List-hash, and List-list.