August 2015

OTN Tour of Latin America 2015 : GUOB, Brazil – Day 1

I woke up pretty early again, spent a bit of time working, then headed down to meet the wife at breakfast. I was gabbing away, when she mentioned it was time to register. I had a mad dash to get back to the room, shower and head down to the GUOB event. Thankfully, I am stopping in the conference hotel.

This was a three track event, so I tried to get to sessions that I hadn’t seen at other events.

OTN LA Tour 2015 Presentations

Here are links to the presentations for the OTN Latin America Tour 2015.

Controlling Execution Plans (without touching the code)

In-Memory In Action (slides by Tanel Poder) :)

Scripts from Today’s Family Coding and Hands on Lab Fix

RMOUG’s Quarterly education workshop was a great event today and I appreciate everyone who came out and those who spent time with their family and their user community doing fun geeky stuff.

OTN Tour of Latin America 2015 : GUOB, Brazil – Day -1

As I mentioned in the previous post, I got to bed at the hotel in Sau Paulo at about 03:00. I woke up at about 07:00 and did some work for a couple of hours before hitting breakfast with the wife. At breakfast we were joined by Francisco and his son. :)

CBO catchup

It’s interesting to watch the CBO evolving and see how an enhancement in one piece of code doesn’t necessarily echo through to all the other places it seems to fit. Here’s an example of an enhancement that spoiled (or, rather, made slightly more complicated) a little demonstration I had been running for about the last 15  years  – but (in a fashion akin to another partitioning limitation) doesn’t always work in exactly the way you might expect.

OTN Tour of Latin America 2015 : AROUG, Argentina – Day 2

I mentioned in the previous post we were spending the day sightseeing today. Last time I was in Buenos Aires I did a bus tour. You can see some of the photos here.

OTN Tour of Latin America 2015 : AROUG, Argentina – Day 1

I woke up far too early and spent a few hours on the computer.

A number of folks on the tour have built up so many Hilton Honours points they get access to the executive lounge, so I was signed in as a scummy guest and I got breakfast for free. :)

At about 09:00 we walked across to the AROUG event, which had the following order of events.

OTN Tour of Latin America 2015 : UYOUG, Uruguay – Day 2

I woke up early and started working on the computer. I wrote a couple of blog posts and logged in to work to check some stuff out. I also re-recorded the vocal for the ALL, ANY and SOME video. The mic I was using wasn’t too good, but I was keen to get it done, rather than wait until I got back to the UK. Overall, it was a pretty busy morning.

Index compression–working out the compression number

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives about index compression, and very little negatives.  But obviously one critical thing is choosing the right number of leading columns to compress. Is it just "take a guess?" .  Luckily, Oracle has taken the guesswork out of it.

The ANALYZE command on an index can let you find the optimial compression count.  When you do an ANALYZE INDEX command, two critical columns are populated:

Navigating the world of Oracle database documentation

If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can find about the database.  If you’re a seasoned Oracle professional, then you probably dont think twice about finding PIVOT examples in Chapter 18 of the Data Warehousing guide Smile

But for the novice, whether it be DBA or Developer, it can be a bit overwhelming.  One resource that you might find a useful addition to your navigation of the Oracle universe, is the interactive quick reference site.