ODTUG 2006 Washington DC 17 -06 -2006

ODTUG 2006 – Washington DC 17 -06 -2006 – 21 -06 -2006 Alex Nuijten

Saturday 17 -06 -2006 l l Departure Movies: – – – Firewall Flight Plan Hoodwinked

Wardman Park Marriot Hotel

Sunday 18 -06 -2006 l l National Zoo Applied Mathematics for Database Professionals [Toon Koppelaars] – – – l Working on book with Lex de Haan Specifying Business Rules using unambiguous mathematical notation Rule. Gen Speaker and Ambassador Meeting

Monday 19 -06 -2006 l Keynote [Marco Tilli] – l Keynote [Sohaib Abbasi Informatica] – l Core ETL is FREE with Oracle 10 g. R 2 High “Tell. Sell” Level Oracle XML Publisher – What’s it all about [Mark Rittman] – – Introduction to XML Publisher Rebranded to BI-Publisher

Monday 19 -06 -2006 l SQL Games we can play in PL/SQL [Steven Feuerstein] – – l Tuning Oracle 9 i/10 g using Statspack [Rich Niemiec] – – l Bulk Operations Forall Statements Table Functions Quest bought QNXO and QUTE Overview of the Statspack Report >140 slides Application Development Tuning Best Practices [Peter Koletzke] – – – PL/SQL Forms Java

“Tips” Break up large UNION or other complex statements Best Tip: - Put results together yourself with PL/SQL or Global Temporary Table “If you don’t like this presentation, or UPDATE on large record sets may INSERT INTO don’t come to the need to process sets I give” other ones -Again, with PL/SQL -Commit Frequently (500 -1000 rows) -Or use BULK COLLECT

Editor’s Choice Award l l l Andre Beland – The Oracle 10 g Rules Manager and Expression Filter – Events for Business Rules Lucas Jellema – Pretty Java. Server Faces Alex Nuijten – One Analytic Function can do more than a 1000 lines of code David Schleis – Polishing up your Web Applications with AJAX Maggie Tompkins – Lean Six Sigma Tools and Techniques for Software Process Improvement

Tuesday 20 -06 -2006 l l The Water is still burning – A New quiz on Oracle SQL and PL/SQL No Cary, we’re STILL not tuning the right stuff [Mogens Nørgaard] – – l I & KTTM Hash Value in V$SQL One Analytic Function can do more than a 1000 lines of Code SQL/PLSQL Panel [Feuerstein Jellema – SQL/PLSA Panel [Feuerstein – – Jellema – Beumer - ? ] l Oracle 11 g Specification Freeze l Versioning Objects (24/7) l

Wednesday 21 -06 -2006 l l Object Type Evolution. Solved!!! [Scott Knutsen] Google Maps and Oracle HTML DB [I. Michael Snyder] – l l l Inside the Oracle 10 g Cost Based SQL Optimizer [Donald Burleson] JDeveloper and ADF for Forms Developers: Taking it to the next level [Grant Ronald] XQuery in Oracle – the new XML Data Language [Kim Alex Olson] – l l www. casetech. net: whitepapers and code samples FLOWR Oracle Webforms: Productivity with new choices [Matthieu de Graaf] Sightseeing

White House

Washington Memorial

Vietnam Memorial

Jefferson Memorial

Thursday 22 -06 -2006 l l Shopping Flying back – – Chicken Little King Kong

Friday 23 -06 -2006 l l Arrival at Schiphol … last weekend…

Proof we were there…