Category Archives: Standard Edition

BREAKING NEWS – Oracle ODA SE2 Bare Metal RELEASED Today 21st June 2016

AnnSjokvist(c)2016 – Dreams

ODA X6-2S / X6-2M – Yes, it’s true!

(Standard Edition 2 Bare Metal solution)

Oracle Corporate (c) - "SE options
Oracle Corporate (c) – “SE options

Oracle has just officially announced, that “Little Brother Standard Edition2 Database” has joined the Oracle Database Appliance family.

Started in 2014

It was back in the beginning of 2014 when I first got acquainted with the ODA solution. I have also written about my thoughts on both LinkedIn and on my blog ( This old video of ODA will give you a feeling about what it is and what it may provide.

Back in autumn 2014 I asked Mr John Abel, Head of Technology and Cloud for UK, Ireland and Israel at Oracle if it had ever crossed Oracles mind, to make ODA the “Little Brother of EXADATA”, and by so providing an affordable smart solution to small customers”.

“Forget it!”

Passionately I tried to convince people in Oracle Community about the missing opportunities a ‘Standard-Edition-Bare-Metal-ODA’ solution would bring to the community, but everybody told me “Forget it! Oracle will never make a ‘Standard-Edition-Bare-Metal-ODA’ solution available!”.

Pardon me for saying: “With passion, innovation and creative thinking things do happens, and SE JUST LOVE IT”.  Makes me feel good.

UKOUG TECH15- ODA Director

At UKOUG TECH 15 Conference I finally had the opportunity, to talk to Tammy Bednar, Director Product Management, Oracle Database Appliance at Oracle, about ODA with a SE Bare Metal solution. Since then, I have asked and asked, and Thanks Tammy to You and your Oracle team mates.  It would be a pleasure to meet the “gang” who made this solution come true!

Have I tested ODA X6/2S?

To my knowledge there are no such service available as an “ODA test drive Cloud”, that would give you an insight on what it is and what it isn’t. Like it is with a new car; everybody wants to test drive before buying – right?

So the answer to the question is unfortunately I haven’t been able to make a deeper test drive. Is there things a Standard Edition DBA should “avoid”? That would be a great thing to explore, and write about. For sure there are much to explore from a Standard Edition point of view. To my understanding, there are “gadgets” in there, that are only available with the Enterprise Edition version of ODA. Will the need of innovative thinking vanish in an ODA X6/2S 2/M? Left to see.

CTO / CIO a ‘ODA X672S’ solution?

IMHO this is a solution worth checking. The costs building a new system will probably be less, than the standard way  -buy a server and then start building the system. A customer told me once, that it took them 6 months to get a new server up and running.

Here is some material  ODAX6-2CustomerPresentation I received from Tammy. I hope it will guide You, when you start to explore this new solution for your Standard Edition Database. Thanks Tammy



And the entry List Price for X6-2S is $18.000. Did I make you interested?

Oracle Standard Edition Community will have the opportunity to choose from two different “ODA SE2 Bare Metal” versions ODA X6-2S and ODA X6-2M.

Database Appliances for Every Organization – X6/2S/2M

  • it doen’t yet support virtualization
  • contains a new Appliance Manager (ODACLI)
  • NVM Express (new standard for PCI Express (PCIe SSD))
    • works directly with PCIe interface, No SCSI protcol overhead
  • there is an REST API that supports Oracle Cloud
  • SE2 License model is either 1-socket (X6-2s), a 2-socket (X6-2M)  or NUP based (NUPS/min 10 users/server)
  • Security is “Built In, and not Bolt out” – Oracle (c)2016
    • Secure Oracle Operating System (default to highest levels of security)
    • Advanced Security Features (EE only)
    • Secure Out-of-the-Box (RPM requirements)
    • Timely System Updates (single patch for entire stack)
    • Complete In-house HW Design( Motherboard, BIOS, and service processor firmware designed 100% Oracle)
  • High-speed for memory
  • High Available Network Connectivity
  • High performance and reliable OS storage

Oracle’s promise:

oracle (c)
oracle (c)


Oracle has today released ODA X6/2S and ODA X6/2M solution that has a Standard Edition 2 Bare Metal Installation.

Is this an opportunity for Oracle Standard Edition Community?  Is this an affordable solution for a small customer, and will the customer be able to start small and let his business grow, and eventually be able to upgrade to EE+ODA technology when his business requires? IMHO I think so.

Will ODA X6/2M or ODA X6/2S have a fair chance in the Cloud society? I think we all know at least one DBA, who once in a while loves to hug his DB Server, to check that everything is ok – So, yes I do believe there is a positive future for this solution.

What do you think?

Take care, stay well, and let’s stay curious in life!


Helsinki, 21. June 2016

SE Community is Big


Year 2015 Standard Edition Community

My blog was visited by people from 123 countries, so yes I dare to say “SE Community is Big”.

The highlights for SE Community this year:

  • the UKOUG tech15 Conference in Birmingham, where we had our own SE track.
  • at the SE Roundtable in Birmingham, Dominic Giles told us that SE will be available for a very long time
  • One of Our SE session was visited by VP Penny Avril, DB PM Dominic Giles , and Jonathan Lewis

Can 2016 become an even better year?

It all depends on You in our SE Community, so take care, stay well and lets enjoy the challenges that are waiting for good solutions



Turku 2.1.2016

SE track a Success at UKOUG TECH15

icc        Success at TECH15!

Standard Edition Track in Birmingham

From all kind of social medias, I have since Harmony2014 Conference seen a growing activity around the Oracle Database Standard Edition database. People within Oracle Community, including people working only on an Enterprise Edition database environment , have blogged, talked, asked advices etc about the obstacles, struggles, and solutions that the Standard Edition database can/will/have caused.

In April this year, at the OUGN conference this thought of bringing the Standard Edition Database Community together grew and thanks to the UKOUG committee we finally had a Standard Edition Track at the TECH15 Conference in Birmingham 7th-9th December 2015.

Now sitting at the airport in Copenhagen on this Wednesday the 9th Dec reflecting what has been accomplished, I have the same feeling I had after winning my first Gold medal in an European Championship. I feel proud, joy, emptiness, and have high expectations for the future of the Oracle Standard Edition database.

Super Sunday Reflections


As a first timer at UKOUG conference, this was a nice way to get acclimatised. I had the opportunity to listen to

  • Developing Applications for RAC & Exadata – What You Need to Know by Bjoern Rost – portrix Systems GmbH
  • 12c Features for Developers by Connor McDonald – Oracle
  • Transforming One Table to Another: SQL or PL/SQL? By Bryn Llewellyn – Oracle  and Co-presenter(s): Jonathan Lewis.

And the take-away from Sunday: “Super Great Experience”. If you haven’t tried it yet, I recommend to schedule it at TECH16 Conference.

7th Dec SE Track Reflections

Penny Avr Penny Avril, VP Oracle

We were loaded with many speakers, and a Roundtable.

Many great thoughts, and discussions from both the audience and the speakers during this day. We had the honour of having Penny Avril, Vice President of Oracle and Dominic Giles, Product Managers for the Oracle Database from Oracle listening to some of the talks, and of cause we grabbed the opportunity to exchange our concerns and thoughts that the Standard Edition Community are having.

The speakers of first Standard Edition Track

  • An Insight into Oracle Standard Edition, What’s Included, What’s Not, and How to plug Some of Those Holes! By Tom Dale – Fivium
  • Standard Edition Something for the Enterprise or the Cloud? by Ann Sjökvist – SE – JUST LOVE IT
  • Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You by Marcin Przepiorowski – Delphix
  • Silent but Deadly : SE Deserves Your Attention by Philippe Fierens – FCP & Jan Karremans – Jk Consult, ACE
  • Oracle SE – RAC, HA and Standby are Still Available. Even Cloud! by Chris Lawless – Dbvisit Software
  • SE DBA’s Life a Bed of Roses? by Ann Sjökvist – SE – JUST LOVE IT

Standard Edition Round table

Also at our Standard Edition Roundtable we had the pleasure of beside Dominic Giles having Jonathan Lewis, and Maria Colgan, Master Product Manager For Oracle Database In-Memory.  

Standard Edition RT

Oracle support Standard Edition 2 and have plans on doing so for a long time

We received a promise,  Oracle will provide a version of SE2 for long, so……

  • Can we focus on enjoying the Standard Edition 2 opportunities and find good solutions and helping our customers, instead of complaining about the loss of SE1/SE?
  • Might the old on-premises model be replaced with the Cloud solution, and might the Cloud solution provide a better ROI for a small company?
  • Can we stay open-minded and give SE2 a chance?
  • Are we able to provide a solutions for our customers with SE2?

Personally I think so. After talking to a person about cloud and security I’m starting to look at cloud in a different way. He said:

“Oracle have a far bigger budget on hiring the best security specialists in the world, than a small company ever can dream of. So yes, it’s as secure environment as it can be according todays standard” 


Finally I would like to thank all our attendees, speakers, and Penny, Dominic, Maria, Jonathan and all the others for attending our Standard Edition Track and the Standard Edition Roundtable.

Also a huge thanks to UKOUG who made this possible.

Take care, stay well and let’s make something positive out of SE2 opportunity!


Copenhagen 9th Dec 2015

Meet Up With Ann At DOAG 2015

2015-K-Banner_Speaker-180x150-ENGL Hopefully I meet You there.

DOAG 2015 Conference + Exhibition

I will be speaking at DOAG 2015 in less than two weeks!

This is my first time as both a speaker and a visitor, and I am looking forward to this event. I enjoy the opportunity to meet new people and old friends, and I would love to meet up with you personally to exchange thoughts about Oracle Database Standard Edition; or any other topic that might be on your mind. Just grab my arm if you feel for making the acquaintance.

Here is my schedule for the week:

  • Tuesday, November 17th – arrives (depending on what train I catch, but in the afternoon)
  • Wednesday, November 18 – gives presentation
    • 08:00 am – 08:45 am Standard Edition Database – something for the Enterprise?
  • Thursday, November 19 – before noon back to Frankfurt

So between November 17-19 – I look forward to meeting you in Nuremberg, Germany at DOAG 2015 Conference+Exhibition!

There are so many good speakers and sessions this year, and very difficult to choose among them, so my personal “chocolate box” contains these others sessions, so let’s see how much I can “consume”.  If my travel arrangements had been more favourable I would have also loved to attend these sessions on the 17th:

17th November:
  • 09:00 am – 09:45 am -Big Data SQL – New Features and Roadmap -Jean-Pierre Dijcks
  • 09:00 am – 09:45 am -Saltstack und Oracle – Salzen Sie ihre Installation+Konfig -Martin Bracher
  • 11:00 am – 11:45 am -Transforming one table to another: SQL or PL/SQL? -Bryn Llewellyn
  • 09:00 am – 09:45 am -Best of RMAN – Selected features from four versions -Uwe Hesse
  • 11:00 am – 11:45 am -Bad Boys of On-line Replication – Changing Everything – Jan Karremans
  • 12:00 pm – 12:45 pm- Core Strategies for Trouble-shooting-Jonathan Lewis
  • 1:00 pm – 1:45 pm – Combining Relational and Document Storage: The Latest in NoSQL Development with the MySQL Database -Tomas Ulin

18th November:
  • 09:00 am – 09:45 am – IT Analytics: Operational Insight for Databases & Middleware- Jagan Athreya
  • 10:00 am – 10:45 am – Best of Oracle Security 2015 -Alexander Kornbrust
  • 09:00 am – 09:45 am – Identifying performance issues beyond Oracle wait interface -Stefan Koehler
  • 10:00 am – 10:45 am – The Basics an Oracle DBA Should Know About MySQL -Joze Senegacnik
  • 11:00 am – 11:45 am -Five Hints for Optimising SQL – Jonathan Lewis
  • 11:00 am – 11:45 am -RAC Battle-Björn Rost
  • 2:00 pm – 2:45 pm -Oracle Database Directions for Cloud and Big Data -Andrew Mendelsohn
  • 3:00 pm – 3:45 pm – Understanding And Resolving Free Buffer Wait Contention -Craig Shallahamer
  • 5:00 pm – 5:45 pm -Best Practices for Oracle Database Performance on Windows- Alex Keh
  • 4:00 pm – 4:45 pm- How to avoid boring work – Automation for DBAs- Marcin Przepiorowski
  • 5:00 pm – 5:45 pm -Oracle Automatic Parallel Execution – Joel Goodman
  • DOAG 2015 Conference + Exhibition Interview at DOAG Studio

Take care, stay well, and enjoy this lovely autumn. We have an exceptional 10 degrees Celsius here in Finland.


Turku 1st November 2015

Standard Edition 2 – DBA’s Toolbox

 SE2 Toolbox

Article about Some useful tools from my SE Toolbox…and some SE2 License stuff at the end 😉

A New kid on the block – SQLCLI

As a Standard Edition DBA, I’m sure you have numerous times used the good old SQL*PLUS.  Recently I noticed that the new SQLCLI tool is not a common known fact among “DBA’s not attending any conferences”, so  I like to promote this nice new tool to the Standard Edition database DBA’s toolbox.

The Oracle SQL Developer Product Manager Jeff Smith’s team has developed this new tool “SQLCLI”, and it can be downloaded from SQLDeveloper homepage. (scroll down the page).

After the download and installation, it is ready for use. Note! On my mac the “sql” didn’t run, so I just started the java jar file from the “sqlcli/lib- directory:

cd $HOME/sqlcl/lib
SE2mac$ java -jar oracle.sqldeveloper.sqlcl.jar hr@//se12t1:1521/se2pdb

Why not Check some youtube videos about SQLCLI, to get the drift about this tool?

SQLDeveloper – a must in SE/SE2

This tool has grown in maturity since the first version, and I think it’s the first tool to add to your SE/SE2 toolbox. It is free and will bring a nice value to your DBA job.

Check this link to get started.

SQLDeveloper pitfall in SE/SE2:

In older versions of SQLDeveloper, I faced some pitfalls with the predefined DBA reports. For example I was able to use the “AWR reports”  without any notifications about violating the license agreement in my Standard Edition database.

The latest version of SQLDeveloper, version 4.1.1, will give you a warning about the license requirements:

(c)Ann Sjökvist

And why do you need to READ this note and answer NO?

By answering YES, I am able to use these AWR reports without any problems, and if proceeding I will violate the License agreement, since I am on a Standard Edition 2 database environment.

Note! Also  in a Enterprise Edition database this violation is possible, if you haven’t purchased the “Diagnostic&Tuning Pack”.

By answering YES, you will be able to use the reports as shown in the screenshot below:

(c) Ann Sjökvist

The “dialog” warning, looks like a normal behaviour independently of the software. For example TOAD software provide with the same kind of dialog during the installation phase. And remember, you can at any later state enable the pack, by changing the softwares preferences/properties; so  an other challenge to remember.

Standard Edition 2 on the Menu


After a long wait amongst people in the Standard Edition Community, Oracle Corporation finally released the edition of the Standard Edition Database on the 1st of September.

With this release, lots of buzz has been generated in all Social Medias available, and lots of blog posts have been generated.

As always, a message can be interpreted in many ways, and both good and less good stuff can be found out there on what this SE2 realease bring to the table; after you have carefully read the license documents available, and still feeling unsure, please check with your local Oracle LMS before making any false or unecessary assumptions on the impacts on your business.

Some small rules to remember about SE2

    • The minimums for Database Standard Edition 2 are 10 Named User Plus licenses per server
      • This metric is used in environments where users can be identified and counted.
    • Install onto a servers that have a maximum capacity of 2 sockets (*see)
      • Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads(**see) at any time
    • Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be licensed on a maximum of 2 one-socket servers
        • on RAC – each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time
        • Hard partitioning (*** see) can be used on 2 sockets servers to enable you to run RAC on 2 two socket servers with both CPUs populated
      (*)When licensing Oracle programs with Standard Edition One, Standard Edition 2, or Standard Edition in the product name, a processor is counted equivalent to an occupied socket; however, in the case of multi-chip modules, each chip in the multi-chip module is counted as one occupied socket.

      (**)From the CPU's perspective, a thread (short for "thread of execution") is merely an ordered sequence of instructions that tells the computer what to do.
      So when someone talks about a "multithreaded processor," they're talking about a processor that can execute multiple instruction streams simultaneously. There are two ways that a processor can perform such a feat: simultaneous multithreading, and using multiple cores. Neither of these methods is mutually exclusive, and both are often used together.
*** HARD partitioning physically segments a server, by taking a single large server and separating it into distinct smaller systems. 
*** SOFT Partitioning: Unless explicitly stated elsewhere in this document, soft partitioning (including features/functionality of any technologies listed as examples above) is not permitted as a means to determine or limit the number of software licenses required for any given server or cluster of servers.

Take care, stay well and let’s enjoy the Autumn.

Helsinki, 24st September 2015

BCT Nothing for Standard Edition

(C) Ann Sjökvist

Block Change Tracking – a feature not available in Standard Edition

The best of the Oracle Community, is the joy people obviously feel from sharing great stuff, and I’m sure some of you have already read this great article by Mr Arupa Nada on how this magic Block change tracking  feature can boost the performance of a RMAN incremental backup.

Even though a standard edition database may not use this feature I suggest you read this post, because this might be one of those factors that have an impact on the customers business.

The license information on this feature:

Feature/Option SE1 SE/SE2 EE Notes

Block change tracking for fast incremental backup   N   N  Y

Take care, stay well and enjoy the week!

– Ann

Helsinki, 8th Sep 2015


SE2 released TODAY 1st Sept 2015

(c) Ann sjökvist

SE2 released TODAY 1st Sept 2015

Today is a great day for Oracle Standard Edition Community!

The “Oracle Database Standard Edition 2 (=SE2)” has been released, and can now be downloaded

What’s new with SE2?

  1. The concepts “Standard Edition (=SE)” and “Standard Edition One (=SE1)” is gone, and the new name is “Oracle Database Standard Edition 2 (=SE2) edition”
  2. Oracle Database Standard Edition (=SE) Licensed Customers can download the new SE2 without any extra costs
  3. Standard Edition One (=SE1) Licensed Customers can download the new SE2 with an extra migration fee. Yes, that’s right. Without the extra migration cost, these customers are not allowed to migrate to the SE2.
  4. The Oracle Database Standard Edition Two (=SE2) will have a restriction of max 2 sockets, and max 16 threads/database. And if hyper thread is in use, there is a max 8 threads/database.
  5. The RAC feature will be available in the new SE2 release. Please keep in mind the max 2 socket and max 16 cores (hyper thread= max2 socket &max 8 core) rule.

See for more information.


How long will Oracle Database in any edition remain under Premier Support?

Full patching support for for all versions of 12gR1 (Enterprise Edition, Standard Edition and Standard One Edition) will be proviced for an additional 12 months from the release of SE2, so through until end August 2016.

After that period Oracle Database will enter Sustaining Support. There won’t be any Extended Support for Oracle Database in any edition.

Will there be an Oracle Database Standard Edition SE/SE1?

Beginning with the release of Oracle Database,  Oracle Database Standard Edition (SE) and Oracle Database Standard Edition One (SE1) are no longer being released. was the final edition that we will produce for SE and SE1.

MOS Note:742060.1 Release Schedule of Current Database Releases does reflect this extension already:  Release: Patching Ends: 31st of August 2016

I suspect lot’s of tweets on this subject, so I hope you all will remember to use the #orclse or #orclse2 tag.

Take care, stay well, and enjoy a life with the new SE2!


Turku 1st September 2015

Standard Edition Community – DOAG &UKOUG Conference


Standard Edition Community Represented at Conferences

As an Oracle Standard Edition Advocate, I feel privileged to say, that after many discussions and many blog posts, Standard Edition Database is getting its well deserved spot in the sun, and the Standard Edition Community is starting to speak and socially discuss its role, opportunities, and challenges in the IT society.

Birmingham 7th-9th Dec

Tech15_ResourcePk_ISA_v1This year UKOUG Conference has decided to dedicate a whole day/track (7th Dec 2015) especially for Standard Edition Database. This is the first time ever a conference has done so. If keen to know the reasons why this conference made such decision, please read about this on my blog. But below is a small part from that interview:

Since this is the first conference in history, that has dedicated a whole day to a Standard Edition Track, could you please tell us the database team reasons for having this track?

Martin: Standard Edition is used by a large number of UKOUG members (and non-members), either because there has been a decision to only licence SE to reduce costs or because they have SE databases as part of the whole mix of Oracle systems within the organisation. SE has it’s own challenges, mostly due to the lack of certain options and technologies such as Partitioning, Data Guard and many of the security features. There are ways to work around these issues but there are few presentation given that address them. Joel Goodman (a highly respected Oracle trainer and presenter who is part of the database committee) initially raised the need for such talks to support what is often an under-represented part of the community and we were happy to support it within this year’s conference.
Joel: I attended Harmony 2014 and saw the interest there in SE. I also help to organise the Oracle University Expert Summits and in the London 2014 summit attended by about 50 people.
Of those over 30 of them either used or supported Standard Edition for at least some of their databases. I realised then that UKOUG should be addressing that audience, so proposed this to the committee at the kick-off meeting for planning Tech15. The committee accepted this suggestion immediately, agreeing that there is a large SE community for whom there has not been a conference before and that we should be the first to do so.

In Birmingham I will have two presentations, plus one Standard Edition Roundtable. Please see below, there are lots of good presentations in this track! Here is the whole UKOUG agenda.

Official Standard Edition AGENDA – 7th of December:

  • 09:00 – 09:50 “Oracle Standard Edition is Awesome!” – Tom Dale – Fivium
  • 11:20-12:10 “Standard Edition Something for the Enterprise?” – Ann Sjökvist
  • 12:20 – 13:10 “Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You” -Marcin Przepiorowski – Delphix
  • 14:10 – 15:00 – “Silent but Deadly : SE Deserves Your Attention” -Philippe Fierens – FCP
  • 15:10 – 16:00- “Max Protection Standby in Standard Edition RAC Environment” -Eter Pani – TSYS International
  • 16:30 – 17:20 – “SE DBA’s Life a Bed of Roses?” – Ann Sjökvist
  • 17:30 – 18:20 – “A Manly Man’s Guide to Open-Source Database Tuning Tools: Life Without EM12c” – Bjorn Rost
  • 17:30-18:20 – “Oracle Standard Edition Round Table” – Joel Goodman – Oracle Co-presenter(s): Ann Sjokvist (also:Philippe Fierens, and Jan Karremans)

DOAG Conference 17th-20th November

I just received the acceptance letter from DOAG conference team, so the Standard Edition Community will also be represented in Nuremberg. I have not yet seen the agenda, but I am sure other people who supports Oracle Standard Edition Database will be there.

Keen to make Standard Edition Community even bigger?

Can we rock the boat like APEX Community has done in the past months?

Join the Standard Edition Community lovers at both DOAG conference in Nuremberg (17th-20th Nov) UKOUG TECH15 in Birmingham (7th-9th Dec). Book your tickets as soon as possible!

Take care, stay well and let’s enjoy the summer!


Turku, Finland 22 July 2015

UKOUG_TECH15 Standard Edition Dedicated Day

image001         Tech15_ResourcePk_ISA_v1

What a fantastic Day!

Standard Edition Community received more information about Oracle Standard Edition earlier today (please see my earlier post on that), and now I received an email telling me that I have been accepted to present two different talks plus the Standard Edition round table at this amazing UKOUG_TECH15 Conference in Birmingham the 7th of December.

But an even greater announcement for Standard Edition Community, is that they have dedicated a whole day for Standard Edition!

This is the first time ever a conference have ever dedicated a whole day for Standard Edition, so I thought it’s in order to interview Martin Widlake and Joel Goodman about this.


Could you please tell us what your role is in TECH15?

Martin: Hi Ann, it’s a pleasure to talk to you about the up-coming UKOUG Tech 15 conference in December and how we are covering Oracle Standard Edition.I am the Chair of the database committee – a group of UKOUG volunteers who are responsible for deciding on the technical content of the Database-focused content of the conference and how it is scheduled. As part of this we consider what areas we think are of particular interest and when we make the call for papers to the Oracle user community we say what areas we are particularly thinking of focusing on.
Joel: I am one the database server technical committee for abstract selection and was also an abstract judge. In addition I worked 
with UKOUG conference organisers to set up  the OU certification Test Fest event for Tech15.
Since this is the first conference in history, that has dedicated a whole day to a Standard Edition Track, could you please tell us the database team reasons for having this track?

Martin:Standard Edition is used by a large number of UKOUG members (and non-members), either because there has been a decision to only licence SE to reduce costs or because they have SE databases as part of the whole mix of Oracle systems within the organisation. SE has it’s own challenges, mostly due to the lack of certain options and technologies such as Partitioning, Data Guard and many of the security features. There are ways to work around these issues but there are few presentation given that address them. Joel Goodman (a highly respected Oracle trainer and presenter who is part of the database committee) initially raised the need for such talks to support what is often an under-represented part of the community and we were happy to support it within this year’s conference. 

Joel:I attended Harmony 2014 and saw the interest there in SE. I also help to organise the Oracle University Expert Summits and in the London 2014 summit attended by about 50 people. 
Of those over 30 of them either used or supported Standard Edition for at least some of their databases. I realised then that UKOUG should be addressing that audience, so proposed this to the committee at the kick-off meeting for planning Tech15. The committee accepted this suggestion immediately, agreeing that there is a large SE community for whom there has not been a conference before and that we should be the first to do so.

How many speakers and presentations will be delivered at the Standard Edition Track?

Martin:We had a great response when we suggested people submit papers on SE for the conference, enough for us to have a whole track (one of the four database tracks running that day) of excellent talks dedicated to it on Monday. There are 5 talks by four presenters running from 9am through to 17:20. The agenda is not officially out yet so I can’t name names just yet. We concentrated all the talks on one day rather than scatter them throughout the conference as we appreciate that some people can only come to part of the conference.

Joel:There are 5 speakers and 6 presentation slots. One of the speakers has had two talks accepted. So at the conference there will be two talks from that person and one each from the others.

What is the TECH15 committee’s expectation for this world premier Standard Edition Track to be held at the amazing International Convention Centre, Birmingham from 7th of December 2015?

Martin:We are hoping that the user community will appreciate the Standard Edition content and come along to the presentations in large numbers :-). By having a set of great talks by excellent presenters all on the one day we hope to attract people to the conference who may not have come before, as well as support the large numbers of regular attendees who use Oracle SE. As you say Ann, this is perhaps the first time there has been a dedicated stream to SE at a major Oracle conference, so is a little bit of a step into the unknown to run a stream dedicated to SE – but we are confident that the interest is there. The user community will let us know if they appreciate it, by attending the presentations and via the feedback forms we gather.

