Upcoming events : ODTUG Kscope 12
By Maria Colgan-Oracle on May 28, 2012
Kscope 12, is the annual conference of the Oracle Development Tools User Group, which is taking place June 24 - June 28, in San Antonio Texas this year. This is a great conference for Oracle developers and architects, offering the best content by renowned experts. I am luck enough to be involved in five sessions this year around the Oracle Optimizer and performance. Below are details on the session I will be presenting or co-presenting in. I hope you have an opportunity to check out some of these sessions if you plan to attend the conference!
- Sunday, June 24st at 3:45pm Oracle Optimizer: Top Tips to get Optimal SQL Execution all the Time
This session is part of the Database SIG that is happening on Sunday. In this session I will show you how to identify and
resolve common SQL execution performance problems, such
as poor cardinality estimations, bind peeking issues, selecting the
wrong access method, join type or join order.
- Monday, June 25th at 4:15 pm DB Experts Panel at ODTUG
This session provides an open Q&A for attendees to pose questions about the Oracle Database and Oracle Exadata to a panel of database experts including:
Cary Millsap, Jonathan Lewis, Dominic Delmolino, Tim Gorman, Dan Norris and myself.
- Tuesday June 26th at 11:30 am Implement extensible in-database analytics by programming MapReduce in SQL & PL/SQL
I play just a small role in this session, which will actually be delivered by Bryn Llewellyn. This session uses real-world examples to illustrate how to implement MapReduce style solutions in the Oracle Databaseusing standard SQL and PL/SQL.
- Wednesday June 27th at 8:30 am SQL Tuning in a Data Warehouse Environment
This session will discuss a straight-forward approach to tackling SQL
tuning in a warehouse environment. Uses real-world examples it
demonstrates how you should navigate the complex execution plans found in
a data warehouse environment and determine what steps are necessary to
improve the performance.
- Wednesday June 27th at 9:45 am Understanding Optimizer Statistics
this session I will discuss the features introduced in Oracle Database
11g to improve the quality and efficiency of statistics-gathering as
well as strategies for managing statistics in various database