March 2016

Oracle Cloud – Managing the Database as a Service Cloud

So I am not working in the Public Cloud for a week and last night…

OUG Ireland 2016 – Summary

oug-ireland-2016

The day started at 05:00. I lay in the bath for 20 minutes in denial, wondering how I would manage to stay awake for the day. I’ve been ill for ages, so I felt like I was running on empty anyway. Once I had managed to drag myself out of the bath and get dressed, I picked up my laptop and took a taxi to the airport.

The taxi to the airport was smooth enough. I was already checked in and had no bags to drop off, so I went straight for the security and was greeted by the biggest queue I had ever seen at Birmingham airport. To all those people that laugh at me getting to the airport 2+ hours before a short flight like this I say, “Better to be safe than sorry!”

Loss Aversion and the Setting of DB_BLOCK_CHECKSUM

Within Accenture Enkitec Group, we have recently been discussing the Oracle db_block_checksum parameter and how difficult it is to get clients to set it to a safer setting.

Clients are always concerned about the performance impact of features like this. Several years ago, I met a lot of people who had—in response to some expensive advice with which I strongly disagreed—turned off redo logging with an underscore parameter. The performance they would get from doing this would set the expectation level in their mind, which would cause them to resist (strenuously!) any notion of switching this [now horribly expensive] logging back on. Of course, it makes you wish that it had never even been a parameter.

TOP-N histograms on 12c

I had an interesting question on AskTom today, with a nicely provided test case !!!,  so I thought I’d share it here with some additional commentary.

nVision Performance Tuning: General Principles

Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses.  Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers.  I have collected that advice in to a document that I have recently published on my website (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf).

The key points are

VirtualBox 5.0.16

VirtualBox 5.0.16 was released yesterday.

Downloads and changelog are in the usual places.

The installation went fine at work on Windows 7 and on Mac OS X (El Crapitan) at home.

Cheers

Tim…

Graphing Oracle performance metrics with Telegraf, InfluxDB and Grafana

Introduction

As a picture is worth a thousand words, we may want to visualise the oracle performance metrics. There is already several tools to do so, but what if you could do it the way you want? build your own graph? Let’s try to achieve this with 3 layers:

  • telegraf: to collect the oracle metrics
  • InfluxDB: to store the time-series oracle metrics
  • grafana: to visualise the oracle time-series metrics

Installation

Let’s install InfluxDB and grafana that way (for example on the same host, namely influxgraf):

HotSos Symposium and IOUG Collaborate 2016

I fly out on Sunday for HotSos and am looking forward to giving a joint keynote with Jeff Smith, as well as giving two brand new sessions on

UltraEdit 23 for Windows

UltraEdit 23 for Windows has been released. Followers of the blog will know I’m an UltraEdit junkie, so as soon as I got the email telling me UltraEdit 23 had arrived I installed it instantly. Fools rush in where angels fear to tread!

The glaring hideousness you are presented with is a ribbon! For ***** sake! Hasn’t the whole world spent enough time moaning about the Office ribbons already?

uedit23