Joel:The goal is to cater for the SE community which is an important part of the small to medium business area for Oracle. SE for example supports RAC with no extra license cost, but there are certain restrictions on the use of RAC in SE. It is great that we have a speaker coming to talk about this. Also, many of the automatic monitoring tools are not available in SE so Experts will deliver talks on how to monitor and maintain SE and even to work around the limitations imposed by the lack of many features that are available in Oracle Enterprise Edition. All of these are part of the plan for the SE track.

Do you have any other thoughts about this World Premier event on Oracle Standard Edition that you would like to share with the Standard Edition Community?

Martin: As well as imparting knowledge about how to get the best out of SE we expect the presentations to show people what you can achieve with the cheaper version of Oracle and that they may be able to get better value from Oracle by going down from Enterprise Edition (potentially with the added expense of options), to SE.

Also, it will help people with an interest in SE to meet up and form there own sub-community within the larger Oracle ecosystem. The best way to learn about technology is by talking with people who are solving the same problems as you.

Joel:Now that the UK Oracle User Group has an SE track, people and companies using SE can have a voice and a learning opportunity. So it is no longer true that the conference “is not for us”.
Take this opportunity to come at least for a day to improve your SE skills, network with SE gurus and other Oracle subject matter experts.

Martin and Joel, thank you very much for this interview! I hope  of Standard Edition users will seize this opportunity and show up in December.

