Global Innovation Index 2015

Global Innovation Index 2015

The Global Innovation Index (GII) 2015 is an annual publication which features a composite indicator that ranks countries/economies in terms of their enabling environment to innovation and their innovation outputs. The GII covers 141 economies around the world and uses 79 indicators across a range of themes. The Global Innovation Index 2015 was created by Cornell University, INSEAD, and the World Intellectual Property Organization (WIPO).

Here is an overview (more...)

Global startup map

Global startup map

Following the several indexes on startups and innovation I’ve been following last period I found an interesting map of startups. Startupblink offers a world map of the startup ecosystem. You can use the startup map to zoom, filter etc the startups in your neighborhood. Besides a map of startups, it offers information on other related entities such as co-working spaces, accelerators, startups organizations, tech reporters and much more…

You can read an (more...)

Performance testing at

Performance testing at

On Monday October 12th Rob de Groot and Chris Kramer of the test automation team and development process innovation team will present on performance testing at The presentation is for the Dutch Web Performance & Operations Meetup, as a pre-event for the WebPerfDays.

Rob and Chris will elaborate on how performance testing evolved at and show how modern tooling like Docker and Mayfly (more...)

VUCA – Volatility, uncertainty, complexity and ambiguity

VUCA – Volatility, uncertainty, complexity and ambiguity

Recognising that change is the only constant, shows us the path to VUCA. VUCA is the acronym for volatility, uncertainty, complexity and ambiguity. VUCA stems from military vocabulary and has been emerging in ideas on strategic leadership. The 4 elements of VUCA offer a context in which organisations view their current and future state. On a strategic level who isn’t interested in preparing for a volatile, uncertain, complex (more...)

Fehlende Foreign Keys mit dem SQL Developer ermitteln

Regelmäßig erinnert mich Jeff Smith mit seinen Artikeln daran, dass es doch eine gute Idee wäre, endlich mal dazu überzugehen, den SQL Developer zu meinem Standardwerkzeug zu machen. In einem aktuellen Beitrag weist er beispielsweise darauf hin, dass der SQL Developer Data Modeller anhand von Spaltennamen und Datentypen dazu in der Lage ist, über eine Option "Discover Foreign Keys" Vorschläge zur Erzeugung fehlender FK-Constraints zu generieren. Das erfordert natürlich eine konsistente Namensgebung, so dass das (more...)

Digital Economy and Society Index (DESI) 2015

Digital Economy and Society Index (DESI) 2015

The data presented by Digital Evolution Index seems supported by data from the European Commission. The EU defined a Digital Economy and Society Index to support and measure progress on the digital agenda for Europe:

The Digital Economy and Society Index (DESI) is a composite index that summarises relevant indicators on Europe’s digital performance and tracks the evolution of EU member states in digital competitiveness.

The Digital (more...)

Theory of constraints

Theory of constraints

The Goal - Theory of ConstraintsThink it was back in 1993 I first read The Goal by Eliyahu Moshe Goldratt. The book was one of the first and most notable in the genre of business novels. The book – The Goal – introduces the theory of constraints (TOC) process for improving organisations. The book is set in a manufacturing company. However the book provides the context for a more generic approach to continuous improvement.

Theory of constraints


A Short Note on Pesky CSSCAN Results Before a Characterset Change

A client of mine was busy correcting one of his development streets and therefore the NLS charactersets of about 10 EE databases had to be changed.
Most of the databases were originally configured with WE8ISO8859P15, others with WE8ISO8859P1 and all of them had to get WE8MSWIN1252. Some of them were single instances (export, development and test), some RAC (acceptance) and some of them were RAC plus Dataguard (production, for the procedure (more...)

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...)

Estimating Apex Development

You’ve finished the design for an Apex application, and the manager asks you “when will you have it ready to test”. You resist the temptation to respond snarkily “how long is a piece of string” – which, by the way, is often the only appropriate answer if they ask for an estimate before the design work has started.


Since you have a design and a clear idea of what exactly this application will do, you can build a reasonable (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...)

Heat Map Visualization for SystemTap

Topic: PyLatencyMap v1.2 and how it can be used to produce heat map visualization of SystemTap histograms.

Introduction: When studying storage performance, the latency drill down is a very important data source. Measuring the average I/O latency is often not enough, latency histograms are proven to more suitable for investigating modern storage systems. This is because for many storage systems the response time has multiple modes: think for example of the common case of storage (more...)

SQLTXPLAIN under new administration

During my 17 years at Oracle, I developed several tools and scripts. The largest and more widely used is SQLTXPLAIN. It is available through My Oracle Support (MOS) under document_id 215187.1.

SQLTXPLAIN, also know as SQLT, is a tool for SQL diagnostics, including Performance and Wrong Results. I am the original developer and author, but since very early stages of its development, this tool encapsulates the expertise of many bright engineers, DBAs, developers and (more...)

Optimizing working environment. Part I, GUI

Working with database performance troubleshooting means dealing with challenging and exciting problems. But it also means doing certain things over and over. And over. Like typing the same query or clicking the same button zillion times a day. And when you’re doing something very frequently, anything that can be done to simplify or automate such tasks becomes very important. So I decided to share some of the tricks I use to optimize my working experience in (more...)

Analyzing segment content by block type

Occasionally one might want to know what a segment is made of in terms of block types. For example, you notice that the number of blocks in an index segment is somewhat larger than the number of branch and leaf blocks, and wonder what kind of blocks accounts for the difference. The only way to do this is by dumping index blocks (e.g. as described in Richard Foote’s blog here). Dumping blocks is easy, but (more...)

Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization

Topic: This post is about the latest updates to PerfSheet4 v3.7 (February 2015). PerfSheet4 is a tool aimed at DBAs and Oracle performance analysts. It provides a simplified interface to extract and visualize AWR time series data using Excel pivot charts.

Why PerfSheet4: PerfSheet4 is aimed at querying and displaying time-series data from AWR repository tables. This is very a rich source of information to analyze database workloads and trends in the context of performance analysis or (more...)

Life of an Oracle I/O: tracing logical and physical I/O with systemtap

Topic: This post is about tracing logical and physical reads in Oracle using systemtap. You will find a few examples illustrating the main mechanisms used by Oracle to do physical and logical I/O and you will learn how to build systemtap scripts to further explore and troubleshoot Oracle I/O.

Introduction: Performing input/output to and from the storage media, i.e. physical I/O, is one of the critical tasks underlying all database engines. When accessing data (more...)

SystemTap into Oracle for Fun and Profit

Topic: This post is about using SystemTap for investigating and troubleshooting Oracle RDBMS. In particular you will learn how to probe Oracle processes and their userspace functions. These techniques aim to be useful as well as fun to learn for those keen into peeking under the hood of the technology and improve their effectiveness in troubleshooting and performance investigations.


Userspace probing is a very powerful technique that can be used to complement the available (more...)

Flame Graphs for Oracle

Topic: This post is a hands-on introduction to using on-CPU Flame Graphs for investigating Oracle workloads. This technique is about collecting and analyzing sampled stack trace data to analyze and troubleshoot Oracle processes at the OS level (in particular applied to Linux).

Motivations: The techniques and tools described here can be used for performance investigations to complement wait-event based information gathered from the Oracle engine, such as information available with ASH and sql monitoring. They (more...)