Skip navigation.

Tim Hall

Syndicate content
Oracle related rants (and lots of off-topic stuff)...
Updated: 43 min 19 sec ago

OUGN Vårseminar 2014

Tue, 2014-01-21 03:08

I’ve had some papers selected for the OUGN Vårseminar 2014 event in April, so I will be there representing OTN and the Oracle ACE Program. There is an impressive array of speakers lined up for this event already. Should be fun!

I’ve got a couple of months to practice my Captain Jack Sparrow impression. I wouldn’t want to look out of place on the boat!




OUGN Vårseminar 2014 was first posted on January 21, 2014 at 10:08 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.

OTN Yathra 2014 : See you there!

Sat, 2014-01-18 06:42

In November I wrote a post about my possible inclusion in the OTN Yathra 2014 tour. That has been confirmed now, so I’m representing OTN and the Oracle ACE Program at all the cities in the tour.

  • Jallandar – 18th February
  • Delhi - 20th February
  • Mumbai - 22nd February
  • Pune - 23rd February
  • Hyderabad - 25th February
  • Bangalore - 27th February
  • Chennai – 1st March

I’m a little bit scared by this trip. The OTN tours are good fun, but they are hard work. Doing seven conferences in 14 days seems like an awfully big task. I could have skipped some of the events to make my life easier, but that feels a little mean. At least when I get back from this tour I will have a week at work to rest before I go off to OUG Ireland:)

So now I’ve got to get my visa sorted out…



OTN Yathra 2014 : See you there! was first posted on January 18, 2014 at 1:42 pm.
©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.

OUG Ireland 2014 : I’m going to be there. Are you?

Sat, 2014-01-18 06:10

Earlier in the week I got confirmation I have two papers selected for OUG Ireland 2014.

  • PL/SQL : Stop Making The Same Performance Mistakes
  • An Oracle DBA’s Guide to WebLogic Server

You can see the full agenda here.

I got on the net to check flight prices and Ryanair were doing a round trip for £13. The booking fee on the travel site I used was more then the flight costs, so the total flight costs came to £30. :) Needless to say I booked them straight away, so I will be there representing OTN and the Oracle ACE Program.

In addition to presenting, myself and some of the other ninjas have been speaking with the conference organisers to get RAC Attack included in the event. That’s sorted now. At last count there were 6 RAC Attack Ninjas coming to the event, but others may be lurking around in stealth mode. :) If you are interested in RAC, come and speak to us. We are happy to help people do a full RAC installation on their laptop, but if you don’t want to commit that much time, you can just do part of the installation, like the Grid Infrastructure, and finish it off at home. A lot of people just want to come and ask questions about RAC. That’s fine too! :)

As if that wasn’t enough, there are Master Classes with Tom Kyte, Joel Goodman and Uwe Hesse!

Registration is now open, so get yourself sorted. See you there! :)



OUG Ireland 2014 : I’m going to be there. Are you? was first posted on January 18, 2014 at 1:10 pm.
©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.


Fri, 2014-01-17 08:50

The recent public speaking posts have made me very aware of other people’s behaviour at the moment. I’m sure I will soon revert back to my self-obsessed state, but for now I’m riding this wave. :) Something happened a few days ago that I thought was very interesting…

I took my 12 year old nephew to a local store so he could buy something. We both waited in the queue, him holding the items. He walked up to the counter, placed the items down and stood, money in hand, waiting for the items to be passed through the checkout. The checkout lady looked at me and said, “Do you want a bag?”. I tilted my head towards my nephew in a “why don’t you ask him?” manner, which she ignored, so I conceded and said to my nephew, “Do you think we need one?”

When we left the shop I chatted with my nephew about the encounter. In this situation, it’s not unnatural for people to direct their attention to the adult, but I suggested a slight modification of his behaviour could have altered this. If he had walked up to the counter and said, “Hello. Just these please?”, or something to the same effect, I’m sure she would have seen him talking ownership of the situation and would have directed her question to him. I can’t guarantee it, but I think it is very likely.

It’s kind-of like that fake it until you become it thing I mentioned in a previous post. If he had asserted himself early in the interaction, the outcome might have been different. It makes you wonder how many interactions you have on a daily basis that you blindly float through on autopilot and what impact they would have on your life if you paid more attention…



PS. I’ll stop with this hippy stuff soon and get back to book and movie reviews. :)

Interactions was first posted on January 17, 2014 at 3:50 pm.
©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.

Public Speaking Tips

Mon, 2014-01-13 02:48

I figured this would be a series of 5 posts max and it ended up being two weeks of daily posts. :)

