August 2015

OTN Tour of Latin America 2015 : PEOUG, Peru – Day 1

A quick taxi ride got us to the conference hotel really quickly, so we were nice and early for the PEOUG event.

After the introductions by Miguel Palacios, it was time for the first sessions of the event. Of the English speakers, first up were Debra Lilley and Dana Singleterry. Debra had some problems with her laptop, so she did her presentation using mine and all went well. Dana did his session over the net, so I sent a few Tweets to let him know how things looked and sounded from our end. I figured a bit of feedback would help reassure him there weren’t any technical issues.

getSQLMON… mining SQLMON reports from Oracle

As an Oracle performance engineer, I often work with customers on benchmarks and diagnosis of various issues.  Now, everyone can gather an AWR report and send it my way, but that is just the tip of the iceberg.  AWR reports are great for summarizing activity at a high level and can even find a SQL that is taking longer than expected.  So, once we have identified a poor performing SQL, how do we fix it?

…that is where SQLMON comes into the picture.

gathering sqlmon reports

The power of the SQLMON report is very well documented.  It provides an insight into EXACTLY what was happening when that query was running on the system.  It documents the run time, SQL plan, CPU activity, IO activity, Offload, etc…  The report can be gathered by running the “dbms_sqltune.report_sql_monitor” utility to extract a report.  Each SQL in Oracle maps to a specific “SQL_ID” as this is really just a hash of the sql text….But, that is not all.

OTN Tour of Latin America 2015 : PEOUG, Peru – Day -1

After the CLOUG event, Francisco drove us to the airport, where Kerry, Ronald, Debra and I parked ourselves in the lounge for a while. Lots of eating then ensued! Kerry was flying back home, but the rest of us were on our way to Lima, Peru, for the PEOUG event. :)

OTN Tour of Latin America 2015 : CLOUG, Chile – Day 1

The morning was a little confusing. I got up and went to breakfast, but there was no Debra. Once I had finished I got the front desk to call her and found out her clock was an hour behind. Chile has changed its timezone to match Brazil, but some Apple devices don’t seem to realise this, even if they are set to auto-update. One of those devices being Debra’s phone. When we asked at the hotel, they said it’s been a problem for a number of people. :(

Installing the Oracle database in docker

This blogpost is about how to install and run the Oracle database in docker. Please mind this is not an officially supported virtualisation platform for the Oracle database. This is a proof of concept setup.

Linux host setup.
In my setup, I used a linux host, freshly installed with Oracle Linux 6.7, which is going to be used as docker server. Please mind you need to leave diskspace (or a disk device) unused for the commonly documented docker setup with the btrfs driver. The root filesystem is using a ext4 filesystem by default. For the proof of concept setup, a 20G diskspace for the Operating system only is enough. I used the minimal linux installation.

The first step is to add a disk, or use a partition and format it with btrfs and mount it:

Preparing a Oracle Linux for a Vagrant box

This post is an overview of an installation and configuration process of the Oracle Linux, which will be used as a machine “box” for Vagrant software using a Virtual Box platform.

Post itself is divided into two parts:

  1. Oracle Linux installation (points 1 to 12)
  2. Vagrant box configuration (points 13 to 16)


Part 1 – Oracle Linux installation

 

1. Create a new Virtual Machine - machine name will be used later to create Vagrant box

Preparing a Oracle Linux for a Vagrant box

This post is an overview of an installation and configuration process of the Oracle Linux, which will be used as a machine “box” for Vagrant software using a Virtual Box platform.

Post itself is divided into two parts:

  1. Oracle Linux installation (points 1 to 12)
  2. Vagrant box configuration (points 13 to 16)


Part 1 – Oracle Linux installation

 

1. Create a new Virtual Machine - machine name will be used later to create Vagrant box

Better SQL via query block names

Can you make your SQL code easier to understand without adding comments. Can it be self-documenting ? Can you do your bit to make sure your code is easily comprehended by the next person who has to maintain your code ? Yes you can.  Learn how at my next quick tip at https://youtu.be/bfaFT9doqCg

Is this a license to never add comments in and around your SQL code ?  Of course not.  There’s a great quote, and if you’re the author, I apologise for not providing proper attribution.  Google didnt help.

pshyco_jiller
But I can’t agree more.  Have great self-documenting code AND have great commentary around it.

RAM is the new disk – and how to measure its performance – Part 1 – Introduction

[ part 1 | part 2 | part 3 ]

RAM is the new disk, at least in the In-Memory computing world.

No, I am not talking about Flash here, but Random Access Memory – RAM as in SDRAM. I’m by far not the first one to say it. Jim Gray wrote this in 2006: “Tape is dead, disk is tape, flash is disk, RAM locality is king” (presentation)

OTN Tour of Latin America 2015 : CLOUG, Chile – Day -1

We were due to leave the hotel in Sau Paulo at 04:45 today, so I was planning to get up at around 04:00. Instead, I woke up at 03:00 and couldn’t sleep. I think I was a little nervous about missing the flight.

The journey to the airport didn’t present any major dramas at that time. There was a little mixup with the size of the taxi, so we had to travel in two cars, but that was fine. Debra and I travelled with David Peake, who was leaving us at the airport to fly to Brasilia for an APEX conference. Francisco and his son were in a separate care.