Benefits of Partitioning and Partitioning Consideration

This thread is for discussion and questions about Benefits of Partitioning and its Strategies.

General Advice:

Below documents will explain the benefits of Table Partitioning Feature.

• Purpose and Benefits/Advantages/Uses of Table Partitioning (Doc ID 1390871.1)

If You need guidance on choosing the Partitioning Startegies for your Table, You can have a look at below Documents.

• How Should I Partition My Tables? (Doc ID 1563143.1)
• Oracle12C: Using SQLAccess Advisor (DBMS_ADVISOR) -- Partition Advisor (Doc ID 1567962.1)

Reference:

Master Note for Partitioning (Doc ID 1312352.1)

12c Partitioning Enhancements, New Features (Doc ID 1568010.1)

11g Partitioning Enhancements (Doc ID 452447.1)

11g New Features: System Partitioning (