Here is the list of posts:

  1. Do some public speaking!
  2. Rehearse!
  3. Pick a subject you are interested in!
  4. Have a disaster recovery plan!
  5. Deliver what you say you will!
  6. How to handle questions (crowd control)
  7. Live demonstrations
  8. You can’t please all the people all the time!
  9. Feedback helps you improve!
  10. Watch other speakers!
  11. International presentations
  12. Why Bother?
  13. Understand your motivation for speaking
  14. What do I present? (the pursuit of cool)

The reaction to this stuff has been really interesting. I’m glad people enjoyed it. For easy reference, I will add a link to this post on the toolbar at the side of the blog.

This post concludes the series, but if I think of anything else, I will certainly post it and add it to this list. If anyone has suggestions for posts on related subjects I may not have considered, I would gladly voice my opinion on them and add them to the list also.



Public Speaking Tips was first posted on January 13, 2014 at 9:48 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.

Public Speaking Tip 14 : What do I present? (the pursuit of cool)

Sun, 2014-01-12 11:02

Deciding what to speak about is one of the most difficult things to do. I still struggle with it now, but this last year has been a turning point for me. I’ve already said you should present about something you are interested in, but what?

It is very easy to fall into the trap of “the pursuit of cool”. You quite fancy doing a presentation on subject X, but think it’s not new or cool enough. The pursuit of cool also makes you question how your choice will be perceived by others, because you are trying to impress specific people or groups of people. If you feel yourself falling into the trap of the pursuit of cool, just remember the following:

  • The vast majority of the time DBAs and developers are doing rather mundane work. As a result, they are looking for ways to be more time efficient while doing those mundane tasks. I remember a few years back sitting in a room at OpenWorld with about 600 other people. What subject had we all gone to listen to? It wasn’t RAC or Exadata. It wasn’t even Data Guard. It was Data Pump! That’s right. Import and export pulled a crowd of that size!
  • A lot of people out there still use Oracle 11g like it’s Oracle 7 or 8i. It never ceases to surprise me how you can mention a feature that was introduced in Oracle 8i and people ask if it is a new feature in 11g. As long as the material is new and relevant to the audience, it doesn’t matter what version it is from.
  • For many people, it will be their first time at a conference and the first time they have seen a presentation on that subject. I spoke to Debra Lilley a couple of years ago and she said 40% of the attendees at the UKOUG conference each year are first-timers. So that’s nearly half the audience who will find your material new.
  • Each year a bunch of people retire or move up the management food chain and a bunch of new DBAs and developers join the ranks. Fresh meat for the grinder. :) They’ve got to go through the process of learning all that stuff you take for granted. It sometimes feels like “groundhog day”, but that’s how our industry works.
  • Just because someone has got 20 years of experience, it doesn’t mean they have experience of feature X. If someone asked me to do some work on Oracle Spatial, I would probably rock up to a few “Oracle Spatial for Dummies” sessions to get me going. :)
  • Depending on the type of event, there may be non-technical folks in the audience who are just looking for an overview of the subject. This is very true of marketing events, like OpenWorld.
  • Just because a subject has been done in previous years, doesn’t mean you should avoid it. Sometimes a fresh perspective is helpful. I’ve resisted doing talks on Analytic Functions for years because they’ve been around since Oracle 8i and I’ve seen some great talks on them by others, including Alex Nuiten. This year I thought to hell with it and started doing a session on them and it has worked out really well. It’s the same subject, but my take on it is a little different…

The delays to the release of Oracle 12c actually did me a favour this year. If it had been released earlier, I would probably have spent the year battling it out with others to fill the slots for “What’s new in Oracle 12c for X?” type sessions. Because I couldn’t do that, I took inspiration from the presentations I had been doing at work and took a step back. Nearly all of my presentations this year have had a “retro” feel for me, but they have been received really well. Why? Because the information was either new to the audience in question, framed it in a manner they had never seen before, or it reminded them of things they had known, but forgotten. :)

If in doubt, remember this mantra,

Presenting is not about you, it’s about the audience! Don’t get caught up in the pursuit of cool!



Update: I’d just like people to remember this is my personal take on things. It is not some political statement about conferences. :)

Public Speaking Tip 14 : What do I present? (the pursuit of cool) was first posted on January 12, 2014 at 6:02 pm.
©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.

Public Speaking Tip 13 : Understand your motivation for speaking

Sat, 2014-01-11 02:54

In yesterday’s post I talked about what I believe is the most important reason for public speaking, but different people have different motivation and I think it’s good for you to understand what you want to get out of the experience, as it might affect how you approach the journey.

Profile (fame)

Speaking at conferences will certainly increase your visibility in the conference-going community, but I think you’ve got to be realistic about what that means. Let’s say you go to UKOUG and present to 50 people, the rest of the 1000 people at the conference don’t have a clue who you are. The internet will not suddenly be set alight with news of your presentation, unless it is really amazing or really bad. The conference going community is a small fraction of the people out there that use Oracle. If your main motivation is fame, at best you will make yourself a big fish in a very small pond.

