Oracle Enterprise Linux – Pre-Built for Enterprise

We've shared the AMI we use for running Oracle Enterprise Products like e-Business Suite. You'll find it on the AWS Marketplace pre-loaded with all the pre-requisites you need for your Oracle implementation on AWS.

Link to the Marketplace...

Touchpad tuning on linux: touchpad-indicator…

I encoutered some problems with my touchpad on ubuntu:
While typing some text, the touchpad signalled the mouse some strange moves. Sometimes it marked parts of the text and the next key erased the highlighted text...

First idea was to edit the xorg.conf or something else, but i found a less difficult was via touchpad-indicator.

It can be installed via
apt-get install touchpad-indicator
Alittle problem is, that you can not run it via cli (more...)

MONDAY SPOTLIGHT: Oracle OpenStack for Oracle Linux R3 Webcast and More

Last week we have released Oracle OpenStack for Oracle Linux Release 3.0, based on upstream Mitaka, you can read about the details of this announcement in our Oracle OpenStack blog

We have recorded a short "An Introduction to Oracle OpenStack for Oracle Linux 3" podcast that gives a snapshot of the announcement.

You are also welcomed to watch  "Easy Deployment of Oracle Applications and Database with OpenStack" webcast (on demand) that (more...)

A performance deep dive into column encryption

Actually, this is a follow up post from my performance deep dive into tablespace encryption. After having investigated how tablespace encryption works, this blogpost is looking at the other encryption option, column encryption. A conclusion that can be shared upfront is that despite they basically perform the same function, the implementation and performance consequences are quite different.

Column encryption gives you the ability to choose to encrypt per individual column, that’s kind of obvious. However, (more...)

A performance deep dive into tablespace encryption

This is a run through of a performance investigation into Oracle tablespace encryption. These are the versions this test was performed on:

$ cat /etc/oracle-release
Oracle Linux Server release 6.8
$ /u01/app/oracle/product/ lspatches
24315824;Database PSU, Oracle JavaVM Component (OCT2016)
24006101;Database Patch Set Update : (24006101)

In this test I created an encrypted tablespace:

SQL> create tablespace is_encrypted datafile size 10m autoextend  (more...)

#Javaland 2017 wrap up

Yes – I did it again and attend Javaland conference in Phantasialand Brühl.

It was not easy this year to concentrate on the sessions because of the hottest march of the last 100 years. But the quality of the sessions beats the weather. Maybe again my invest in reading the abstracts and filter the sessions before the conference has payed off.

Day 1 Conference

Jens Schauderdocumentation & slides with AsciiDoc, Git, Gradle and Reveal.js


Using virt-install/KVM and kickstart to create lots of identical VMs quickly

In preparation for an upcoming talk about Oracle 12.2 I am planning on getting my feet wet with the Oracle 12.2 Sharding option. It seems to be a very interesting subject to get into, but like all new subjects, they can be intimidating at first due to their complexity. So why not use the instructions someone has already written down?

Oracle has a nice series of articles about Sharding. I found the Sharding (more...)

Python variable not defined

While working with a programming example for my students, I ran into an interesting run-time error when I changed their approach to importing Python’s random module. Here’s the raised error message:

Traceback (most recent call last):
  File "", line 84, in 
    speed = [choice([-2,2]), choice([-2,2])]
NameError: name 'choice' is not defined

You raise the missing choice identifier when two things occur. The first thing requires you to use a standard import statement, like the (more...)

Install PyGame on Fedora

The PyGame library is a wonderful tool for building games with Python. It lets you accomplish a great deal by simply managing events. You need to understand how to use Python functions, modules, and events to build games with this Python library.

You can download and install the PyGame library with the yum utility like this:

yum install -y pygame

It should generate the following list when you install it as the root user:

Loaded  (more...)

Huawei Announces Oracle Linux Certification for Huawei FusionSphere

Huawei announced today that the Huawei FusionSphere cloud operating system has been awarded Oracle Linux Hardware Certification and now supports the Oracle Linux operating system as a guest operating system. With this announcement, Huawei’s FusionSphere cloud platform further extends its compatibility by supporting popular enterprise Linux operating systems.

FusionSphere is an OpenStack-based cloud operating system designed for customers from a wide range of industries. It offers powerful virtualization and resource pool management functions, rich cloud (more...)

Enable HyperFIDO U2F Key on Linux

