Meeting RSVP    

VIC Cost-based optimiser & Transformations: Monday, February 13, 2012 05:00pm

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.

  • Transformations
  • other new behaviours
  • Adaptive Cursors
  • Hints in 11g
  • Getting rid of your hints
  • Assessing plan changes on upgrade
  • Results cache

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.