When Alex Gorbachev spoke about Pythian‘s attitude to their staff speaking at conferences, the emphasis was very much on keeping the staff happy, more than the leads it generates for the company. Having spoken to people over the years, I think the relationship between conference speaking and work opportunities is drastically over-hyped.

Of course, if building “your brand” is something you aspire too, conferences are one aspect of that, but don’t expect to do one presentation and have the world throwing opportunities your way.

Work opportunities

I’ve already started that conversation in the previous section, but let’s continue… So I’ve said I don’t think speaking at conferences is directly going to help you, but indirectly is a different matter. Adding information about conference presentations on your resume sends a message to employers. Regardless of how good or bad you were, it says to me this person is willing to stand up in front of a crowd of people and try to knowledge spread. It indicates a level of enthusiasm beyond just wanting a pay cheque. That would interest me as an employer.

Once again, I think you have to be careful about what you expect from this. I don’t think I’ve ever been employed because I am “Tim Hall”. Most places don’t have a clue I am the guy that does “that website” until after I’ve started working for them. I guess some people play on their profile a lot more, but for me I quite like keeping work and community separate from each other.

You don’t understand something until you can teach it

Interestingly, in the UK we also have the saying, “Those that can, do. Those that can’t, teach” :)

Seriously though, we work in a copy & paste industry these days. The vast majority of people don’t have the time, energy or motivation to study beyond getting the job done. Being selected to present at a conference is an extremely good motivator for hitting the books. I know some people actively pick subjects they are not overly familiar with as a learning experience. I’m not brave enough for that. The closest I’ve come is this year’s newbie guide to WebLogic stuff. :)

In addition to what you learn during the process of writing and rehearsing your talks, you also learn a lot when people ask you questions. You are effectively combining their experience with your own.


Birds of a feather flock together. You will spend more time at conferences with attendees and the other speakers, giving you the inside track on loads of great information you will not be able to get directly from the manuals. Networking is a great motivator for me.

I guess if you are of that mindset, you can turn this network to your advantage when job-hunting, but as I’ve said, that’s not really my thing…

Giving something back

If you’ve benefited from the community over the years, maybe you should consider giving something back. Presenting is one of the ways you can do that. The folks you see speaking at conferences now will not be around forever…

Remember, your motivation does not have to be the same as mine. The fact that yours is different to mine does not make me right and you wrong. Decide what it is you want to get out of the experience and focus on how best to achieve that. If you are like me and just in it for the ride, just keep saying yes to opportunities and see where it takes you… :)



Public Speaking Tip 13 : Understand your motivation for speaking was first posted on January 11, 2014 at 9:54 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.

Public Speaking Tip 12 : Why Bother?

Fri, 2014-01-10 05:23

In some ways, this should have been the first post in the series, since there are probably a number of people out there who don’t care about speaking at conferences. In my opinion everyone should try their hand at public speaking, because it gives you numerous transferable skills.

I guess a number of people in the Oracle community who know me will laugh at this following statement, but I am naturally a shy person and although I like to talk to people on a one-to-one basis, speaking in groups is not natural for me. I always hated having to read things out loud in class. If I was asked to introduce myself in a meeting, I would get that “butterflies in the stomach” feeling and have a bit of a panic. There are two ways you can react to this. You can avoid putting yourself in those situations, or you can confront your fear and go for it. I chose the latter.

This isn’t just about being able to speak at conferences. It has a knock-on effect on your life generally. There are a few situations that spring to mind that could dramatically alter the course of your life.

  • Job interviews : Having a job interview is pretty scary for most people. If you’ve stood in front of a few hundred people at a conference, sitting in front of a hand full of people in a job interview is a breeze.
  • Meetings : How often have you wanted to say something in a meeting to influence a decision, but you’ve kept quiet because you are nervous of drawing attention to yourself? If you’ve put yourself on the line in front of a room full of strangers, commenting in a meeting is nothing in comparision.
  • Relationships : Confidence is an attractive quality in others. Lack of confidence is percieved as a weakness. Anything that increases your confidence will improve your interactions with other people. Unless you are a hermit, everything in life ultimately comes down to your relationships with those around you.

You don’t have to be a naturally confident person to be a good public speaker. Amy Cuddy has a great TED talk called Your body language shapes who you are. You might also see it listed as “power posing”. During the talk she talks about, “fake it until you make it”, and more importantly, “fake it until you become it”. I’ve certainly seen evidence of the latter in myself over my years of presenting. I am definitely not the person I was…

As I said at the start of this post, I think everyone should try public speaking. I’m not saying you have to make it your life’s mission, but you owe it to yourself to at least try it out and see how it affects you.



