Oracle Partitioning Licensing Costs
What is Oracle Partitioning?
Oracle Partitioning licensing is core-based and tied to the enterprise edition license. Read more to learn how it works. In Oracle Database, partitioning divides a large table into smaller, more manageable pieces called partitions. Partitioning can be used to improve a database’s performance, manageability, and availability.
There are several types of partitioning available in Oracle Database, including:
- Range partitioning: A table is divided into partitions based on a range of values in range partitioning. For example, a table of customer orders could be partitioned by order date, with one partition for orders placed in 2020, another for orders placed in 2021, and so on.
- Hash partitioning: In hash partitioning, a table is divided into partitions based on a hash function applied to the values in a particular column. This can be used to distribute data evenly across the partitions.
- List partitioning: A table is divided into partitions based on explicit lists of values in list partitioning. For example, a table of employees could be partitioned by department, with one partition for the sales department, another for the marketing department, and so on.
- Composite partitioning combines two or more of the above partitioning methods. For example, a table could be range-hash partitioned, with each range partition further divided into hash partitions.
How do companies use Oracle Partitioning?
Oracle partitioning is typically used when a database needs to manage large amounts of data and needs to improve the data’s performance, manageability, or availability. There are several scenarios where Oracle partitioning can be useful:
- Data warehousing: Partitioning can be used to improve the performance of queries on large data warehousing systems by allowing the database to focus on a smaller subset of data.
- Online transactional processing (OLTP): Partitioning can be used to improve the performance of inserts, updates, and deletes on large OLTP systems by allowing the database to focus on a smaller subset of data.
- Data archiving: Partitioning can be used to manage the data in a table by moving older, less frequently accessed data to separate partitions. This can improve the performance of queries on the table by allowing the database to focus on the more active data.
- High availability: Partitioning can be used to improve the availability of a database by allowing the database to continue processing transactions on one partition. At the same time, maintenance or other operations are performed on another partition.
Oracle Partitioning Licensing
- Oracle partitioning is licensed either per processor or per named user plus.
- Note that the licensing of Oracle partitioning is tied to the Oracle Database Enterprise Edition license, and the quantities of licenses and the license metric (named user plus or processor) must match.
Oracle Partitioning License Costs:
- Per processor licensing costs $11,500 per processor and requires a minimum of 25 users per processor.
- Per named user plus licensing costs $230 per user.
For a company that needs to purchase eight processor licenses and 300 named users plus licenses for Oracle partitioning, the total cost would be calculated as follows:
- Processor licenses: 8 processors * $11,500/processor = $<<8*11500=92000>>92,000
- Named user plus licenses: 300 users * $230/user = $<<300*230=69000>>69,000
Total cost: $92,000 + $69,000 = $<<92000+69000=161000>>161,000.
Need expert help?
Our Oracle License Review service is designed to help organizations ensure that they comply with their Oracle licenses and identify opportunities to optimize their Oracle license usage.
Our team of Oracle licensing experts will use Oracle LMS scripts to thoroughly review your Oracle licensing and usage.
Based on this review, we will provide you with a report detailing our findings and recommendations for reconciling any discrepancies and optimizing your Oracle license usage.