Search

Top 60 Oracle Blogs

Recent comments

September 2015

Site Maintenance (20th Sept 2015 22:00 GMT) : Update

DiagnosticsLast night was the big server move. According to my monitoring, the site went down at approximately 23:30 GMT last night and was back again by 01:30 GMT this morning, so the site was offline for about 2 hours.

Everything looks normal to me this morning, so it I guess the move of my server between the racks in their data centre went OK. :)

Cheers

Tim…

Automation for DBA - Vagrant part 2

Hello,

In the last post I presented steps to create Virtual Machine using Vagrant with Virtual Box. It is a native combination but there are other possibilities as well. This post will cover an integration of Vagrant tool with KVM hypervisor and AWS EC2 cloud.

In both cases, an additional plugins has to be installed:
-    vagrant-libvirt plugin for KVM - https://github.com/pradels/vagrant-libvirt
-    vagrant-aws plugin for EC2 - https://github.com/mitchellh/vagrant-aws

If there is a requirement to use a Vagrant boxes defined for other hypervisors, there is a plugin called vagrant-mutate, which help you to convert it from one format to another.

Automation for DBA - Vagrant part 2

Hello,

In the last post I presented steps to create Virtual Machine using Vagrant with Virtual Box. It is a native combination but there are other possibilities as well. This post will cover an integration of Vagrant tool with KVM hypervisor and AWS EC2 cloud.

In both cases, an additional plugins has to be installed:
-    vagrant-libvirt plugin for KVM - https://github.com/pradels/vagrant-libvirt
-    vagrant-aws plugin for EC2 - https://github.com/mitchellh/vagrant-aws

If there is a requirement to use a Vagrant boxes defined for other hypervisors, there is a plugin called vagrant-mutate, which help you to convert it from one format to another.

Site Maintenance (20th Sept 2015 22:00 GMT)

DiagnosticsJust a quick heads-up about some work going on tomorrow on the website.

My hosting provider has decided my server needs to be put into a new rack, so somewhere after 22:00 GMT tomorrow (20th Sept 2015) the server will be switched off, moved to a new rack and switched on. They say the process should be complete within 4 hours. I’m hoping this is a massive overestimate. :)

If you are trying to use the site around that time and it’s not there, DON’T PANIC! I’ll be doing plenty of that for both of us. :)

Cheers

Friday Philosophy – The Issue of Exceptions in your Mailing Lists

A couple of days ago I got the below email about the next UKOUG Database Server SIG being full. That’s great to see! A full user group meeting. If I still wanted to attend, I could be added to the waiting list:

ScreenHunter_42 Sep. 14 11.25

It made me smile as, guess what, I was already due to be there. I was the last speaker on the agenda! It was going to be awkward if I failed to get from the waiting list to an actual place at the event, it could be a very quiet session…

SANGAM15 – See you there!

I mentioned my Oracle OpenWorld 2015 trip in a previous post. Yesterday evening I picked up my passport with my lovely new India visa in it!

The talks are written. The flights are booked. The hotel is booked. I have a visa. So that’s me sorted for SANGAM15 in November! :)

Row transposition

Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:

How do you convert a listing in rows (eg, where people placed in a race), into some output that is across the page ?

For example, given a running race, how do you generate output which looks like this:

| RACE_ID | PLACING1 | PLACING2 | PLACING3 | PLACING4 |

So here’s our source table

BI Publisher Tips and Techniques

A colleague of mine asked recently if we had any best practices for BI Publisher, the latest and greatest reporting tool we use within Enterprise Manager (the old tool, Information Publisher, is of course also still supported but this post is relevant to BI Publisher). As you would well know if you’ve been following my posts or heard me presenting at conferences, best practices is a term I hate, so rather than using that term let’s discuss some tips and techniques that might be relevant to you when using BI Publisher.

Tip #1: Allocate Extra Memory

The amount of required memory for BI Publisher depends on a huge number of factors – complexity of reports, size of datasets being returned, BI Publisher scheduling load, etc. We recommend adding at least 1.5 Gb of RAM for the OMS machine, but you may need as much as 4-5 Gb depending on the factors just mentioned.

We are hiring!

Gluent – where I’m a cofounder & CEO – is hiring awesome developers and (big data) infrastructure specialists in US and UK!

We are still in stealth mode, so won’t be detailing publicly what exactly we are doing ;-)

However, it is evident that the modern data platforms (for example Hadoop) with their scalability, affordability-at-scale and freedom to use many different processing engines on open data formats are turning enterprise IT upside down.

The Fundamental Challenge of Computer System Performance

The fundamental challenge of computer system performance is for your system to have enough power to handle the work you ask it to do. It sounds really simple, but helping people meet this challenge has been the point of my whole career. It has kept me busy for 26 years, and there’s no end in sight.

Capacity and Workload

Our challenge is the relationship between a computer’s capacity and its workload. I think of capacity as an empty box representing a machine’s ability to do work over time. Workload is the work your computer does, in the form of programs that it runs for you, executed over time. Workload is the content that can fill the capacity box.