Public Speaking Tip 12 : Why Bother? was first posted on January 10, 2014 at 12:23 pm.
©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.

Public Speaking Tip 11 : International presentations

Thu, 2014-01-09 15:05

As a native English speaker, life is pretty easy for me when presenting around the world. Oracle is an American company, so people are used to having to deal with English speaking presenters. Either the audience speak English already, or the events and audience expect to use a translation service. Even so, I often joke that when I’m presenting in other countries I’m still having to translate what I say on the fly, because my everyday language is not really suitable for an international audience. :) In this post I’ll look at some of the things you need to look out for when speaking in other countries. Some will be equally relevant to other English speaking nations.

Volume of information and speed of presentation

When presenting to an audience in their second (or third) language, you have to present less content and present that content more slowly. There is no point launching into things full steam ahead if some of the content is going to get lost. The volume of content and the speed is really dependent on the audience. If you speak to people before the session starts you will get a feel for how fast is two fast. Also, do some homework before you go. Speak to other presenters who have presented at that event before. Ask the organisers of the event for some advice.

Visual feedback from the audience

I recently did a post where I mentioned the visual feedback you get from the audience and how you can misinterpret it. This is especially true when you present in different countries. Different countries have different body language. The first time you speak to a Bulgarian and they shake their head for “yes” and nod for “no” it will mess with your mind. :)

Cultural differences can be a big deal too. In some countries they wouldn’t dream of contradicting a presenter (or teacher), even if they knew them to be wrong.

In addition, presenting to people in their second language can affect their body language. When concentrating, some people get a really serious expression on their face. Some look positively angry. Others take on a really vacant look. If people are concentrating on learning some new information and on top of that they are having to deal with a language barrier, you can’t expect “normal” body language from them.


Many people can understand English well, but struggle, or are embarrassed, to speak it. Don’t be surprised if your Q&A at the end of your session gets no questions. Often, people will then walk up to you and say things like, “I’m sorry, my English is really bad, but I have a question…” Invariably their English is fine and certainly better than me trying to speak their language. :)

Don’t put the audience on the spot and wait, or demand, answers to your questions. It’s just going to freak people out.


You know those words or phrases you use in your country, city or group of friends? The rest of the world doesn’t know them! Try to avoid them as much as possible, unless you are going to explain them. I remember sitting in a bar with a group of people at OpenWorld and Doug Burns said to me, “Do you think anyone here except for me knows what that word means?” :) It can be really hard to get out of the habit of using them, but you have to try.


For some people, like me, swearing is a normal part of the language. I have to constantly (try to) censor myself in everyday life. I’ve got much better since my nephews came along and I’ve always been well behaved at conferences. :) Short answer. Don’t swear in your talks.

Being self-deprecating

You’ve got to be really careful with this. In regular life I’m quite self-deprecating, but when I’m presenting I try to avoid it. I remember discussing this with Mark Rittman at my first OpenWorld, who is also self-deprecating. This is the kind of situation we were talking about.

  • You: “So that’s what you should do, but don’t trust me, what do I know? Ha ha ha”
  • Attendee: “But I thought you were meant to be the expert?”

It’s probably better to assume that everything you say will be taken literally, unless you really spell it out to people.

Live translation

Wow. This really freaked me out the first time I used it. When half of the audience are getting the information via a headset you end up getting a delayed response to everything you say. Sometimes they laugh when you don’t expect it, which makes you wonder what the translator has said. If you get a chance, spend some time with the translator and run through your slides with them. The more they know about what is coming, the better job they will do.

You may well have to listen to questions through a translation service also. That doesn’t feel at all normal the first time you do it!

I’ve found presenting internationally to be one of the most rewarding things over the years. People are so pleased you’ve made the effort to come to see them. It’s a really good experience and I would recommend it to everyone. In my case, I certainly feel a lot more like a citizen of the world because of it, which sounds a bit pretentious, but it’s true. The more places I go, the more I think about this quote.

“There’s a billion places like home. But only one of ‘em’s where you live.”
Granny Weatherwax (Witches Abroad, Terry Pratchett)



Public Speaking Tip 11 : International presentations was first posted on January 9, 2014 at 10:05 pm.
©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 Midlands #1 : My first presentation of the year done

Wed, 2014-01-08 03:25

I wrote a post in November about an Oracle Midlands group Mike McKay-Dirden was setting up, modelled on the free meetups he’s experienced with the SQL Server community. Last night was the first event, with myself and Pete Finnigan speaking.

Being a Midlands-based event, and me having worked mostly in the Midlands, I’d say about 50% of the people in the audience were people I had either worked with directly, or people who work with people I had worked with directly. That included one guy who I worked with in my first job, who started there on the same day as me. :) It was really cool to meet up with everyone. I hope to see them all at future events.

