Oracle Standard Edition – Just Love It

Oracle Standard Edition - Just Love It

 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

24 thoughts on “Oracle Standard Edition – Just Love It”

  1. Hi Ann,

    Have just found your site and it is very informative.

    I am currently having some issues with SE install on and EE options appearing in the FUS view despite not installing them.

    On a newly created database there are VPD policies on objects in the MDSYS and XDB schema – these have been created by the DBCA scripts.



    1. Hi Tony, and welcome! Nice that you enjoy my blog. Yes agree with you that FUS view can somehow be confusing/misleading. In the community a request has been posted, where we ask oracle to better explain FUS license information. But to my understanding both some basic spatial and XDB is needed by Oracle it self; for example starting from xmldb is mandatory; the new DB Express rely on XMLDB, and the logical discarding of columns I think make use of the new In-Database archiving feature that I think is available in every edition (note to my self:need to verify)

      1. Hi Ann,

        Thanks for that. I am happy with XDB and MDSYS being installed but am a little confused about the VPD policies on those schema. For now I have dropped those policies just to test and VPD no longer shows up as being active in FUS.

        The other oddity in FUS is that it is showing up usage of Heat Map for a single tablespace despite it being disabled and should not be included in SE anyway!

  2. Hello Ann!
    Good to know that I’m not alone!

    I’m a low experience SE DBA (and mysql too) working on a Brazilian gov organ with low resources (no training, for example) but with good ideas and force of will to learn and do things.

    I hope to contribute on your blog someday!

    Keep the good job!

    Guilherme Campos,
    Lone DBA

    1. Hi Guilherme, and welcome to my blog! I think your situation is more common than people think, and I’m very pleased to hear that SE database is in use. It brings a solid base, and good support. And obstacles are there for solving, so I look forward to your contributions.
      My motto: “A day without learning something, is a waste of time”, so i look forward to hear about your good ideas! Have a nice day!

  3. Hi Ann,

    Great site. Oracle Database Standard Edition / One, is often overlooked by SMEs.

    I recently put my thoughts on the subject down in a flow chart, to show prospective customers that it is a viable option, if Oracle Database Enterprise Edition is ‘too big’ for their project.

    This was mainly focussed on encouraging the use of Oracle APEX, as a key component.

    I hope that you like it:



    1. Hi Neil,
      Thanks and welcome to my site! It’s very nice to notice that Standard edition database is starting to get it’s well deserved spot in the sunlight. Thanks for this link, I am sure others in the community will also appreciate it
      Take care, stay well and have a lovely weekend!

  4. Hi Ann,

    We are planning our first move from 11gr2 SE to 12c SE.

    But we are on the end of April, hasn’t been released yet for SE. And if I not wrong, and if I understand the chart in Doc ID 742060.1 the end of patching for SE is planned for July 2015.

    Does someone know if something is planned for all of us who are “only” using SE ?



    1. Hi Bertrand,

      Thanks for taking your time to write a comment on my blog. This is a very good comment, and nice to notice you are preparing for such a project.

      I read the document you referred to, and for some reasons I only spotted the text referring to year 2014, and 2016 – no 2015. So, I might need new glasses 🙂
      From that article though, there is a reference to DocID 1905806.1. From there I noticed this “A separate announcement will be made when we release Standard Edition and Standard Edition One. When a public schedule is announced, it will be added to Release Schedule of Current Database Releases (Doc ID 742060.1).”

      I checked with my peers, and they had neither any deeper information about when we can see the daylight of Standard Edition They only knew, that they are working hard on the project.
      Somehow I like this “zero-time-promise”-approach.
      It brings me the feeling of a Software Vendor, that aims to thouroughly test their software before releasing it; at least I hope they do.

      And about your question about “something planned…”. One rumour that I heard was “Standard Edition is going to vanish”, but whether there is any truth in that rumour or not I don’t know. One thought from one peer was, that if such rumour is circling, its purpose can be to verify that the Standard Edition actually is widely in use.

      Either way, mayby by advertising the usage of Standard Edition would increase the awareness,and by that keep the Standard Edition database in the future spotlight.

      1. Hi Ann,

        Thank you for your reply.

        You can find this date in the first line of the “End Date Patching” picture. Just above the notes. But no need to get new glasses, the doc seems to be done to lose the reader. It is not very long, not very complicated, but a lot of information in very little space.

        I was hoping that during one of the SE round tables someone might have supplied “secret” information on our future of SE DBA …

        About our migration plan, this lack of information could be a no-go. And, as free extended support of ends on next January this could be the beginning of a very uncertain period.



        1. I Seem to have a problem with copy/paste this morning … Not sure I need new glasses but for sure new fingers …

          The first line should be read as
          You can find this date in the first line of the “Patching End Date ” array.



        2. Hi Bertrand,

          Thanks! True, the fact that Oracle have set this date, but has not yet been able to provide a release date for SE is odd.

          In Tallinn in June, we will have a SERT, and this is something we need to discuss. Thanks Bertrand for giving the impulse, and maybe we’ll meet in Tallinn?

          Kind Regards,

          1. I would love it … but unfortunately not this year …
            Why not a SERT in Avignon ? lot of SE users around 🙂

            Best Regards,


  5. If you look at Standard Edition Oracle, there are, besides just having the database, so many more things.
    One major feature that always sticks out like nothing else is Oracle Application Express (APEX). This is a RAD Web toolkit with unparalleled possibilities, both in development as in management and it is SERIOUS!!

  6. I have worked on SE once and faced lot of problems like I can not rebuild indexes online and can not apply PARALLEL hint while tuning and other small things.But definitely would want to know more about SE and will share my knowledge too.Great Start.

    1. Thanks Archana for your comment.
      Yes, those features are “forbidden fruits”; a good approach in a SE environment “reading the license document first, and then some actions”.
      Awesome that you have “joined”, the SE community, and really looking forward to receiving information about your experiences
      Have a lovely week!

    1. Hi Mskvaer

      Thanks for your thoughts.

      Why don’t you check my other posts found behind the Menu on Standard Edition.
      I have talked about a ways of getting both the “Poor Mans Standby” and “Partition View” in a SE Database Environment.

      Kind Regards

    1. Tack Roger. Förhoppningsvis finns det även underlag och intresse i Sverige för Oracle SE och ett samarbete bland internationella användare. Det vore härligt om vi tillsammans kunde utveckla “sharing is caring” andan

Leave a Reply

Your email address will not be published. Required fields are marked *

Follow me

Click to Follow