Who's online

There are currently 0 users and 40 guests online.

Recent comments


Oakies Blog Aggregator


Well, the annual spectacle of enormous proportions has come to a conclusion again. And thats probably the first reason I’d recommend OpenWorld to anyone who works with Oracle who has never been to it. It’s a jaw dropping moment just to see the scale of the event, and how impressively its organised in terms of facilities, lunches, registration and the like.

But onto the technical elements, here’s my impressions of this years conference:

1) Big data, Big data, Big data, Big data

Somewhere in the conference I think there might have been some coverage of database, middleware and cloud :-) but it was dwarfed by Big Data (no pun intended). From an australian perspective, I found this quite interesting, because whilst there is a groundswell of interest in the philosophies and tools relating to big data, I’d hardly say its taken the nation by storm. Maybe things will change in the coming years.

Having said that, one thing I was pleased to see (as an Oracle dinosaur) was a realisation that SQL still persists as the dominant query language, and hence the clamour by vendors to provide a good SQL interface layer on top of their respective big data products. The promise of running SQL over some, any or all data sources, whether they be RDBMS or any other data structure sounds very cool.

2) In-memory

Lots and lots of presentations on the new in-memory database option, and its very hard to find anything bad to see about the feature. It just looks like a wonderful feature although you have to pay for all that wonderment :-) My only disappointment from the conference was that each session was done “standalone” which means the first 15 mins of each precious 45min slot, was the same 10 slides describing the fundamentals. I would have preferred a single intro session, with then other sessions going more into the nitty gritty.

3) Passion matters

A number of presentations on topics close to my heart did little to inspire me, whereas others on topics that (I thought) had no interest to me were riveting, and it all comes down to the enthusiasm of the presenter for the technology they were talking about.

4) The app

Sadly….the OpenWorld app was a PR disaster for Oracle based on the tweets I saw about it (some of which were my own). I’m mentioning this not to unload a fresh bucket of invective in the public arena, but to encourage people to provide feedback to the conference organisers. I was as guilty as anyone else in terms of getting more and more emotive with my tweets as I got more and more frustrated with the app as the week went on. But I also tabulated my issues and sent them off to the organisers, trying to be as objective as possible as well as providing suggested fixes. I recommend you do the same.

All up, another great week, with lots of cool new things to explore and blog about :-) Now onto downloading all the slides…

Abstract Review Tips

Yes, this is for my RMOUG abstract reviewers, but it may help other conferences and user groups, too.  We have some incredible content at RMOUG, (Rocky Mtn. Oracle User Group) Training Days conference and its all due to a very highly controlled, thought out process that has evolved over time to ensure that we have an abstract selection process that is as fair as possible and offers new speakers opportunities as well.

I’m going to share my abstract scoring summary with the rest of the class to start, so you get an idea of how we score.  As a strong DBA who has done development and a bit of mobile development, I can go across a number of tracks to perform reviews, but you will definitely notice that I don’t review the following:

1.  Almost anything in the BI track.image

2.  Skip over any in development or other tracks that I’m unsure of.

3.  Never score on my own abstracts, (yes, I submit mine to go through the abstract process, but then pull my high scoring ones afterwards and retain them to add to the schedule if we have a last minute cancellation.  Tim does the same this last few years.)


You will also notice that I don’t just score whole numbers, but give me more variation in the results by adding more definitive scores.

I carefully inspect the “Review Summary by Rating” to verify that my percentage of scores are somewhere close to what we recommend at the top of the summary page, (seen in blue at the top of the screenshot.)

How to Review

Knowing what to look for and how to score it is important.  We are a tech conference, so if an abstract appears to be marketing anything, if you are not high tech, you may find a low score on the abstract.

Our reviewers are asked to look for great content, variety in content, new and interesting topics and they will score an abstract down if it is incomplete or has grammatical/spelling errors.  This may seem harsh, but if someone can’t take the time to fill out an abstract, it’s difficult to believe quality time will be put into the presentation.

Why It’s Important

Our reviewers and review scores are crucial to our selection process.  This next week, after we close reviews on the 6th of October, we will pull all of the abstracts with their overall average score.  We will arrange the track by highest to lowest and then pick out the top scoring abstracts for each track.

1.  The percentage of abtracts submitted for that track is the percentage of slots allotted of the available total.

2.  We then look for # of high scoring abstracts per speaker across ALL tracks and remove the lowest of theirs till they have two max each, (we only have 100 session slots available and we want everyone to have as much an opportunity to speak as possible!)

3.  I then have marked in comments for anyone I see as a new speaker.  We see how the abstract scored and see if we can add them freely to the schedule or if they may require mentoring from a senior speaker from the conference.  We add in these new speakers to the openings made by step#2.

4.  We build out the schedule into tracks, so that no matter what your specialty area, you should always have something incredible to attend.

5.  Those great scored abstracts I had to hold back as the speaker already had two accepted?  I retain those, along with mine and Tim’s to use as fillers if there is a last minute cancellation.

I’ve just finished my reviews and I’m incredibly impressed with the abstracts this year!  The quality of the abstracts and variety of impressive topics can only mean that its going to be the BEST RMOUG Training Days EVER!!







Copyright © DBA Kevlar [Abstract Review Tips], All Right Reserved. 2014.

OOW14 Session: The Art and Craft of Tracing

A big thanks to all those who braved attending my session on the final day of Oracle Open World 2014. I hope you enjoyed it and found it valuable.

