Perth AUSOUG meeting

I’ll be doing a talk on Flashback on Feb 29.  Details below – hope to see you there.


Where: Oracle Australia: Level 2, 66 Kings Park Road, West Perth

When: Wednesday, February 29, 2012. Breakfast starts 7:30am, and the talk from 8-9am

RSVP: By RSVP Sunday 26th February 5pm by emailing

Cost: Free to all AUSOUG members. Ticket parking on Walker St, just off Kings Park Road, or catch the Red CAT, with a short walk from corner of Outram/Ord.

Abstract – Flashback:
We have all heard the term "adrenalin rush".  It comes about 3 seconds after you press the Commit button and you realise that you probably needed to have a WHERE clause on that "delete all rows from the SALES table" SQL statement.  Or it might come just after you run "drop table" on the Production database, when you were just so sure that you were logged onto the Test system.  This session will discuss how you can use the FLASHBACK features in 10g and 11g to overcome this uniquely human condition

Calling all Oracle Tasmanians :-)

I’m in Hobart Tasmania for a half day on Monday (Feb 29).  If you’re in town, please drop in and say Hi – should be a fun morning

Here is the agenda

09:00 – 09:15 am General introduction

09:15 – 10:15 am Presentation – Diary of an 11.2 upgrade

10:15 – 10:30 am Morning tea

10:30 – 11:30 am Presentation – Optimizer stats strategies – a fresh approach

11:30 – 12:30 pm Presentation – Miscellaneous SQL features

12:30 – 01:30 pm Lunch, general questions and networking

Morning tea and a  light lunch will be provided so it would be very much appreciated if you could RSVP so we can correctly cater for the event by email to


See you there !