I felt quite nervous on the lead up to this event. I think part of that was because I’ve been writing tips about public speaking and felt almost like I’ve been setting myself up for a fall, imagining people comparing what I say to what I do. :) One of my former colleagues commented on how nervous I seemed at the start. :) Once I got going things seemed to snap into place, so I think it went fine. :) I spent the break between chatting and answering questions.

Next up was Pete. I’ve seen Pete present a half-day session in the past, so I knew the sort of thing to expect. I think I’m pretty good at security compared to most people, but I know I’m a rank amateur compared to Pete. I’ve said it before and I’ll say it again, I think it should be mandatory for people to sit in one of Pete’s sessions on a regular basis, just to keep reminding them how little they know and how complicated doing security properly really is. I really enjoyed his session and feel like I learned some more stuff. I’m also very scared now… :)

Big thanks to Mike for setting up the event and inviting me to speak. Big thanks go out to Red Gate Software sponsoring the event, allowing this to be a free event. Thanks also to for providing a raffle prize. Of course, thanks to everyone who came to the event, especially Nikolay Manchev and Salih Oztop, who travelled up from London to come to the event. :) Without support of the attendees, this sort of thing can’t happen. If you want it to keep happening, you need to keep coming. :)

The next event should be around late February. I won’t be speaking at that event, but I plan to be there. I’ll post again when the dates and agenda are fixed.



Oracle Midlands #1 : My first presentation of the year done was first posted on January 8, 2014 at 10:25 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.

Public Speaking Tip 10 : Watch other speakers!

Wed, 2014-01-08 01:05

A really good way of improving your presentation skills is to watch other speakers. I will often go to sessions by people who I know to be good speakers, just to watch their technique. It’s actually easier if it is a session you’ve seen before, or on a subject you don’t have much interest in, so you can focus on the presentation skills, not the content. :) There are a few speakers I try to get to see at every conference, having seen the same presentation several times for this very reason.

This is not about being a fanboy (it is really :) ), or trying to emulate that person. It’s about trying to identify aspects of their presentation style that could work for you. Ultimately, you are trying to develop your own style, but that doesn’t mean you have to ignore what is going on around you. The same way you will look to others for advice, you should watch their presentations to see which aspects of their style could be of benefit to you. Things like stage presence and crowd control come naturally to some people, but they can be learned. Check out how other people do live demonstrations to see how they cope with transitions between the slides and the demos.

There is always something to learn from watching other speakers, even if it is what not to do. :)



Public Speaking Tip 10 : Watch other speakers! was first posted on January 8, 2014 at 8:05 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.

Public Speaking Tip 9 : Feedback helps you improve!

Tue, 2014-01-07 02:55

In yesterday’s post I was kind-of dismissive of feedback, in so far as not letting it ruin your performance on the day. Once the sessions is over, that is the time to reflect on your performance and start looking for feedback. Feedback and advice from others is the best way to decide what you need to work on to improve.

Many conferences ask their attendees to fill in speaker evaluations and make the results available to speakers. The actual marks don’t always tell you too much, but the written comments can be very interesting. They tend to focus on extremes, people who either love or hate you. Even so, it’s worth checking this stuff out to see if there is something obvious you need to work on.

The questions you are asked in your session can tell you a lot about how your session went. Often, they will highlight areas you need to revise in the presentation itself, so you can pre-empt those questions next time.

If your sessions have been recorded, watch the recordings and be your own critic. I hate seeing myself on video, but it is a very good way to spot issues!

By far, the most useful feedback for me over the years has been the feedback and advice from other speakers. I mentioned in a previous post, I started asking for advice before I even stepped up on stage. During my first full-blown conference presentations, for AUSOUG in Australia, I got great feedback and advice from Chris Muir and Connor McDonald, which really helped me development my style. Since then I’ve been keen to pick up as much advice from others as possible. I still feel very much like a newbie at all this, so getting to speak to people who have been in the game for years is very valuable. Listening to their “war stories” is a great way to stop you falling into the same traps they did.

Feedback and advice is the quickest way for you to grow as a presenter. Don’t take it personally. Learn by your mistakes and the mistakes of others and aim to continually improve.



Public Speaking Tip 9 : Feedback helps you improve! was first posted on January 7, 2014 at 9:55 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.

Public Speaking Tip 8 : You can’t please all the people all the time!

Mon, 2014-01-06 02:58

Provided your title and abstract accurately describe what you are presenting (see deliver what you say you will), you’ve got to trust the audience have made the right choice to come to your talk. Frits Hoogland made this comment on that previous post.

“It works the other way around too… Got a comment on a deep dive presentation saying ‘stuff way over my head’…”

This was my response to Frits.

