Tag Archives: standard

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

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 Standard Edition R2 is planned for Q3 CY2015

(c) Ann Sjökvist
Finland 2:30 am – Summer The Best Time to Visit


3rd of July 2015 SE Day Standard Edition R2 is planned for Q3 CY2015

NOTE – UPDATE – 8th of July 2015

Changes has been announced today, so PLEASE CHECK these new documents!

Doc2027072.1 Disappeared.

Replaced by updates in Doc1905806.1 and Doc742060.1

(c) Ann Sjökvist

What an amazing day of turbulence on twitter!

NOTE – 3rd July 2015 Breaking News

Standard Edition (SE) and Standard Edition One (SE1) are replaced by Standard Edition 2.

Customers running SE or SE1 will need to migrate their licenses to SE2 to be able to upgrade to Note 2027072.1

During last months the Standard Edition Community have often asked themselves:

“When will Standard Edition Database release 2 ( arrive?”

Yesterday I received a question from Laurent Leturgez , asking if I had any information about SE12.1.0.2:

(c)Ann Sjökvist

Since I hadn’t, I asked the Database Product Manager at Oracle Dominic Giles,  and shortly the Standard Edition Community  received the information we all been waiting for:


The Standard Edition Database version (Rel2) is planned to arrive in Q3 CY2015! And Support extended 6 months

Thanks Dominic for assisting the Oracle Standard Edition Community during this time of uncertainty.

Twitter Turbulence – 3rd of July 2015 (Europe temp > 35°C)

However, this message kicked off some “turbulence on twitter”, and besides facts, of cause also lots of seeds of rumours were planted.

(c) Ann Sjökvist

Please check out Laurent’s blog

(c)Ann Sjökvist

(c) Ann Sjökvist

Please check out Stefan’s blog

(c) Ann Sjökvist

(c)Ann Sjökvist

(c) Ann Sjökvist

Please read Ludovico’s thought about SE2 from his blog

(c) Ann Sjökvist

Please read Jan’s own thoughts about Standard Edition Rel2. Jan thanks for the mention on your blog.

(c) Ann Sjökvist

Please check out Lothar’s blog.

(c) Ann Sjökvist

(c) Ann Sjökvist

(c) Ann Sjökvist

Please check out Alberto’s blog.

(c) Ann Sjökvist

Please check out Franck’s blog.

(c) Ann Sjökvist

(c) Ann Sjökvist

Please check out Dominic’s blog. Thanks Dominic for your help! I am sure everybody in Oracle Standard Edition Community really appreciate your helping hand!

(c) Ann Sjökvist

As Ludovico mentioned on one of his tweets, we absolutely need the twitter buzz around Standard Edition, but we also know the effect of “bad apples in the basket”.

So would it be more beneficial for Standard Edition Community to give the amazing team working on Oracle Standard Edition a break? I am sure Dominic will provide us with more facts when possible.

I liked the initiative from Franck asking for information on Standard Edition REL2 New Features. We need more initiative like this. Thanks Franck for supporting the Standard Edition Community!

Oracle Note 2027072.1 on SE2

Please read Note 2027072.1 for more information. The  License Agreement policy will change between Standard Edition / Standard Edition One and But once again. The expected release:

The release of Oracle Database SE2 is planned for Q3 CY2015

And the extended support for Standard Edition is 6 months.

Take care, stay well, and let’s enjoy this beautiful and warm weather! Yes finally even Scandinavia have got warm weather.


Turku 4th of July 2015 – Happy Independence Day to you in U.S!


Network Encryption in Standard Edition


This topic is doubtfully something to write about, and I was very pleased to find this blog post about

Native Network Encryption and SSL/TLS are not part of the Advanced Security Option

As you  already might have noticed, I look into things from a Standard Edition Database point of view, and to me Tim Hall’s post was executed in a more “Standard Edition Mind Thinking” fashion, and that is for me so amazing to notice, since there are not too many blogs out there at the moment, which are blending the “Standard Edition Database challenges” flavour into their post.

Please check his blog, but the main thing for SE is:

“Network encryption (native network encryption and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of the Oracle database.”

GDRP – Standard Edition Database – any options out-of-the-box?

updated: 31.7.2017

Oracle released this document in January 2017:

“Accelerate Your Response to the EU General Data Protection Regulation (GDPR) – Using Oracle Database Security Products”

When you have an Enterprise Edition Database, and money are no issue, it looks like a pretty straight solution.

The “Oracle Maximum Data Security architecture” gives a nice overlook about what is available for EE:Oracle Corp.(c) + my added SE notes

(pic:Oracle Corp (c) + My SE notes)

Take care, stay well, and enjoy the weekend!


Turku 3rd July 2015

ADO in Oracle Standard Edition?

Automatic Data Optimisation (=ADO) in Oracle Standard Edition?

Time to inspect the Automatic Data Optimization feature that Oracle12c provides from a Standard Edition Database perspective.

Updated 22.6.2015: I feel privileged having peers reading my blog, and receiving feedback.  Standard Edition Community needs a blog with facts, so Thanks Franck Pachot for correcting me on Basic Compression. I would also like to thank my friend Joel Goodman for advice on this topic.

I am actually pleased that I made this mistake since it only reminded me on how easy it is to misinterpret and make wrong assumptions. 

I found this very good post on basic table compression by Jonathan Lewis. As a none native English speaking person, both the way the text below is written and the use of the word “core” made me make the wrong assumptions, and I undermined my own advice “always check and double-check the License Document”. 


“Of the three mechanisms, index compression and basic table compression are part of the core product, while OLTP compression is part of the separately licensed “Advanced Compression Option (ACO)”. In this first article we will restrict ourselves to creating data using basic table compression, leaving the question of updating and deleting compressed data to the second article, which will lead us into “OLTP” compression in the third article. We’ll leave index compression to stand alone in the fourth and fifth articles.” (Jonathan Lewis).

NOTE!! The Basic Compression is not Standard Edition Database Proof.  So do not use it in a Standard Edition Database! 

So I checked the License information on Oracle9i:


So wait, doesn’t it tell us that Compression is ok to use like J Lewis said? No! Once again I made the wrong assumption! The structure of the Oracle9i document is not the same we are used to  (SE1 | SE | EE).

In Oracle9i the structure is  (SE | EE|Personal Edition) – Yes Oracle tells us if a feature is available in Personal Edition:



EndOfUpdate 22.6.2015

Original post:

Explanation for a Business Management’s type of person.

The Whitepaper on ADO feature tells us:

The rapid growth of data presents daunting challenges for IT, both in cost and performance. Although the cost of storage keeps declining, fast-growing data volumes make storage one of the costliest elements of most IT budgets. In addition, the accelerating growth of data makes it difficult to meet performance requirements while staying within budget.

Explanation for a more Technical person:

Automatic Data Optimization (=ADO) automatically moves and compresses data according to user-defined policies based on the information collected by Heat Map. Heat Map automatically tracks modification and query timestamps at the row and segment levels, providing detailed insights into how data is being accessed.

Explanation in a Graphical view 

(c) Ann Sjökvist
(c) Ann Sjökvist

Note: I am not an expert on HW, so when making this graph the choice of storage might not be the best, but to my understanding both the raid50 and Hadoop HDFS alternative seem like good options. To my understanding HDFS is available as a plug-in to ADO, even thought by doing so, the full “data travel path” will not be automatically managed by the database, but that’s a whole different story.

Explanation from the License perspective:


Clear and loud. We cannot use it in a Standard Edition Database environment.

This new Automatic Data Optimisation feature can exploit the functionality of the Partitioning Option and the Advanced Compression Option, and neither of those capabilities are available in a Standard Edition Database Environment.

Note: the partitioned views is not a requirement of ADO, but without the pertaining functionality you will lose the flexibility of using different storage tiers and different compression on different parts of the same table. And as you already maybe have read from my blog, we can create partitioning views in our Standard Edition Database Environment, and by doing so, we can achieve some degree of flexibility also in our Standard Edition Database Environment.

ADO feature allows active data to live on high performance storage like solid state technology, and older inactive data to live on high capacity drives, and allows the DBA to leverage different storage technologies for the same table.  The magic behind all this is the new technology called Heat Map.

Heat map tracks the last access or update time for segments and extents and can also track at the database block level. This includes the time of last modification and access of tables and partitions. There is also a Row level Heat Map that tracks modification times for individual rows (aggregated to the block level).

How does this magic come into place?

  1. You should enable Heat Map (alter system set heat_map = on scope=both)(manually performed)
  2. Heat Map Statistics are collected
    • V$HEAT_MAP_SEGMENT (MMON collects and “write” the info to this view), HEAT_MAP_STAT$ (dbms_scheduler regularly flushes the info to this table from previous view), DBA_HEAT_MAP_SEG_HISTOGRAM & DBA_HEAT_MAP_SEGMENT (are views based on the previous table)
  3. You create ADO Policy on table (manually)
  4. ADO Policy get evaluated
  5. ADO actions will be executed

A beautiful feature but we cannot use it in Standard Edition.

switch Can we enable ADO in Standard Edition? 

There are things a Standard Edition DBA can unintentionally perform, when not alert, and the software will not tell you if a license agreement violation will occur by continuing performing the task you were just about to perform.

Will Oracle give us a helping hand by performing the steps above to activate Heat Map and ADO feature in a Standard Edition Database?

 sandbox      Sandbox and Testcase

  • Oracle Standard Edition version 12.
  • Database Patch Set Update :
  • Linux se12t1.min.com 3.8.13-55.1.5.el6uek.x86_64
  • An out-of-the-box installation of the Standard Edition Database
SQL> SELECT sys_context('USERENV', 'AUTHENTICATED_IDENTITY') as Environment FROM dual union all SELECT sys_context('USERENV', 'CDB_NAME') FROM dual union all SELECT sys_context('USERENV', 'CON_NAME') FROM dual;
SQL>ALTER SYSTEM SET heat_map=ON scope=both;
 alter system set heat_map=on scope=both
 ERROR at line 1:
 ORA-02097: parameter cannot be modified because specified value is invalid
 ORA-00439: feature not enabled: Heat Map

Bang! We cannot even perform step one from the list above. Great and Thanks Oracle!

By Ian Leonard

Can we mimic ADO in Standard Edition?

NOTE!! The Basic Compression is not Standard Edition Database Proof.  So do not use it in a Standard Edition Database!

Note: Starting from 12c we can use the SecureFile for LOBS, but remember the SecureFile Compression is part of the Advanced Compression option, and that is an Enterprise Edition option.

Basic Compression – NOT OK in Standard Edition

Basic Table Compression N N Y

The Oracle Advanced Compression option contains the following features:

SecureFiles Compression and Deduplication 


--CTAS with basic compression enabled
create table t_se1 compress basic
select * from [some_table] where [column] = [value];
--Direct path insert into empty table defined as compressed
create table t_se1 compress basic
select * from [some_table] where rownum = 0;

insert /*+ append */ into t_se1 select * from [some_table] where [column] = [value];

How about moving  data according to usage?

Archived data is usually cold, so that should be easy to move to a less expensive storage tier. But even so, I do think this requires a good data model, knowledge about not only the application capabilities, but also good knowledge about how the end-user is actually using the application and what is the business process that they are following. Again, the importance of good collaboration between people is vital.

(c) Ann Sjökvist Figuring out what can be moved in SE

This SQL shows information about segments read and write occurrence per date, and according to the License Document, these views are Standard Edition Proof :

WITH se_ado as (
     SELECT o.owner,o.object_name, o.object_type,s.db_block_changes_delta bcd,
to_char(begin_interval_time,'mm/dd') c1, 
         sum(physical_reads_total) reads, 
         sum(physical_writes_total) writes 
          dba_hist_seg_stat s, 
          dba_hist_seg_stat_obj o, 
          dba_hist_snapshot sn 
        WHERE o.owner='SEHC'and s.obj# = o.obj#
        and sn.snap_id = s.snap_id
        GROUP BY o.owner,o.object_name,o.object_type,s.db_block_changes_delta,to_char(begin_interval_time,'mm/dd')
        ORDER BY 4,1,3)
select se_ado.* from se_ado where se_ado.writes=0 or se_ado.reads=0
SEHC SE_INDB_ARCH TABLE       0 06/21    0      8
SEHC SE_INDB_ARCH TABLE      16 06/21    0      8

With this script as a starting point, plus lots of evaluation on what are your company’s metrics on moving data to a less expensive storage tier destination, and both some scripting and some maintenance windows,  I think you could mimic ADO to some degrees.

When all your metrics have been evaluated, a scheduled job could perform the collection on a regular basis, that send an email with the results to the DBA.

The magic of moving objects around will be very difficult to mimic, because as the license document reminds us of, ONLINE functionality is only available in Enterprise Edition Database Environment.



So for us Standard Edition DBA’s, we need to have a maintenance window. In my experience, this is not a big issue, when all the parties have agreed and are committed to a solution that now a then requires a maintenance window.

Solution good enough for your company or not?  It depends.

Personally I am a strong believer of the concept that I came up with during a discussion at the Harmony15 Conference; a Mental Sauna” meeting. Briefly it’s about not “pull rank” on someone else. You have no uniform on, so no visible rank to fall back on. In a Finnish Sauna it’s tradition to join, having either only your birthday suit  or a swimming suit on, so it is understandable very difficult to tell is a person a priest, a CEO, a plumber, or what so ever, and that nurtures an environment were people freely exchange their thoughts.

Note: The Finnish Sauna tradition is something special, so if you have no experience of it, please read the article before making any assumptions. 

I believe the result after such a “Mental Sauna”-meeting on for example “Shall we mimic ADO or go for the genuine ADO solution?” would be more uniform since all parties (people like: Application Vendor, the Business Owner, the IT department, support, the end-user, and solution conductor etc) have already discussed the advantages and disadvantages of the topic, and therefore have a stronger commitment to the solution.


Pretty cool feature Oracle engineers have created, isn’t it?

If you are running on a Standard Edition Database, and find this ADO feature appealing, why not start a “mental sauna”-meeting and see which road you choose to take.

Take care, stay well, and enjoy the summer!


21st June 2015

OUG Harmony15 Reflections


OUG Harmony15 Reflections

This years Harmony Conference was a result of the collaboration  between Oracle User Group Finland (=OUGF), Oracle User Group Estonia (=OUGE), and Latvian Oracle User Group (=LVOUG), and the event was held on the 11th and 12th of June in the Swissôtel Hotel in vicinity of medieval Hansa city of Tallinn in Estonia.

Thanks OUG Harmony15 organisation for accepting me as one of the 19 speakers.

This years Keynote Speaker was Graham Wood, and the other speakers were Kellyn Pot’Vin-Gorman, Brendan Tierney, Bryn Llewellyn,Kai Yu, Emre Baransel, Frank Nimphius, Jan Karremans, Juris Trošins, Luís Marques, Marcel-Jan Krijgsman, Martin Widlake, Nikolay Savvinov, Øyvind Isene, Philippe Fierens, Radu Pârvu, Robert Lockard, and Simo Vilmunen and we all were giving our best to the attendees.

speakerHarmony15 (1)     Thanks to OUG Harmony

Ilmar Kerm and his girlfriend were amazing hosts, and thanks for both showing the Town of Tallinn and the Viru Bog Study trail to us, as well as sharing your thoughts with us. The speakers dinner party was also well-arranged and of high standard, as well as the conference. Thanks to you all!

Copyright/AnnSjökvist A Sniper can it be compared with Standard Edition? 

After talking to Robert Lockard I needed to check the definition on “sniper”, and couldn’t help myself for letting my imagination fly away.

The definition of a sniper (I took the liberty of replacing one word, and apologies if by doing so I offend anybody)

“A sniper is a marksman or qualified specialist who operates alone, in a pair, or with a sniper team to maintain close visual contact with the “community” …

As a Standard Edition advocate and an old sportsperson in shooting, I could not just resist this comparison. Strange humour of mine. 🙂

Thanks Robert for bringing your thoughts to the table. They made me realise things I never had thought about in that context.

My own talk on Standard Edition was attended by 20 listeners. I really enjoyed the talk, and it felt as I was able to awaken the awareness of Standard Edition pitfalls, opportunities, and challenges. Thanks to all who were attending.

The fourth Standard Edition Round table was also a success. The room was almost full, just a couple of seats left. Even thought there was no official feedback collected, we got positive feedback from the attendees, so yes we felt together with Jan and Philippe that we did a good job. Thanks guys for yet a great RT!

http://thegeekymormon.com (c)       Need for Collaboration

Another memorable discussions I had, was with Nikolay Savvinov on how to increase the collaboration between different people within the business society. Thanks Nikolay for bringing your thoughts to the table. They made me realise things I never had thought about.

I don’t know how many of you have had a Finnish Sauna experience, but it’s common that people, even strangers just join the crowd in the Finnish sauna wearing nothing but their birthday suit (=no clothes). By doing so, everybody is equal and everybody can join the conversation without preconceptions.

Maybe if we all would be able to enjoy a “mental Finnish sauna” at work, we would be able to collaborate a little better. We might be able to listen to our team members despite the genre they represent – ceo, dba, developer, customer, scientist, solution conductor etc.

What do you think? Would the business society benefit if people could let loose and start enjoy a “mental Finnish sauna”? Would it help us start listening and provide more respect to other people’s views and opinions?

So until next conference, take care, stay well and enjoy your week!


Turku 17th of June 2015

Application Continuity Standard Edition Proof?


(c)Oracle WhitePaper 12c

Oracle12c Application Continuity in Standard Edition

This morning I read some stuff on the new 12c feature APPLICATION CONTINUITY and TRANSACTION GUARD.

To my understanding this feature is more a JDBC driver feature than a database feature, so I said “yes” of cause this is Standard Edition Proof, but after having some issues summing-up the facts around  this feature, I hope you could assist me on this question

Update 8th June 2015: No this feature is not Standard Edition Proof, so please tell your Java Developer NOT TO IMPLEMENT.

Thanks Markus Michalewicz, Franck Pachot, Ludovico Caldara, and Philippe Fierens for your intervention, and for giving us the facts on this one!


If you are interested in, what made me ask this question, keep on reading.

“Is this feature Oracle Standard Edition Proof or not?” The Answer:NO

Facts from Oracle’s own documents

By googling on the option we can see from OTN what it can provide us:

Application Continuity (AC) is a new feature available with the Oracle Real Application Clusters (RAC), Oracle RAC One Node and Oracle Active Data Guard options that masks outages from end users and applications by recovering the in-flight database sessions following recoverable outages.

Transaction Guard is a reliable protocol and tool available with the Oracle Database 12c that returns the outcome of the last in-flight transaction after outages that make the database session unavailable. It is used by Application Continuity to ensure that an in-flight transaction is committed successfully, no more than once. It can also be used directly by applications to return a known outcome to the end users.

RAC feature is by default included in the Standard Edition Database for free, so it should be ok – right?

From the white paper we can read this

Introduced in Oracle Database 12c, Application Continuity strengthens the fault tolerance of systems and applications that use an Oracle database. Application Continuity is available for

  • Oracle WebLogic Server
  • Oracle Universal Connection Pool, used standalone or as a data source for a third party Application Server
  • Standard 3rd Party JDBC application servers using the JDBC PooledConnection interface
  • Oracle JDBC-Thin Driver

WebLogic Server is a product on its own, and with its own license model, but the three others is to my understanding Standard Edition proof “methods”.

12c Support information

Application Continuity for Oracle Database 12c supports the following client and server features:

Oracle Database 12c Client

Oracle JDBC Replay Driver 12c or later. This is a JDBC driver feature provided with Oracle Database 12c for Application Continuity, referred to as the “replay driver” onwards.

This text is from the WP, and below is how the text continues:



General information on JDBC: The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases…(picture below)


More information:

Can third party vendors distribute Oracle’s JDBC drivers along with their own software?
If you are a third party software company (and Oracle partner) then please check out Oracle’s licensing terms spelled out at Oracle Licensing Agreement  Please contact your local Oracle sales rep for more details.

Behind the link, you will find the License Rights:


Oracle License Document 

Here is where I start to have problems summing-up the facts.

According to the license, we cannot use the Application Continuity and since the Transaction Guard is part of the AC, not that either.(TG is used by Application Continuity to ensure that an in-flight transaction is committed successfully, no more than once.)


RAC is included for free in a Oracle12c Standard Edition Database (Note: not in SE one), and this feature relies on JDBC that is Standard Edition proof, and the License Document tell us this feature is not Standard Edition Proof.

So what do you think?

“Is Application Continuity and the Transaction Guard features Oracle Standard Edition proof or not?”

The Answer is : NO – we cannot use this feature with a Standard Edition Database.


And a reminder….

Note: Oracle licensing is a complicated business. The notes here are only a guide. You should always discuss your licensing with Oracle License Management Services or any other third-party company, who are professionals on this business.

Take care, stay well, and let’s enjoy the summer….Please send some summer warm weather!

…In Finland it’s only 14 degrees at the moment, and a cold wind…


Turku 7th June 2015


Row Pattern Match in Oracle 12c Standard Edition?

Row Pattern Match – Standard Edition proof

Note: Oracle licensing is a complicated business. The notes here are only a guide. You should always discuss your licensing with Oracle License Management Services or any other third-party company, who are professionals on this business.

The Oracle12c Database has provided the Oracle community with many new features, and one of them is  “the Row Pattern Match“.

In this video by Tom Kyte from December 2013, we can se that he put this feature on the Top 12 features list.

What is Row Pattern Match?

Oracle now provides a completely new native SQL syntax for pattern matching.

It has adopted the regular expression capabilities of Perl by implementing a core set of rules to define patterns in sequences (streams of rows) using SQL.

This new inter-row pattern search capability complements the already existing capabilities of regular expressions that match patterns within character strings of a single record.

The 12c MATCH_RECOGNIZE feature allows the definition of patterns, in terms of characters or sets of characters, and provides the ability to search for those patterns across row boundaries.

This is a nice feature, and nice features usually are delivered through some options or management packs, and only to the Enterprise Edition database.

This post asks the question is: “the Row Pattern Match feature Standard Edition Proof? Can I use it?”

You can check this article by Tom Kyte with an example on how to use this feature. Here is the example from that article:

  3  ( PARTITION BY symbol
  4    ORDER BY tstamp
  6       STRT.tstamp AS start_tstamp,
  7       LAST(DOWN.tstamp) AS 
  8       LAST(UP.tstamp) AS end_tstamp
 12    DEFINE
 13      DOWN AS 
         DOWN.price < PREV(DOWN.price),
 14      UP AS UP.price > PREV(UP.price)
 15  ) MR
 16   ORDER BY MR.symbol, 

——————  ————————— ————————— —————————
XYZ     01-SEP-12 03-SEP-12 07-SEP-12
XYZ     07-SEP-12 10-SEP-12 13-SEP-12

Question: PARTITION – so I cannot use the “Row Pattern Matching”-feature?  Or is this referring to something else and not the Oracle Partitioning context?

By checking the Oracle12c License Document and the Enterprise Manager License documents, I cannot find anything referring to the keywords. There is though one row on Oracle Advanced Analytics (=OAA) option, and a second row on Oracle On-Line Analytic Processing (OLAP). Both options are only available in an Enterprise Edition Database.

  1. Oracle OTN site on OLAP, you can find this video explaining the features of OLAP. After looking at this video, OLAP option can to my understanding, make use of any available Analytic Functions as well as basic SQL commands together with its own Cube/OLAP specific “language”, so I am tempted to assume that “Row Pattern Matching” is not  part of the OLAP option.
  2. Oracle OTN site on Oracle Advanced Analytics 


“Analyze “market baskets” to discover associations, PATTERNS and relationships”

Can it be so, that “Row Pattern Matching” is part of OAA option?

Reaching out for help from an Advanced Analytic Expert

Since the documentations is not very straightforward on answering  my question, (or maybe its the fact that English is not my mother tongue), I thought I better reach out to one of my peers, Brendan Tierney – who is an expert on Advanced Analytics, and see what kind of thoughts he might have about this new feature:

“As far as I am aware of, the Row Pattern Matching is part of the suite of Analytic Function in Oracle, and as far as I know, it is not part of the Advanced Analytics Option.  It has never been mentioned or associated with Oracle Advanced Analytics.”

Promising….. How about PARTITION?

“The  PARTITION clause is a special feature of the Analytics Functions that allows for the processing/analytics to be performed on different groupings of attributes and their values.”

This is also verified in the above Analytic Function document (Note that the term “partitions” used within the context of analytic functions is unrelated to Oracle Partitioning.)

BTW: Brendan is going to speak about “Predictive Analytics”,  “Data Miner”, and”Predictive Queries” at OUGE Harmony15 Conference in Tallinn. Why not join?

Thanks for sharing your knowledge, and helping me out!


How cool would it be to find a link within the Oracle License Documentation to a  list on for example the OAA options all packages, functions, tables, views, procedures etc that it is using – It would give a very quick answer to Standard Edition specific questions. Now finding an answer to the question “SE Proof?”, can be pretty time consuming, because the information is scattered around. Or a Standard Edition Spokesperson, to whom you could send your question(s) to? Wouldn’t that also be pretty cool?

The “Row Pattern Matching” feature seems to be part of the general Analytic Functions Suite that seems to be a standard functionality of the Oracle database,  and I couldn’t find any text referring to the Enterprise Edition options mentioned above.  I am tempted to say “yes, it’s SE proof”

What’s your thoughts? Is this new feature Standard Edition Proof or not?

June: Message from an Oracle License Expert: Yes it is Standard Edition Proof.

Take care (also remember your data), stay well and lets enjoy the long and bright Summer Nights of Scandinavia!

– Ann

Turku 1st June 2015