Category Archives: Standard Edition

OUGF Harmony 2014 #ougf14

Oracle APEX, Oracle tips, Standard Edition, User Groups, , ,

ougf

I flew out today to Finland. And I ended up having the opportunity to share my flight with Björn Rost.
The reason this time was to participate in the (meanwhile legendary) Oracle User Group Finland presentation.

After arriving I got picked up by Ann Sjökvist and we travelled to Oracle Finland HQ for a meeting in preparation for the World Premiere of the Oracle Standard Edition Round Table. After this meeting Ann dropped me of at GLO art Hotel, which looks like an ancient castle for her to proceed in the preparations for OUGF14.
A little later I went out on the town with Alex Nuijten to find the rest of the international crew, and we did! We joined forces with some of the biggest names in the Oracle community today like:

we took the legendary Helsinki City Sight Seeing tour by Heli which led us to the Speaker Dinner, where the crew was complete, adding:

and many more!!

Day two, the start of OUGF Harmony 2014, started with a nice stroll down to Helsinki City Center where we met up with all the speakers and participants of the convention to travel down to Haltia Finnish Nature Center.
At this greatest of all venues, you could be for a tech convention, we had breakfast to kickoff the convention by a keynote presentation by Heli Helskyaho.
And this day got to be even better than it started.
The keynote by James Morle  made it clear that opinions matter where IT is concerned. Arguably the best keynote seen in many years! Mindless following of Marketing-ized ideas, best practice and Google will turn you into an idiot instead of a genius.
There were a lot of good session, more than anyone could attend…

The sessions I attended (besides the keynotes) were:

  • Gurcan Orhan: How to handle DEV & TEST & PROD for ODI – with a perfect example of how quickly a smart implementation can become utterly intricated for nothing
  • Björn Rost: The Ins and Outs of Flashback Data archives – explaining the use of flashback even within a Standard Edition environment
  • Keynote: Bryn Llewellyn: PL/ SQL Enhancements in Oracle Database 12c

At 14:00 I had the opportunity to host my own talk on APEX for Electronic Patients Records (if you are interested in the slides, please drop me a line), having a good attendance. The day ended with a nice musical performance of a band formed by Oracle employees while some preferred the sauna experience and a dive in the lake near the venue.

SaunaJumpMost of the participants returned to Helsinki while a small group of heroes stayed on site for a camp close to the venue.

Day three, the second day of the convention started with a keynote by Graham Wood of the Real World Performance Group while the twitter-stream on #ougf14 was revived showing camping and jumping pictures (a tradition initiated by Yuri Velikanov) from the day before!
In preparation of the Oracle Standard Edition awareness campaign I followed the well attended session from Ann Sjökvist talking about the Standard Edition DBA, a different approach to the trade.

SE-RT-OUGF
At 12:00 we kicked off the first ever Oracle Standard Edition Round Table which was quite a succes! In a very lively discussion we got to discuss CPU’s, sockets, tooling, investments, bridging gaps and creating awareness to leverage the #1 database in the world for even many more situations and projects as we are all used to!! We even got to launch a brand new three letter IT acronym “TCL” which represents the Total Cost of (data) Loss for an organization.

With many unique get togethers this day also slowly drawn to a close. On request of Björn Rost the entire remaining gathering of Oracle enthusiasts made The Jump which, for me, was a unique experience, captured by Philippe (we had to jump a few times, yes :-))

OUGF Jump
As often, the best is kept for last! By ways of being the cherry on the cake, during the “hunt for food” by The Pragmas, downtown Helsinki, we stumbled on the Helskyaho-company at Yume (or even Twitter), possibly the best restaurant of Helsinki and they were so good to invite us to join them. This way we got to spend a dinner in the company of the legendary Chris Date which will possibly be a once in a lifetime experience.

Legendary impomptu get togetherWith OUGF Harmony 2014, the standards for Oracle Usergroup conferences again was raised by a magnitude! A great job by our Finnish friends and a promise for next year.


Can you boost your Oracle database performance on HP-UX for free?

General, Operating Systems, Standard Edition, Technical, , , , , , ,

Database performance, as is true with all performance related matters, has to do with resources.

