Search

Top 60 Oracle Blogs

Recent comments

January 2014

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and flight expenses by preparing technical presentations of their most interesting and recent problems or projects. UKOUG and DOAG happen shortly after OpenWorld with a similar (but more European) impact – and December seems to mingle the domino effect of tweets and blog posts inspired by the conference social activity with holiday anticipation at work.

I avoided any conference trips this year but I still noticed the usual surge in interesting twitter and blog activity. It seems worthwhile to record a few highlights of the past two months as the year wraps up.

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and flight expenses by preparing technical presentations of their most interesting and recent problems or projects. UKOUG and DOAG happen shortly after OpenWorld with a similar (but more European) impact – and December seems to mingle the domino effect of tweets and blog posts inspired by the conference social activity with holiday anticipation at work.

I avoided any conference trips this year but I still noticed the usual surge in interesting twitter and blog activity. It seems worthwhile to record a few highlights of the past two months as the year wraps up.

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and flight expenses by preparing technical presentations of their most interesting and recent problems or projects. UKOUG and DOAG happen shortly after OpenWorld with a similar (but more European) impact – and December seems to mingle the domino effect of tweets and blog posts inspired by the conference social activity with holiday anticipation at work.

I avoided any conference trips this year but I still noticed the usual surge in interesting twitter and blog activity. It seems worthwhile to record a few highlights of the past two months as the year wraps up.

Public Speaking Tip 4 : Have a disaster recovery plan!

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. :)

Minimum Number of Recycling Server Processes

When I rebuilt my demo system (some while ago) with PeopleTools 8.52, I noticed a new message generated by ubbgen in PeopleTools 8.52 when the minimum number of recycling servers is set to 1.
#eeeeee; border: 0px solid #000000; font-family: courier new; font-size: 85%; overflow: auto; padding-left: 4px; padding-right: 4px; width: 95%;">WARNING: PSAPPSRV, PSSAMSRV, PSQRYSRV, PSQCKSRV, PSPPMSRV and PSANALYTICSRV are configured with Min instance set to 1. 
To avoid loss of service, configure Min instance to at least 2.

What Produces the Message?

Minimum Number of Recycling Server Processes

When I rebuilt my demo system (some while ago) with PeopleTools 8.52, I noticed a new message generated by ubbgen in PeopleTools 8.52 when the minimum number of recycling servers is set to 1.
#eeeeee; border: 0px solid #000000; font-family: courier new; font-size: 85%; overflow: auto; padding-left: 4px; padding-right: 4px; width: 95%;">WARNING: PSAPPSRV, PSSAMSRV, PSQRYSRV, PSQCKSRV, PSPPMSRV and PSANALYTICSRV are configured with Min instance set to 1. 
To avoid loss of service, configure Min instance to at least 2.

What Produces the Message?

The CTAS, a.k.a. Processing Data the Jetson’s Way

**Note-  This is an article I wrote about 4 years ago that, as far as I know, can only be found in hard copy and although I’ve changed my stance on statistics, etc. with 11g/12c, the main point of CTAS benefits still stands the test of time.  

NVL()

Here’s a point that’s probably fairly well-known, but worth repeating – nvl() and coalesce() aren’t identical in behaviour but you may have some cases where you’re using nvl() when coalesce() would be a more efficient option.

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

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.

Cheers

Tim…

Happy arbitrary day of the year!

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. :)