How many times did you find yourself looking whether a certain feature is part of Oracle Standard Edition or it requires an Enterprise license?
I used to find myself in that situation quite often. I know there is a feature matrix somewhere but every time I end up looking for it over and over again. Worse yet – often I can’t even recall that magic combination of keywords leading to the page I need.
As it always happens, I find something by a chance when I don’t need it. Today is no different but this time I’m posting the reference in the blog so that me and anyone else can use this magic link – Metalink Note 271886.1 Differences Between Different Editions of Oracle Database 10G.
It includes all version of Oracle 10g databases:
Standard Edition One
The first part of the document lists options available for EE. They are actually included into Personal Edition as well with few exceptions. Note that these option must be licensed separately in addition to an Enterprise Edition license. As usual – your salesman will be happy to take your call. ;-)
More interesting is the second part of the document with the feature matrix. This note rocks!
PS: Funny one – the feature matrix in the note says that “Backup and recovery” is not available for Standard and Standard One Editions so you won’t be able to have a backup with SE. ;-) OK, OK – read the comments there. ;-)
Here is another good reference – Oracle Database Licensing Information 10g Release 2. This document includes Express Edition as well.
In the first chapter, you find detailed description of five editions, feature matrix, special cases (such as RAC with SE), CRS licensing, “Processor” definition and ratings and much more. For example, did you know that you don’t need a separate license for a database dedicated to an RMAN repository?
Chapter 2 covers separately licensed database options as well as management packs. Noticed one funny fragment there in description of Oracle Change Management Pack – “The Change Management Pack includes the following features: … Update database object definitions (ALTER TABLE) …”. Have you ever run ALTER TABLE on your database? ;)
So now, dear reader, we hope we have helped you figure out something you needed to know. It turns out that you can help us here at Pythian with something we need to know! If you are aware of a DBA requirement within your organization, salaried or consulting, please pop in your email address here:
We respect your privacy and will not share your address with any third party. As a thank you for just participating, we will enter you into a monthly draw for a year’s membership in the ACM, which includes access to 600 books from the O’Reilly Bookshelf Online, 500 books from Books24x7 and 3000 online courses from SkillSoft, including tons of courseware on Oracle, SQL Server, and MySQL.