|Where: ||IBM Australia, Board room - Level 16, 459 Collins Street, Melbourne 3000|
|When: ||Monday, February 13, 2012 05:00pm - 07:30pm|
Cost: Free for AUSOUG members. Pizza and drinks will be served.
Presentation 1: The Cost Based Optimiser in 11g Rel 2
This presentation's aim is to get to know the improvements in behaviour of the optimizer in Oracle 11g v2. It focuses on understanding the decision making of the optimiser rather than the use of point and click tools.
other new behaviours
Hints in 11g
Getting rid of your hints
Assessing plan changes on upgrade
Presentation 2: Transformations - how Oracle rewrites your statements
Before Oracle optimises your statement it may apply transformations that restructure it completely. This presentation examines the optimiser’s capabilities in transforming SQL. It describes performance issues that are overcome by common transformations, and more importantly identifies common code techniques which cannot be transformed and which may cause performance problems. It aims to clarify the reality for developers who now frequently just say "I can write what I like as Oracle will rewrite it for me anyway".
Penny Cookson has over twenty year’s experience of working with Oracle products. Penny is the Managing Director for SAGE Computing Services, which specialises in providing Oracle education and consulting services, and has conducted training courses and provided expert advice in a wide range of products throughout Australia and New Zealand. She was Oracle Magazine’s Educator of the Year in 2004 and is an Oracle ACE.