And my talks the 7th of December will be:

  • SE DBA’s Life a Bed of Roses? 
    • Specially for this conference. Yes, life can be a Bed of Roses – you just need to beware of the thorns. In this talk I will show you how I created solutions for managing the challenges that Standard Edition DBAs face in their daily work. In year 2007 I was given the task of tackling customer complaints of a poorly performing software, and as normally the Oracle Standard Edition Database was put to blame (zero2production). That is how the Healthcare Service for PDM/PLM software was born, and soon it became a proven concept for its value as a preventive service. I had the full responsibility for this service between 2007 and 2013 (planning, programming, management, customer care, and other DBA tasks both remote and onsite).
  • Standard Edition Something for the Enterprise? 
    • In this presentation I will talk about opportunities that a Standard Edition Database can bring to the Enterprise.
      I will also talk about how to simulate some Enterprise Edition features that are not available to a Standard Edition Database , some pitfalls, some do’s and don’t’s. The Standard Edition Database is a solid database that is part of the great Oracle Database Family, so why not give it a spot in the sunlight. To people who already have attendeed this presentation…changes has been made reflecting the information around SE2.
  • Standard Edition Roundtable
    • The amazing “SE Round table World premier team” -Jan,  Philippe, and I will be your “pilots”…and we’ll do our best to be as awesome as we have been at the last three Conferences!

Hope to see you there, and here is the registration link

I also received  an hilarious newspaper article about me 🙂

(Note: To my knowledge there is no such newspaper)



Take care, stay well and enjoy your weekend!

See you in December!


Turku 8th of December