Holacracy – Spark; Wat ik leerde van Getting Teams Done

Holacracy – Spark; Wat ik leerde van Getting Teams Done

Holacracy - Getting Teams Done - SparkHolacracy (en de variant Spark) is een methode voor teamproductiviteit, net als GTD dat is voor individuele productiviteit. De onderliggende principes van Holacracy en GTD komen sterk overeen. Aan GTD ontleent Holcracy de discipline en helderheid van het denkwerk en de gewoontes en vaardigheden die daarbij horen. In Holacracy wordt het denkwerk gedaan en zichtbaar in de overleggen van het team.

Holacracy leent ook het (more...)

Global Competitiveness Report 2015-2016

Global Competitiveness Report 2015-2016

The World Economic Forum (WEF) published its Global Competitiveness Report, a comprehensive assessment of economic competitiveness across the globe. Each country’s relative economic strength is determined by analyzing twelve pillars–including capacity to innovate, infrastructure, and health factors. The top five is:

  1. Switzerland
  2. Singapore
  3. United States
  4. Germany
  5. The Netherlands

These results shouldn’t be a surpise if you are familiar with Global Innovation Index 2015 (GII), Digital Economy and Society Index (more...)

Importing XML file with invalid character 22 (U+0016)

I have to import a set of XML files from time to time. Most of those XML files can be imported with out any problems. But at least one file includes a special character U+0016 which occurs randomly some where inside the file.

When I try to import that file I get this ORA- error message:
ORA-31011: XML-Parsing nicht erfolgreich
ORA-19202: Fehler bei XML-Verarbeitung
LPX-00217: Ungültiges Zeichen 22 (U+0016)
Error at line 39409 aufgetreten

Mehr »

APEX Developer Addon for Firefox 43+ – now signed

Quick note: I finally managed to get the APEX Developer Addon signed by Mozilla and therefor working again in Firefox 43 upwards.

Please re-download and install, version of the Addon in Firefox is now No changes for Chrome.

Apologies for the inconvenience and thanks for all those mails I got.

Extended Stack Profiling – Ideas, Tools and Comments

Topic: This post provides a short summary and pointers to previous work on Extended Stack Profiling for troubleshooting and performance investigations.

Understanding the workload is an important part of troubleshooting activities. We seek answers to questions like: what is the system doing, where is the time spent, which code paths are most used, what are the wait events, etc. Sometimes the relevant diagnostic data is easy to find, other times we need to dig (more...)

A Java EE 7 Application on OpenShift 3 With JBoss Tools

You can create and manage OpenShift applications in Eclipse with the latest version of the OpenShift Plugin for JBoss Tools. They are either pre-bundled with the latest JBoss Developer Studio (9.0.0.GA) or you can install them into an existing Eclipse Mars. This post walks you through deploying the Java EE 7 Hands-On-Lab in OpenShift with the JBoss Developer Studio.

OpenShift 3 Tooling Overview
The OpenShift 3 tooling is included as a TechPreview. (more...)

LAC de architect tussen 44 scrum teams in de 90e sprint

LAC de architect tussen 44 scrum teams in de 90e sprint

Dit is de presentatie die ik op 25 november 2015 gaf op het Landelijk Architectuurcongres over Agile Architectuur. De titel: de architect tussen 44 scrum teams in de 90e sprint:


Oracle Wait Events Investigated with Extended Stack Profiling and Flame Graphs

Topic: this post is about investigating Oracle wait events using stack profiles and flame graphs extended with OS-process state and Oracle wait event details.

Context: The case of the DB Time > CPU Time + Wait Time

Oracle instrumentation provides wait event and CPU time accounting, a powerful and readily accessible data source for performance troubleshooting. An Oracle session at a given point in time is either on CPU, for example when processing data from cache, (more...)

Wait Event Analyse mit Flame Graphs

Luca Canali hat im Databases at CERN Blog wieder einmal eine detaillierte Analyse vorgestellt, in der er Flame Graphs mit Extended Stack Profiling verbindet und damit die Aussagen des Oracle Wait Interfaces näher beleuchtet. Der eigentliche Anlass der Untersuchung ist dabei die Beobachtung des Auftretens von Fällen, in denen die DB time größer ist als die Summe von CPU time und Wait time, was a) nicht vorkommen sollte und b) mit dem Einsatz moderner Storage (more...)

Oracle JET Charts – Do we need alternatives anymore?

After I looked through the chart types supported by the new Oracle JET framework I asked myself if we need other chart plugins like D3JS or RaphaelJS in future APEX releases anymore?

The answer is: Yes in special cases.

