SE – Just Love It



Back in 2014 I started this journey helping Standard Edition Community out, and created this blog. The purpose of this blog was to increase the awareness of Standard Edition DB’s business opportunities, license pitfalls, and help DBA’s to start thinking “SE way”.


Oracle SE Mindset

The internet world is full of information about how to do things from an Oracle EE perspective but seldom take in account the restrictions that an Oracle SE database may face.

By googling we could find advice like:

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 how to make use of DBMS_SQLTUNE package, or performing a SELECT from V$SQL_PLAN_MONITOR command.

If above is executed on a Standard Edition Database, you are violating the licence agreement and Oracle database will not tell you about it (to my knowledge up to 12.1 anyhow).

I started to write this blog and went speaking on conferences since I had gained experience on ‘how to think SE’, and wanted to share it to help others understand the luring pitfalls if not asking the right questions before executing commands on a SE Database.

All articles written will be available also in the future, but under the Oracle SE menu.


SE – My Pro Bono Journey

I wrote 90 articles about Oracle Standard Edition between 2014-2016.

The trend of viewers was growing:

Between 2014 – 2015 it was more than double, and between 2015-2016 the viewers growth was over 20%.

Conference appearances

  • 2014 OUGF
    • the first Oracle Standard Edition Round table ever was arranged
    • conference appearance as a speaker on Standard Edition
    •  member of OUGF Board. my duties was Conference arrangements
  • 2015 OUGF, LVOUG, OUGE
    • conference appearance as a speaker on Standard Edition
  • 2015 OUGN
    • conference appearance as a co-speaker on Standard Edition
  • 2015 DOAG
    • conference appearance as a speaker on Standard Edition
    • DOAG.tv interview on Standard Edition
  • 2015 UKOUG
    • Oracle Scene Contributor
    • conference appearance as a speaker on Standard Edition
    • Oracle Standard Edition Round table
    • hear saying; First time ever UKOUG arranged a day track of SE thanks to my work in Standard Edition Community
  • 2016 DOUG
    • Community appearance as a speaker on Standard Edition

Strategy and Productisation

In June 2017 I graduated 6 months pre-scheduled from Haaga-Helia University of Applied Sciences, Bsc. Business Information Technology. My studies:

  • Change Management
  • Digitalisation
  • IT change management
  • Inbound Strategy
  • Inbound Productisation
  • Marketing &Sales
  • Leadership, Multicultural Communication and Teamwork
  • Agile Software Development

Before this education I looked for solutions “outside-the-box”. Now I look even further away from the box. During my thesis my beliefs in the power of inbound-productisation as an unleashed tool for business strategy was strengthened. I believe in business formula “H2HS2P”….Human to human, Solution to Problem…and it’s not tech vendor specific. It’s making business from a broader perspective.

Take care, stay well, and enjoy the challenges of life!

12th July 2017 – Ann“Never lose a holy curiosity – Albert Einstein”

28 thoughts on “SE – 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 12.1.0.1.0 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.

    Regards,

    Tony

    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 12.1.0.1 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: http://www.explorer-development.uk.com/much-really-cost-build-business-class-application-oracle-database/

    Regards,

    Neil

    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!
      Ann

  4. Hi Ann,

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

    But we are on the end of April, 12.1.0.2 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 12.1.0.1 SE is planned for July 2015.

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

    Regards


    Bertrand

    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 12.1.0.2 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 12.1.0.2. 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 11.2.0.4 ends on next January this could be the beginning of a very uncertain period.

        Regards,


        Bertrand

        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.

          Regards,


          Bertrand

        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 12.1.0.2 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,
          Ann

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

            Best Regards,


            Bertrand

  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
      Ann

    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