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 (