Search

Top 60 Oracle Blogs

Recent comments

September 2015

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.

Index Advanced Compression: Multi-Column Index Part I (There There)

I’ve discussed Index Advanced Compression here a number of times previously. It’s the really cool additional capability introduced to the Advanced Compression Option with 12.1.0.2, that not only makes compressing indexes a much easier exercise but also enables indexes to be compressed more effectively than previously possible. Thought I might look at a multi-column index to highlight just […]

Presenting the Hotsos Symposium Training Day – 10 March 2016 (Heat)

I’ve just accepted an invitation to present the Hotsos Symposium Training Day on 10 March 2016 in sunny Dallas, Texas. In the age of Exadata and In-Memory databases, it’ll be an updated and consolidated version of my Index Internals and Best Practices seminar. With an emphasis on using indexes appropriately to boost performance, it’ll feature […]