“You did what you said you would. They picked the wrong session. Not your fault!”

If you describe a session as a “deep dive” and a newbie comes to it, they can’t complain about it being to complicated. If you describe a session as an introduction, experts can’t complain that it didn’t go into enough depth.

When you first start presenting, the visual feedback (body language) of the audience can have a dramatic impact on your confidence. Invariably, you will notice those people that look bored or disgruntled and you will focus on them. You will notice that guy sleeping in the front row and see it as evidence that you are the most boring person alive. It takes a while before you have enough confidence to see the audience response for what it is.

I’m not saying you should ignore this negative feedback, but you have to try and put that feedback into context. If you expect to have everyone leave the room saying you were awesome, you are going to be very disappointed, but don’t let one or two people bring you down, when the majority of the room was filled with happy people.

There are definitely cultural differences that affect the interaction with the audience. The more international presentations you do, the more you will notice this. I’ve got a specific post on this coming, so I won’t say too much about this now. :)

Another thing to remember is, you are not necessarily reading the visual feedback correctly. I’ve done sessions that I thought were going badly that got excellent evaluations. The trick is, once you get on the stage and start, do the best you can and deal with the feedback once it’s over. Don’t let what is going on in the room affect you mid-flow. There will be plenty of time after the session for analysis. :) Use the visual, verbal and written feedback, like speaker evaluations and comments on social media, as part of your learning experience.

I’ll conclude with this great quote Connor McDonald left on one of my previous posts.

“No matter how you do (spectacularly well or spectacular fail), the thing that will amaze you at the end of it will be ….. ‘Hey, I’m still alive’”



Public Speaking Tip 8 : You can’t please all the people all the time! was first posted on January 6, 2014 at 9:58 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.

Public Speaking Tip 7 : Live demonstrations

Sun, 2014-01-05 05:43

Live demonstrations are something I’ve done from day 1. It wasn’t so much a decision I made, it just seemed the right thing to do. Does that mean that you should use live demos too? As Tom Kyte always tells us, the answer is “it depends”. :) If I am honest, my desire to demo things comes from my own insecurities. If I don’t show it, I feel like I’m a liar. Is that the right motivation for doing a demo? Hell no! Here are a few thoughts about live demonstrations.

You can demo too much!

It takes some time to see where demos are adding benefit and where they are just bloat. You will also redevelop your style of demoing over time. When I first did my Clonedb talk I demoed everything. I did all the setup, ran a backup and did the actual clone. That’s fine, but do people really want to see me (mis)type a bunch of commands and edit config files live on stage? I think it’s safe to say they are capable of following a recipe in my article if they want to. What really has some impact is when they see you clone a database in 2 minutes, regardless of size. You look out into the audience and see the proverbial light bulb come on. Demos are nice, but don’t overdo it. Identify the things that will have maximum impact, for minimum time waste. (Note to self: Listen to your own advice once in a while! You need to work on this!!)

Live demos go wrong!

I would not recommend doing live demos when you first start. Why? Because they go wrong. You accidentally screw things up, the demo doesn’t work as you expected or your laptop dies and you can’t run your demos on someone else’s laptop. When demos work well they are great. When they fail they can totally ruin a presentation. As I mentioned in a previous post, you need a disaster recovery plan. I would suggest in many cases, if the demo does not work instantly, laugh it off and move on. Trying to fix or rerun it often ends up being a complete time waster.

Of course, you should try to make demos as robust and re-runnable as possible!

Are video demos a better option?

In many ways I think video demos are superior to live demos. For a start, they work properly every time. :) More importantly, there are some things it’s really difficult to demo on a laptop. You will see a number of presenters rocking up with super-duper laptops, so they can run RAC and Cloud Control in their demo. That is a serious investment in kit for the handful of times you need it. It’s far better to run the demo on some real kit at home or at work, record it and play that to the audience. It also allows you to do things like zoom in to specific parts of the screen or add notes for additional clarity.

But I can run my demo on AWS or from my office can’t I? Only if you have a suitable internet connection. Not all venues provide this and not all venues have great mobile reception. I would not rely on this!

What size/quality of screen are you using?

You don’t know what sort of screens you are going to get until you get there. I’ve worked with everything from giant auditorium screens to projectors not much bigger than a large TV. Most will show slides OK, but many will look terrible if you try to show code or IDEs, unless you can zoom in. I would go as far as to say, demoing an IDE (SQL Developer, JDeveloper etc.) without a zoom function is a fail.

Some projectors really can’t handle switching between slides and other apps. Some of my demos involve me switching between Powerpoint, a text editor and a terminal session. When there is a 10 second lag each time you make that switch it is a real ball-ache. You really need to consider how you are going to handle this type of situation. Maybe that will involved switching to your backup plan…

