After spending four months tuning an 11g instance and proprietary application SQL using Oracle tools and the Oracle Wait Interface (OWI) I am a big fan of Oracle Enterprise Edition.
Oracle Standard Edition does not contain license to internal data collected by the kernel and used by the OWI. This AWR and ASH data licensing is included in Enterprise Edition only.
With Enterprise Edition and the tuning and performance packs, one can learn that their database does not slow down. It runs at 100% all of the time, or it waits. Clear identification of the waits allows a solution with excellent accuracy. No third party tools are required, in fact, they do not work well.
In order to tune Standard Edition we use 30 year old techniques which are not effective.
Oracle Enterprise Edition is the best there is… Standard Edition is a waste of time and money.
If you use Oracle Standard Edition, depending on your use case, you may be a candidate for migration off Oracle to PostgreSQL.
Oracle Apps need Oracle databases, so that is a roadblock.
Existing licenses with Oracle may take time to reduce. Fortunately, an Oracle DBA is always looking for spare licenses.
With those road blocks understood, let’s talk about the path from Oracle to PostgreSQL,
Proposed migration will be done using Amazon Web Services (AWS) as the target.
While PostgreSQL is Open Source software, distributed for free, the version offered by EnterpriseDB has extensive customization for Oracle… and comes with a cost.
Check out EnterpriseDB (http://www.enterprisedb.com/)
The current per socket cost is $6900/year, 1 or 3 year terms, support included, 24/7 with one hour initial response time. No discounts are available.
This verses Oracle’s per (core * multiplier) cost of $17,500/year, 5 year term, plus 22% annual maintenance/support. Companies receive up to 35% discounts on Oracle from VARs.
That’s $11,375 per that formula, vs. $6900 per socket regardless of core count.
The Enterprise DB solution is generally accepted by corporations because of the support and reputation. Several alternatives are possible including using free Open Source software and manually converting Oracle PL/SQL code to PL/pgSQL.
This part will be tricky since Oracle has Packages, Procedures and Functions, and PostgreSQL only has functions. There’s a community that has been working on this for years. One Open Source conversion program is over 10,000 lines of Perl script.
My recommendation is for a six week trial and evaluation of moving YOUR Oracle database to PostgreSQL with a decision as to how to proceed (AWS EC2, or Enterprise DB/AWS/RDS) at that time.
Not interested in a migration to PostgreSQL? We can also move your existing Oracle instance to the cloud, with or without a version upgrade. We’re always interested in tuning Oracle Enterprise Edition databases.
Check out my post on Tuning here.