What is Oracle Partitioning Option and why would I need it when I already own Oracle Database Enterprise Edition?

Oracle Partitioning Option is a separately licensed option of Oracle Database that is only available with the Enterprise Edition of Oracle Database. The Partitioning option for Oracle Database 11g offers the widest array of partitioning methods available, including interval, reference, list, and range. Partitioning allows DBAs to split large tables into more manageable sub-tables, which  improves database performance, data availability and manageability. Partitioning also goes hand and hand with Oracle’s Lifecycle Management strategy, which aligns the business value of information to cost-effective storage tiers for large data warehousing and transaction processing applications.

Some key benefits/advantages:

  • Partitions can be stored in different tablespaces, which improves the manageability of data
  • Partitioning allows DBA’s to work with smaller more manageable components
  • Partitioning option lowers query times from minutes to seconds, which leads to faster performance
  • Partitions can be added/ removed while users are working.
  • DBAs can perform maintenance without having to bring down an entire table.
  • Increases the availability of data
  • Enables Information Lifecycle Management


  • Oracle Partitioning option must be licensed separately from the Database Enterprise Edition licenses.
  • Oracle Partitioning option must be licensed either by Named User Plus or by Processor.
  • Oracle Partitioning option must match the number of licenses of the associated oracle Database enterprise Edition.
  • A minimum of 25 Named user Plus Licenses per processor must be met.

Leave a Comment

Your email address will not be published. Required fields are marked *


Contact Us

If you have an urgent question regarding your software licensing or a software audit, please contact Miro right away.

(732)738–8511 x1208
Use the chat box on the right

About Us

Miro is a leading global provider of software asset management services, specializing in license management, audit advisory, negotiation tactics, support management, and cloud services. We help our clients maximize ROI on their software license investments, stay in compliance, and minimize the impact of audits. Miro's performance guarantee promises that our long-tenured, diverse, and passionate team of expert analysts provides insightful and actionable advice to help our clients achieve the best possible outcomes.