Do people like demos?

Some do. Some don’t. In my speaker evaluations I’ve had responses from both camps for the same presentation. Literally one comment saying, I loved the fact he demoed everything and another saying it was demo overload. You can’t please all the people all the time. I’ll talk about that in another tip. :)


I could carry on talking about this subject, but the post is getting rather large already. :) So do you demo or not? Do what feels right to you, but keep in mind that it must not break the flow of your presentation. Remember, maximum impact for minimum time waste.



Public Speaking Tip 7 : Live demonstrations was first posted on January 5, 2014 at 12:43 pm.
©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.

WPtouch Mobile Plugin

Sat, 2014-01-04 05:32

A big shout out goes to Amardeep Sidhu, who pointed me to WPtouch to me recently. Install and activate this plugin and your WordPress blog is mobile aware, presenting a trimmed down view on mobile devices.

It really is that simple. No messing involved. If you have a WordPress blog, you may want to have a play with this plugin.



WPtouch Mobile Plugin was first posted on January 4, 2014 at 12:32 pm.
©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.

Public Speaking Tip 6 : How to handle questions (crowd control)

Sat, 2014-01-04 03:24

Handling questions was certainly one of the things I most feared when I started speaking at conferences. If there is one thing you take away from this post, it should be this.

“Never bullshit!”

Here’s a comment Jonathan Lewis left on my first post in this series.

“I think a very important thing to believe before anything else is that it’s perfectly acceptable to say “I don’t know” or “I’m not sure” if someone asks a question you can’t answer immediately.”

It sounds so simple, but it takes a surprising degree of confidence to say this when you are in front of an audience.

Here are some general thoughts on handling questions and basic crowd control.

  • If you are nervous and think questions will throw you off your stride, ask at the start if people can keep their questions until the end.
  • Sometimes you explain a topic in layers, adding information piece-by-piece. If someone in the audience wants to ask a question part way through that process, suggest they wait until you’ve finished that section, in case the upcoming material already answers their question.
  • Always repeat the question back to the audience (I’m crap at remembering to do this). This serves a number of purposes. It’s a good check that you have understood the question. It allows the rest of the audience to hear the question, before you answer it. It gives you time to think. :)
  • Educated guesses can be OK, provided they are presented as such. For example, you might say something like, “I don’t know the answer to that, but I know that X and Y, which would make me think the answer is probably Z, but it’s a guess and I would have to test that to be sure.” Of course, it depends on the specific question and the “supporting evidence” for your guess.
  • If someone asks a completely off-topic question, ask them to come and speak to you at the end of the session. I say something like, “That’s a bit beyond the scope of this session. Come and see me at the end and we can talk about it.”
  • If you are struggling to understand a question, say so and ask them to come and speak to you at the end of the session. Don’t waste everyone’s time trying to fathom it out.
  • If a question requires an answer that will take a significant amount of time to put across, say so and ask them to speak to you at the end of the session.
  • Use the questions you are asked to help refine your presentation, so they don’t need to be asked next time.

The reaction to the question and answer slot at the end of a session seems to split the audience into three distinct sections.

  1. The people who hate Q&A. You can see them itching to leave. Some just get up and walk out, which is fine.
  2. The people who love Q&A. They would happily keep you talking for the rest of the day. I’ve actually done sessions where I’ve spent longer answering questions after the session was over, than the session itself. I love speaking to people about this stuff, so I’m happy to do this.
  3. The people who don’t care. They’ll just carry on reading their email until the Q&A is over. :)

With that in mind, you have to exercise a little crowd control. I would suggest you draw the session to a close, which allows people to leave, but suggest if anyone wants to stay for a Q&A, that’s fine. When you are in other people’s sessions, check out how they manage questions. You will often pick up new ideas this way.



Public Speaking Tip 6 : How to handle questions (crowd control) was first posted on January 4, 2014 at 10:24 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.

Public Speaking Tip 5 : Deliver what you say you will!

Fri, 2014-01-03 01:54

Go to a conference and I can guarantee you will hear people complaining about sessions they sat through that bare no resemblance to the title or the abstract.

It’s not easy to come up with an eye catching title and abstract, but don’t fall into the trap of trying too hard, then failing to deliver on the day. It’s better that you are honest and don’t get selected, than promise people an enlightening experience and fall short.

The vast majority of the problems are not so much the topic, but the depth of the material. If you start calling something a “deep dive” or mention “internals”, you better have something a bit more hardcore than a few sentences out of the manual. There are plenty of people out there who can melt your brain when they talk about Oracle, and I’m not just thinking about the famous names who get on stage. There are a lot of really bright people who you will never see on stage and you will never know their names. Don’t short-change those people by promising something, then not delivering.