Recently, I bought the Hypersecu HyperFIDO K5 Key to help me secure access to several websites and services with U2F (“Universal Two-Factor Authorization”). This works fine on Windows, but with Linux things get a little complicated: The key isn’t accessible to all users by default. This has to be activated using udev rules, which is widely […]

Using VS Code for PL/SQL development

I've been using Sublime Text as my main editor for PL/SQL development for many years, but I'm now in the process of switching to Visual Studio Code (VS Code).

Some good reasons to use VS Code:
  • Multi-platform (Windows, OS X, Linux)
  • Free, open source
  • Lightweight, fast
  • Large ecosystem of extensions
  • Built-in Git support
  • Can be adapted to PL/SQL coding via a plsql language extension (syntax highlighting, go to/peek definition, go to symbol) and PL/SQL compilation (more...)

MONDAY SPOTLIGHT: Updated whitepaper for Oracle Linux Management with Oracle Enterprise Manager 13c

Happy Monday to all Linux fans. Today we would like to highlight an updated whitepaper available here.  This whitepaper describes the comprehensive Oracle Linux management capabilities available in Oracle Enterprise Manager and has been updated for the latest version of Oracle Enterprise Manager 13c.

Oracle Enterprise Manager 13c enables customers to have complete visibility into their Oracle Linux environment. If the IT environment consists of a large investment in Oracle hardware, Oracle (more...)

Little things worth knowing: Executing RDA on RAC

Result! I have finally been able to gather a complete RDA (Oracle Remote Diagnostic Agent) output on my 2 node RAC system. After consulting the relevant documentation on MOS-which is spread over at least 42 Doc IDs-I found them not to be very helpful to the degree that some of what I read is actually wrong or contradicting. I put together a short note, primarily to myself, to remind me of the process. I hope you find it useful, (more...)

MONDAY SPOTLIGHT: Oracle Linux Website Enhancements

Happy Monday to all Linux fans, 

Have you visited Oracle Linux website lately? We made some changes which will make it easier for you to navigate to download page or buy support from Oracle Store. We also implemented chat if you have any questions before you download of purchase from store.

Bookmark our page and visit often for whitepapers, webinars and any other resources you may need. 

What Drives Linux Guru Wim Coekaerts?

... Have Fun, Build Things People Will Use.. 

In a recent Forbes article, Wim Coekaerts, SVP, Linux and Virtualization Engineering talks about what makes him happy. 

In his long career, he’s found joy working on early database appliances, and later guiding Oracle’s effort to make Linux, the open source operating system he’d played with since his school days in Belgium, its OS of record. Now, “Linux has become the operating system of the (more...)

New Events for Data Guard and Synchronous Redo Transport in 12c (2)

After the baseline has been established in the first part of this series it’s time to measure the effect of the network in this part. The second test will introduce an interesting feature: Using Linux’s own Traffic Shaper/Quality of Services module I will add a delay of 100ms to the Data Guard network interface card (NIC) to slow things down a little.

WARNING: this is of course a lab or VM-only situation. I can’t (more...)

Oracle 12.2 wait event ‘PGA memory operation’

When sifting through a sql_trace file from Oracle version 12.2, I noticed a new wait event: ‘PGA memory operation’:

WAIT #0x7ff225353470: nam='PGA memory operation' ela= 16 p1=131072 p2=0 p3=0 obj#=484 tim=15648003957

The current documentation has no description for it. Let’s see what V$EVENT_NAME says:

SQL> select event#, name, parameter1, parameter2, parameter3, wait_class 
  2  from v$event_name where name = 'PGA memory operation';

------ ------------------------------------- ---------- ---------- ---------- ---------------
   524  (more...)

MONDAY SPOTLIGHT : You are invited to Asia Pacific Webcasts in March and April

Happy Monday to all Linux fans, this week we would like to highlight some of the online events that we are running in our Asia Pacific region. You can also watch the on-demand webinar at a time suitable in your calendar but don't forget to register to upcoming events if you are in that region or prefer the evening webinar in North America. These are live events that you can ask questions and provide comments (more...)

New Events for Data Guard and Synchronous Redo Transport in 12c (1)

I may have said it before but I consider presenting and teaching a great way to expand one’s knowledge: first of all it requires me to really understand a subject. Secondly, when presenting, you get lots of interesting questions that can turn into blog posts like this one.

Lately I have been asked about the impact of synchronous log shipping to a physical standby database. I was sure there was an effect to be observed, (more...)