You can download the slide deck as well as the scripts I mentioned here.

As always, I would love to hear from you.

OOW14 Session: RAC'fying Multitenant

Thank you for attending my session RAC'fying Multitenant at Oracle Open World 2014. You can download the slide deck here.

[Updated] Oct 4th, 2014: The article on multitenant I wrote for OTN is available here. This article shows various commands I referenced in my session, e.g. point in time recovery of PDBs.

As always I would love to hear from you.

Index Compression Part V: 12c Advanced Index Compression (Little Wonder)

I’ve finally managed to find some free time in the evening to write a new blog piece :) This will have to be the record for the longest time between parts in a series, having written Part IV of this Index Compression series way way back in February 2008 !! Here are the links to the previous articles […]

Site Hosting Update : The Proxy Wars

This site hosting thing really is the gift that keeps giving. :)

I wrote a little over a week ago about an outstanding issue with the website, which seemed to be related to people’s company proxy servers, rather than my web server. While I was staying at the Sofitel, I started to get the issue where the HTTP address for my website was giving me the following error.

You don’t have permission to access / on this server.

By the time I was in a position to look at it, I had already moved to the Hilton, which did not exhibit the same problem. After Googling around and discounting the obvious stuff, like missing pages, bad configuration and file/directory permission issues, I came across a reference to some proxy servers (including Squid) producing the same error because they use HTTP 1.0 rather than HTTP 1.1. A suggestion to solve this was to set the following in the “/etc/httpd/conf/httpd.conf” file.

SetEnv force-response-1.0

If a HTTP 1.0 request is sent to Apache, this setting will make sure a HTTP 1.0 response is sent back. Any HTTP 1.1 requests are dealt with in the normal fashion. It sounded like it was worth a try, but I had no way to test the impact. That is until Eric Grancher contacted me to say his hotel had the same issue. I added the setting and asked him to check again. Problem solved…

So I think/hope that issue is solved now… :)



Site Hosting Update : The Proxy Wars was first posted on October 2, 2014 at 4:44 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle OpenWorld 2014 : Wednesday

Another early start on Wednesday. I headed down to meet the Dbvisit gang for breakfast. FYI: I’m not paid to keep mentioning them and I don’t work for them. They are just a great group of people who I really like, so when I get a chance to meet up with them I do. :)

From there it was on to Moscone where I bumped into Eric Yen. We’ve known each other for years on the interwebs, so it was nice to spend some face-to-face time. I also bumped into Daniel De Meda again. We chatted for a while the previous day, so when we met today we did a selfie. From there it was off to the demo grounds again, then I met up with Sve Gyurov for lunch.


If you’ve ever met Sve, you will realise that I am on tiptoes and he is crouching when we took this shot, otherwise this would be a picture of my head and his chest. :)

After lunch I had a major attack of lethargy, so I headed back to the hotel for a rest, which I’ve just surfaced from at 20:00. :( I’m going to duck out of the evening events as well…

So this really marks the end of OpenWorld for me, because I leave tomorrow morning. It’s been a really strange one for me this year. I enjoyed the ACE Director Briefing and felt like I was coping really well, then I kind-of crashed once OOW actually started. What with being ill for the 3 weeks prior to the event, then having to deal with the jet lag, I really had no reserves to fall back on this year. I feel a bit disappointed with myself as it feels like a wasted opportunity, but you can only do so much…

I’ll write a wrap-up post about the whole event when I get back.



Oracle OpenWorld 2014 : Wednesday was first posted on October 2, 2014 at 4:15 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle OpenWorld 2014 : Tuesday

Tuesday started early with 5 hours in the hotel lobby. The plan was to catch up on my blogging using the free wifi. I hadn’t blogged for a couple of days, which prompted an email from my mom to see if I was OK. :)

It took about 5 hours to complete two blog posts, because every 30 seconds someone new walked by and I was “forced” to speak to them. :)

That done, I headed down to Moscone South to check out the Dbvisit stand. I mentioned a few weeks ago that I had never tried a Twinkie, so Chris Lawless went to work correcting that state of affairs by bringing a box of Twinkies to their stand. You can see me trying my first Twinkie here!

I didn’t record me eating my second Twinkie. :)

From there is was a visit to the demo grounds again, then up to the OTN lounge to chat with a few people about the ACE Program, life the universe and everything. After a quick lunch with Vikki from the ACE Program, I hooked up with Steven Feuerstein to chat about his YesSQL initiative. Soon after that it was across to the ODTUG gathering briefly, before heading off to the SQL and PL/SQL Performance Panel, which featured Jagan Athreya, Dad (Graham Wood), Tom Kyte and Steven Feuerstein.

After popping back to the hotel to dump my bag, it was back down to Howard Street to the attend the evening festivities. I spent most of the evening with Doug Burns and one of his colleagues called Seamus. I even had a drink. Who’da think it?

Tiredness is still a big problem for me. The day is starting so early that I feel like the living dead most of the day.



Oracle OpenWorld 2014 : Tuesday was first posted on October 2, 2014 at 3:37 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Join me in a FREE live webcast about Real-Time Query!

On Thursday, 2nd October, 12:30 CET I will be doing a Live Webcast with many demonstrations about Data Guard Real-Time Query.

The shown features all work with 11g already.

Register here.

805-banner-dataguardrealtime-v1-2294812Addendum: The webcast was done already.

Tagged: Active Data Guard, Data Guard, OU Streams