The opposite is true also. If you include words like “introduction” or “overview”, then you can’t start hitting people with in-depth analysis. The people that come to an introductory session will get nothing out of watching you prove how cool you are.

Remember, getting a room full of people who leave disappointed is far worse than getting a handful of people who really enjoy the session!

If in doubt, ask a few colleagues to help you rate the level of your content.




Public Speaking Tip 5 : Deliver what you say you will! was first posted on January 3, 2014 at 8:54 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.

Public Speaking Tip 4 : Have a disaster recovery plan!

Thu, 2014-01-02 05:13

My first presentation for UKOUG was at a Special Interest Group (SIG). I was invited to speak by Andrew Clarke, who at the time was the chairman of that SIG. I admitted I was a complete newbie and asked for some advice. Being a seasoned speaker, he gave me lots of good advice, but one of main things he told me was to have a disaster recovery plan. As it turns out, that was one of the best bits of advice I could have received so early in the game. Andrew is a really nice bloke and a great speaker. When I met him again at this years UKOUG event in Manchester I asked if I could take a picture with him, because I’m such a fanboy. :)


Presenting can be a nerve-racking experience. Even when you have a backup plan, when something goes wrong you still feel like a bit of you has died. Without a backup plan, it would feel like a world ender. :) Just like in your job, disaster recovery is about dealing with the unexpected. It gives you one less thing to worry about. I’ll illustrate why it is important with a few examples of things that have happened to me over the years.

  • At an ORCAN conference in 2009 I was sitting in the session before mine, so I tried to start the VM I use for demos and it wouldn’t start. I use a lot of demos, so life was not going to be fun. Fortunately I had a backup of the VM, so I overwrote the VM and it started fine. A quick run through some of the demos and life was good. I got finished with the recovery about 5 minutes before my session started.
  • At an OUGF conference in 2009 my laptop died, so I had to present on someone else’s. I was not able to run any demos, but I had a text representation of the expected output for each demo, so I could at least talk through something when presenting off a memory stick.
  • At UKOUG 2011, I screwed up my demo VM before presenting about Clonedb, so I had to use my article to show what should have happened. That talk was described by someone on Twitter as “a mess“, so the backup plan was not all it should have been. :)
  • At the Montevideo, Uruguay leg of the OTN Latin America Tour last year I accidentally dropped all the tables in the SCOTT schema as I started my demo. I couldn’t remember the name of the script to recreate SCOTT (utlsampl.sql), panic does that to you sometimes, so I presented the examples using the article I had written that goes along with the presentation.

Notice how all my major disasters have been about demos being screwed. Having live demos is a nice thing, but not without its risks. :)

So for peace of mind, you really need to consider what you are going to do if things go wrong.

  • Keep a copy of your presentation on a memory stick.
  • Keep a copy of your presentation somewhere you can download it, just in case.
  • If you have demonstrations, have some way of replacing them if they are not working for some reason. Text output, screen shots or even better video capture of the demos is a great idea.

If you are lucky, you will never need them. If you are unlucky, you will be glad you made the effort!



Public Speaking Tip 4 : Have a disaster recovery plan! was first posted on January 2, 2014 at 12:13 pm.
©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.

Public Speaking Tip 3 : Pick a subject you are interested in!

Wed, 2014-01-01 05:01

Your presentation should be on a subject you have a genuine interest in. There will be a number of these tips that relate back to picking your subject for a presentation, but for now I will focus on this specific aspect.

Enthusiasm goes a very long way when you are presenting. When you are genuinely interested in a subject it draws people in. It is very hard to “appear” enthusiastic about something you have no interest in! It is even harder to maintain enthusiasm when you are presenting the same session multiple times. There has to be something there that gives you that spark, which the others around you can feed off.

When I look around at all the great speakers I’ve met and tried to learn from, they are all really into their subject. They are all speaking about something they feel passionate about. To do anything less than that is cheating yourself and the audience.



Public Speaking Tip 3 : Pick a subject you are interested in! was first posted on January 1, 2014 at 12:01 pm.
©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.

Happy arbitrary day of the year!

Wed, 2014-01-01 04:30

If you take a step back and think about it, it’s funny how we attach such significance to a day of the year. :)

For myself, I hope during this year I can put in the effort to achieve the things I want to achieve, rather than just sitting back and day dreaming about what it would be like for them to fall into my lap. I guess to some that sounds kind of funny, but I look around at this time of year and I see many people living in a rather delusional state. Those new years resolutions, that will last about 30 seconds when you see your first piece of cake. :)

So my wish for the world this year is that everyone takes personal responsibility for their own sh*t and gets on with it! Pick a few things you would like to achieve this year and work hard at them!

Happy new year folks.



Happy arbitrary day of the year! was first posted on January 1, 2014 at 11:30 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.