This story specifically focuses on a real life experience with Oracle database performance on HP Unix running on Intel integrity CPU’s like these:

CPUinfo

The issue with installation is the hyper-threading aka. the use of the logical processors.
When the server is booted and is running, you can do basic performance review with a default tool like top.

lcpu_attr=0

In this exact case the server is running fine and there is no need to investigate further. But, in cases where there were performance issues, it would be a good idea to be aware of the numbering of the CPU’s in this overview (0, 2). This numbering suggests there would also be a ‘1’ and, where there would be a ‘1’ there would probably also be a ‘2’…

Yes there is and it is called ‘lcpu_attr’. A HP Unix kernel parameter which is, to my taste, a bit odd, not well known or well documented…

lcpu_attr (Tunable Kernel Parameter)

When turned on, lcpu_attr activates the logical CPU’s immediately. When you run top again, this is what it’ll look like (immediately)

lcpu_attr=1

Okay! Great… but… there are some catches.
This parameter lcpu_attr is a dynamically tunable kernel parameter but… it’ll crash your databases. So you will need a minimum of planned downtime for this action.

Also, you can set hyper-threading on in the EFI boot-loader.
But then you should be aware of this!

In the end, in this real-life story, we helped the situation advance by just doing:

1. stopping Oracle database(s)
2. kctune lcpu_attr=1
3. starting Oracle databas(s)

All in all, it could be not difficult to boost your Oracle database performance on HP-UX for free!

Thanks to my good friend Gerard van der Kooij for finding the final link!

Okay, and now my database server crashed…

Business, Database Replication, General, Oracle tips, Standard Edition, , , ,

RTO/RPO, who has ever heard of that! That was Star Wars, right?
Storing data and never having to go without or losing any… Yes, that’s more like it.

Server Crashed

Okay, and these two have everything to do with each other!

Talking about these two fancy IT abbreviations I have raised many eyebrows and aided securing businesses!

What is it:
RTO: Recovery Time Objective, or rather, how long should it take before your database is up-and-running again!
RPO: Recovery Point Objective. How much data can you stand to lose?

It is customary to put real amounts of time for these both parameters. This is one of these true points where IT ‘meets’ business, one of those do or die SLA parameters.
How long before you can start working again after something has gone somewhat horribly wrong? Dependent on the business (and for sake of argument), you will get something like; “Oh well, if we are back in business in say an hour, I guess we’ll be fine.” Okay, so we have RTO = 1hr.
And, how much data can you afford to lose? “Losing data, what do you mean?” Well, let’s say you have been on the phone and in the field harvesting order data and putting this in the database… how much of this information can be reproduced when your environment fails? We’ll go with two scenario’s. We will presume “Oh no, NOTHING!” and “Hmmm, well, 10 minutes, if needs be!”, making respectively RPO = 0min. and RPO=10min.

  • RTO = 1 hour
  • RPO = 0 minutes or 10 minutes.

Let us investigate what this means, assuming we have a functional backup running every night and that our drama happens at 15:45 on a working day.

What do we have when we do nothing?
After establishing we have a system crash at hands we need to start working immediately to rebuild something, but do we have something to build upon?
Do we have hardware? And does it somewhat meet specs? Can we run our OS (version) on it? Do we have OS media to install with? Do we have Oracle media to install with? Can we get network, and so on…
And if we have this do we have enough expertise to get it installed?
Well, I guess it’s clear… We need to invest big-time! Few hours getting all the facts straight and getting hardware, a few hours to install and configure the OS, a few more for Oracle, getting it to resemble the former production environment and then restoring the backup!
RTO = starting at 8 hours.
Looking at our RPO? Well, okay, that’s easy! We backup at midnight (0:00) and we crash at 15:45. So we will have lost 15 hours and 3 quarters.
RPO = 15:45 hours.
Acceptable? No, not really!

It’s clear we have to do something.
The first step is to reduce RTO, we need to be able to continue work faster.
We can do this by making sure we have a second server standing by in a different location. Have it installed, have it configured and ready to jump into action. You could call this a Standby Server.
But even now there is no guarantee we make our target since restoring a backup and getting the database up and running could still easily take over 1 hour, when dealing with red-tape and decision levels. To hit the home run we need to add one more feature, we need to have not only a Standby Server, we also need to have a Standby Database. A database that can be “opened” or “activated” in mere minutes.

  • Are you running Enterprise Edition Database then you can use Oracle Data Guard, included in your database license.
  • Are you running Standard Edition Database then you can get the Smart Alternative from Dbvisit.

