PARTITIONING in 11g

PARTITIONING in 11g

Partitioning Strategies and Extensions at a Glance

The following table gives a conceptual overview of all available basic partitioning strategies in Oracle Database 11g:

In addition to the available partitioning strategies, Oracle Database 11g provides the following partitioning extensions: -

CONCLUSION

Considering the new and improved functionality for Oracle Partitioning, Oracle Database 11g is the most significant release since the introduction of Oracle Partitioning in 1997. In every major release, Oracle has enhanced the functionality of Partitioning, by either adding new partitioning techniques, enhancing the scalability, or extending the manageability and maintenance capabilities. Oracle plans to continue to add new partitioning techniques to ensure that an optimal partitioning technique is available for every business requirement. Partitioning is for everybody. Oracle Partitioning can greatly enhance the manageability, performance, and availability of almost any database application. Partitioning can be applied to cutting-edge applications and indeed partitioning can be a crucial technology ingredient to ensure these applications’ success. Partitioning can also be applied to more commonplace database applications in order to simplify the administration and costs of managing such applications. Since partitioning is transparent to the application, it can be easily implemented because no costly and time-consuming application changes are required