Is Standard Edition Database something for the Enterprise?
This is a blog about stuff related to the license agreement that a DBA must remember when working in a Standard Edition Database environment.
For me Oracle Database is just the Database – “Crème de la Crème”. The Standard Edition Database is like a Rolls-Royce or Maserati Ghibli without the air-condition. This database edition is still a “wow”. The Maserati I do not yet have, but the Oracle Standard Edition (=SE) Database I know how to “drive”.
I have always worked with Oracle Standard Edition, and lately I have had the opportunity to work with Oracle EE on different Production Systems, but still I simply just love the challenges an Oracle SE Database bring. It gives me an opportunity to stay creative and innovative, and it always bring some “salt” to the table, if you know what I mean. 🙂
With that said, this blog is aiming to write about Oracle Database stuff from a Standard Edition DBA’s point of view. We always need to ask the question:
“Can I query this? Can I use this? How to resolve challenges, so that I do not violate the License agreement in a Standard Edition Database environment”
I have many times searched for Oracle Standard Edition specific help on the internet. There are so many awesome scripts, tricks, and advices – but from an Enterprise Edition point of view.
By for example running the SQL below, you will violate the license:
SELECT output FROM TABLE (dbms_workload_repository.awr_report_text( v_dbid, v_Instance_number, v_curr_val, v_curr_val+v_snap_delta))
Or running the DBMS_SQLTUNE package, or performing a SELECT from V$SQL_PLAN_MONITOR you as a Standard Edition DBA will violate the license agreement.
Oracle SE DBA’s best MATE
Your best mate as a Standard Edition DBA is the Oracle License Document. But also others SE DBAs can be or are a buddy to lean on, when you are unsure about how to solve a problem. Everybody has learned something that might not be known to an other SE DBA. Who knows, maybe one day we can create a community for SE DBAs’. 🙂
So hopefully with this blog you and I together can help each other with Standard Edition Database by sharing the knowledge we have been gathering over the years.
If you are a Standard Edition DBA, please give a line and tell me about your own journey with SE Database. Tell me and all others about your good tricks, advices, and scripts that can aid all others SE database DBA’s.
The more and accurate information we can put on this blog, the better it is for all of us.
So please join me on this trip!
Let’s make some magic together!
Turku – Finland – upd. 14th March 2015