(By improving manageability, performance, and availability, partitioning can bring significant benefits to a variety of applications. Generally speaking, partitioning can greatly improve the performance of some queries and maintenance operations. In addition, with "tiered archive" zoning, zoning can significantly reduce the total cost of ownership of data. A method of keeping old relevant information online on low-cost storage devices. Oracle partitioning provides an efficient, simple, but powerful approach to information lifecycle management in large environments.
Partitioning enables database designers and administrators to address some of the challenges posed by cutting-edge applications. Partitioning is a key tool for building Gigabit data systems or ultra-high availability systems.)