My supposition is that we can use all available JET charts in one of the next versions of Oracle APEX.

Now I will describe the "special case" with two examples where other chart frameworks still make sense:
Mehr »

ScaleScale on the stack behind Netflix scaling

ScaleScale on the stack behind Netflix scaling

Over at ScaleScale, a blog about all the good stuff when it comes to scaling, an interesting post was published on the stack behind Netflix scaling. Since Netflix is quite public about how they operate, the post put was together with stuff from around the internet.

Stack Behind Netflix Scaling Like Spotify Netflix is kind of famous for creating and scaling their culture. This gives some important context to the culture (more...)

A business that can endure the future

A business that can endure the future

Even if your business can sort of escape competition by crafting a monopoly, it is only a great business if it can endure the future. Is one of the statements in the book Zero to One by Peter Thiel and Blake Masters.
A great business is defined by it’s ability to create cash flow in the future. In other words, the value of a business today is the (more...)

Was ist Oracle JET

Oracle JET ist das neueste Oracle Development Werkzeug mit dem Ziel moderne Webapplikationen auf Basis von Javascript zu bauen.

Die Grundlage dafür bildet ein eigens dafür entwickeltes JavaScript Development Framework das zusätzlich um mehrere mehr oder weniger bekannte OpenSource JS Frameworks (jQuery, RequireJS, Knockout und weitere) erweitert wurde.

Witzigerweise scheint Oracle JET nicht allein zu sein, denn die Abkürzung bezeichnet innerhalb des Oracle Toolsets zwei unterschiedliche Technologien.
Das neue Oracle JET (JavaScript Extension Toolkit) und (more...)

Velocity 2015 Amsterdam

Velocity 2015 Amsterdam

Thursday was a very interesting day for me at Velocity 2015 Amsterdam, build resilient systems at scale. It is one of the best conferences I attended in the last years. Using some quote’s and bullets I’ll give a little insight.

On retro’s, post mortems, etc

Lindsay Holmwood showed that what goes wrong in retrospectives, post mortems and the like is mostly based on:

Oracle Tools: pathfinder, SQLd360, eDB360

Ein paar Links von Mauro Pagano und Carlos Sierra:
Zu den ersten beiden Links ist nicht viel zu sagen, das sind kurze Einführungs-Videos zu den jeweiligen Tools. Der dritte Artikel stellt das Pathfinder Tool vor, das eine recht brachiale Form der Suche nach besseren Ausführungsplänen verwendet: es führt eine (more...)

Linux Kernel Stack Profiling and Flame Graphs Applied to Oracle Investigations

Topic: This blog post is about kernel stack profiling and visualization with flame graphs with examples.

Stack profiling and flame graphs are very useful techniques and tools for troubleshooting and investigating workloads at the OS-level and understand which code path take most of the execution time. You can find extensive material and examples o flame graphs in Brendan Gregg's website and blog. A few additional examples of using stack tracing and flame graphs for (more...)

Spalten als Zeilen ausgeben mit SQLcl

Ein Feature, das ich in psql für postgres sehr schätze, ist die Möglichkeit, durch das Kommando x die "erweiterte Anzeige" zu aktivieren, die Datensätze in einer Record-Darstellung präsentiert, also:

select * from t;

a | b | c
1 | 2 | 3
4 | 5 | 6

--> Switch display with x

select * from t;

-[ RECORD 1 ]
a | 1
b | 2
c | 3
-[ RECORD 2 ]

Forcing a “Nested Loop only” Execution Plan

Sometimes you do what you have to do. So here I confess doing something I usually avoid: forcing an Execution Plan (which is not the same as using a more conventional method for Plan stability).

This is a case on base release where the application vendor sets the optimizer to 9i, and tweaks other CBO parameters in questionable ways, then some queries produce suboptimal plans (as expected); and you are (more...)

Event Histogram Metric and Oracle 12c

Topic: event histogram metric, a script and some related comments on collecting and displaying wait event latency histograms for Oracle performance troubleshooting.

Why: Latency histograms (and by extension wait event histograms) provide very useful information when troubleshooting performance for systems exhibiting response time with multi-mode distribution. In such cases average wait values are often not sufficient to understand the behavior of the system under study and histograms provide a finer level of details. A (more...)

edb360 taking a long time

In most cases edb360 takes less than 1hr to execute. But I often hear of cases where it takes a lot longer than that. In a corner case it was taking several days and it had to be killed.

So the question is WHY edb360 takes that long?

Well, edb360 executes thousands of SQL statements sequentially (intentionally). Many of these queries read data from AWR and in particular from ASH. So, lets say your ASH (more...)