Oracle Observations

October 9, 2012

Possibly useful information for attendees of UKOUG TEBS 2012. (And Oracle Beer!)

Filed under: Uncategorized — bigdaveroberts @ 4:14 pm

Venue Plans.

When I first attended UKOUG, I did struggle to find my way to some of the halls, especially with regard the fact that some routes have been closed off.

So if this is the first time you are attending you might want to look at the new floor plans on the ICC website located here:



If you are going to park on the street at any time during the conference, note that new zones are now in operation since last year.

The map of the new zones is here:

But in short, some of the roads closest to the ICC now require a ticket on all days (including Sundays) between the hours of 8am to 7:30pm.


While All Bar One and Pitcher and piano in Brindley place ( provide convenient locations for acquiring beer may I suggest that the more adventurous try:


Which actually serves:


Baas? Beer as a service?


UKOUG TEBS conference 2012 agenda (Wednesday).

Filed under: Uncategorized — bigdaveroberts @ 4:10 pm

09:00 – 09:45 David Peake – Oracle Co-presenter(s): Anthony Rayner – Oracle

Application Express Roundtable

10:00 – 10:45 Simon Haslam, Oracle ACE Director – Veriton Limited

Application Server & Middleware Round Table

11:15 – 12:00 Tony Hasler – Anvil Computer Services

The MODEL clause explained

12:10 – 13:10 Joze Senegacnik, Oracle ACE Director – DbProf d.o.o.

PGA Memory Management Revisited

13:55 – 14:55 Maria Colgan – Oracle

Exadata and the Oracle Optimizer: The Untold Story

15:15 – 16:00 Tanel Poder, Oracle ACE Director – Enkitec

Troubleshooting the Most Complex Performance Issues I’ve seen

UKOUG TEBS conference 2012 agenda (Tuesday).

Filed under: Uncategorized — bigdaveroberts @ 3:18 pm

 09:00 – 09:45 Andrew Clarke – Logica

Development Tools Roundtable

On the other hand this session sounds mischievous and potentially entertaining:

09:00 – 09:45 Jonathan Lewis, Oracle ACE Director – JL Computer Consultancy

Are You Sure You Need Exadata?

09:55 – 10:55 Maria Colgan – Oracle

Oracle Optimizer: Harnessing The Power Of Optimizer Hints

11:15 – 12:00 Graham Wood – Oracle

A Deep Dive Into the SQL Monitor Report

12:10 – 13:10 Kerry Osborne, Oracle ACE Director – Enkitec

Controlling Execution Plans (Without Touching the Code)

13:55 – 14:40 Tom Kyte – Oracle

5 SQL and PL/SQL Things in the Latest Generation of Database Technology

15:10 – 15:55 Peter Finnigan –

Oracle Security Round Table

16:20 – 17:05 Alex De Vergori – Betfair

Extreme Online Transaction Processing Using Oracle PL/SQL

17:15 – 18:00 Tom Kyte – Oracle

What’s New in Oracle Database Application Development

October 3, 2012

UKOUG TEBS conference 2012 agenda.

Filed under: Uncategorized — bigdaveroberts @ 3:58 pm

With the arrival of the online agenda, comes the difficult task of planning my conference.

This year is more difficult than most as I’m changing jobs between now and the conference, this means that I may have new imperatives thrust upon me in the next few weeks that might change my priorities.

There are also suggestions on the internet that sessions hinting at latest oracle technologies might be referring to Oracle version 12c! Obviously if that is true that might again change my priorities.

Last year the OAK table Sunday sessions mostly duplicated other sessions, allowing flexibility with 2 bites of the cherry at some of the best sessions.

Finally in the past, I have had the strong expectation that the most popular sessions will also be repeated at SIGs meetings so that I don’t need to attend them at the UKOUG conference. In fact I suspect that many people use SIGs as practice runs for the conference, a practice that seems to be unfortunately in decline.

So to my goals and methods.

I have been a developer and a DBA, in general I have a bias towards DBA technology sessions as I tend to believe that they are beneficial to both disciplines.

I do have a bias towards roundtables, obviously there are no roundtable slides to download and if you don’t attend then you will gain zero benefit from them. However in some areas Round tables often seem to replicate themselves from previous years. For example I wouldn’t feel the need to attend the security roundtable every year. stuff changes but not so often to make attending the session mandatory every year.

So, to Monday:

With the expectation that the session will have 12c content I plan to attend:10:30-11:!5 Tom Kyte – Oracle

KEYNOTE: Oracle’s Latest Generation of Database Technology

If I suspect that there will be little 12c content I might defect to:

10:30 – 11:15 Duncan Mills – Oracle

KEYNOTE: The Future of Development for Oracle Fusion—From Desktop to Mobile to Cloud

11:50 – 12:35 Steve Millidge – C2B2 Consulting

Real Life WebLogic Performance Tuning: Tales and Techniques from the Field

I have personally experienced the obscure methods required to tune Weblogic on Windows and hope that there will be good specific information of use in this session.

Alternatively, I would also love to attend:

11:50 – 12:35 Jonathan Lewis, Oracle ACE Director – JL Computer Consultancy

Creating Test Cases

I think that it is also worth noting that I have already attended this session during the Northern technology day and found it worthwhile:

11:50 – 12:35 Peter Homes – Interoute Application Management

Oracle 10g & 11g Automatic SGA/Memory Management Cautionary tales.

13:00 – 13:45 Tim Hall, Oracle ACE Director –

PL/SQL : Stop Making The Same Performance Mistakes

However in case of cancellation it would be:

12:45 – 13:45 Carl Dudley, Oracle ACE Director – University of Wolverhampton

SQL Tips, Techniques and Traps to Avoid

Based largely on the excellent information on the AMIS website:

14:40 – 15:25 Luc Bors – AMIS Services

Survival of the Fittest: How to Evolve Your Oracle Forms to the 21st Century

15:40 – 17:30 Jonathan Lewis, Oracle ACE Director – JL Computer Consultancy

B-Tree Indexes

Although I’ll wonder if I really should have been at:

15:50 – 16:35 Carlos Sierra – Oracle

How to Create in 5 Minutes a SQL Tuning Test Case Using SQLTXPLAIN


16:45 – 17:30 John King, Oracle ACE – King Training Resources

What’s Old is New Again: Oracle Forms 11gR2 New Features

17:40 – 18:40

Sport not being my thing, I’ll be looking to fill this time with a trip to:

The Post Office Vaults | Birmingham’s Premier Foreign Bottled Beer

Blog at