With Standby Database in place:
RTO = 5 minutes!!

Now we need to tackle RPO!
Or… do we still?
RPO = 10 minutes, actually is tackled by the Standby Database implementation.
Because of the characteristics of Standby Database, we do not only have an RTO of mere minutes, we also have an RPO of a configurable duration.
Data is transferred to the Standby Database environment by means of archived Redo Log files and this mechanism is influenced by manual switching of log files and if you do this with small enough intervals (less than our target of 10 minutes) we make sure that age of the data in the Standby Database meets the target “Recovery Point Objective”!
RPO = 0 minutes
Well, okay, this is something else. And if we think about this a little, it’s something completely different!
Recovery Point Objective, the amount of data we can stand to lose, is 0 (nothing!). Actually meaning we have to create a Standby database setup which is kept up to date with the primary environment. This kind of Standby Database environment allows you to switch to this second environment within seconds and continue your business operation without delay!

And, with your Active-Active Standby Database solutions in place:
RPO = 0 minutes!

So, now you know about RTO/RPO to secure your data and know this guy is something else.

r2-d2

Increasing the reach of your SE database license

Business, Database Replication, General, Oracle tips, Standard Edition, , , , , , ,

Imagine the following situation…

Since a few years your business has been investing in centralizing valuable business information. After some research in the market you have found the Oracle database to be the best fit for your requirements.
Using the free Oracle Application Express (APEX) framework, helping you to rapidly develop the web-applications needed to support both internal and external users, was a premium. Making this installation available based on the Oracle Standard Edition One database, you have created this solution against the lowest possible investment!

As many great projects go, the use and the number of APEX applications is growing. With the addition of ready to use applications to inspire you, many cool plug-ins to ever increase the usability and integration possibilities you get caught up in the data growth dogma!
With an ever increasing user population and expansion of data-reporting for ever faster business reporting your initial system is starting to fail, showing ever more frequent performance lags or system unavailability. These problems form a risk for your business, a risk you need to eliminate as soon as possible!
The standard advise here would be to upgrade your environment, the standard advise here would be to upgrade to a bigger machine and to an Enterprise Edition database. This is what your investment would be then…

  • Medium Oracle Sun Server X2-4 with 4 x 10 core CPU’s at € 42,500
  • (40 cores x 0,5 core-factor **) 20 Oracle Database Enterprise Edition licenses               at € 914,800

Without rendering your application infrastructure worthless by the required investment, a more reasonable step would be to migrate to Oracle Database Standard Edition.

  • Medium Oracle Sun Server X2-4 with 4 x 10 core CPU’s at € 42,500
  • 4 Oracle Database Standard Edition licenses at € 67,400

Still requiring a total investment of more than a hundred thousand Euro and leaving you with the old server and licenses to be decommissioned.

In many implementations, not data entry but data-mining or information aggregation are the costly processes. So probably this will be true in this situation too. With a little investigation it is possible to separate a number of functions that will only query data and not necessarily modify data. Especially in this situation you can also increase your application performance by moving these specific processes to a new environment.

But… how…

The information in the new environment needs to be real-time consistent with the “production” or primary environment. Here we introduce a real-time data replication solution like Dbvisit Replicate which will create just this real-time consistent query environment for you! This makes for the following investment:

  • Medium Oracle Sun Server X4-2 with 2 x 8 core CPU’s at € 19,500
  • 2 Oracle Database Standard Edition One licenses at € 11,200
  • 4 Dbvisit Replicate XTD at € 16,180

With this installation you add another € 50 k. of licensing in stead of € 100 k. with the Standard Edition migration. With this choice, you separate your time-critical data-entry process from the query environment, making sure a mis-fired query will not influence the availability of your data-entry process environment, which is a cool extra advantage!

* All prices are based on list-prices, excluding VAT and including 1 year of support.
** Based on the Oracle Processor Core Factor Table.