THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Oracle Database Machine on a Budget: Standard Edition (SE)?

One of the customers (actually a prospect) here in Australia asked me about minimal Oracle licensing on a quarter rack database machine. This prompted a thought of using Oracle Standard Edition instead of full blown Enterprise Edition with bunch of options.

Before even going into possibility of using Oracle SE for the database machine, let’s see if we even want to.

Why Oracle Standard Edition?

If the environment is data warehouse then it’s extremely unlikely that Standard Edition will cut it. Lack of many feature make it non-feasible to use for data warehousing — no partitioning licensing, no parallel query, and dozens more.

Oracle Standard Edition might fit OLTP environments depending on the application design and data volumes. Since Database Machine is made to store large amounts of data, we assume that it makes financial sense to run databases that are quite large. Oracle SE lacks some critical features in order to successfully manage VLDB (Very Large Databases). It’s not impossible and depends a lot on the presence of outage windows, how active is the development life-cycle, availability requirements and etc.

Where Standard Edition seems to fit nicely is Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more