Thursday May 02, 2013

Upcoming event: Kscope 13

Kscope 13, is the annual conference of the Oracle Development Tools User Group, taking place  June 23 - June 27, in New Orleans. This is a great conference for Oracle developers and architects, offering some of 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. I hope you have an opportunity to check out some of these sessions if you plan to attend the conference!

[Read More]

Tuesday Feb 05, 2013

Upcoming events : RMOUG 2013

I'm really looking forward to the  Rocky Mountain Oracle User Groups Training days next week, at the Colorado Convention Center, as it will bring several new challenges for me.  I am going to be involved in three very different sessions at this years conference:

[Read More]

Friday Jul 13, 2012

Upcoming events: INOUG Oracle Training Day!

The Indiana Oracle User Group (INOUG) have been kind enough to ask me to present an all day Optimizer workshop at their annual training day on July 26th at Eli Lilly & Co. The workshop will consist of four 90 minute session and will explain the fundamentals of the cost based Optimizer and the statistics that feed it, as well as providing a methodology for diagnosing and resolving SQL execution performance problems.

The workshop begins with an in-depth look at statistics and statistics maintenance, a challenge all DBAs must face in order to prevent suboptimal execution plans. It continues with a detailed explanation on how to interpret an execution plan. Each aspect of an execution plan will be examined, from cardinality estimates to parallel execution, and you will learn what information you should be gleam from the plan and how it affects the execution performance of a SQL statement. After lunch the workshop focuses on the process of analyzing and resolving the most common SQL execution performance problems including poor cardinality estimations, bind peeking issues, selecting the wrong access method and much, much more.

You can register for the event here. I hope you can join us!

+Maria Colgan

Monday May 28, 2012

Upcoming events : ODTUG Kscope 12

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 on. I hope you have an opportunity to check out some of these sessions if you plan to attend the conference!

[Read More]

Monday Mar 26, 2012

Upcoming events : OBUG Connect Conference 2012

The Oracle Benelux User Group (OBUG) have given me an amazing opportunity to present a one day Optimizer workshop at their annual Connect Conference in Maastricht on April 24th. The workshop will run as one of the parallel tracks at the conference and consists of three 45 minute sessions. Each session can be attended stand alone but they will build on each other to allow someone new to the Oracle Optimizer or SQL tuning to come away from the conference with a better understanding of how the Optimizer works and what techniques they should deploy to tune their SQL. Below is a brief description of each of the sessions[Read More]

Monday Mar 12, 2012

Upcoming events : Oracle User Group Norway Conference

On March 22nd the  Oracle user group in Norway will take to the sea for their annual conference! This year for the first time they are starting the conference on dry land on Wednesday March 21st, followed by a two day trip from Oslo to Germany and back on a ferry. I am presenting the following three sessions at the conference.[Read More]

Friday Feb 17, 2012

Upcoming events : Hotsos Symposium 2012

I have been lucky enough to be invited to the tenth annual Hotsos Symposium in Irving Texas on March 4-8. The Hotsos Symposium differs from other Oracle conferences because it is a dedicated Oracle performance conference and attracts some of the top performance speakers like, Tom Kyte, Cary Millsap, and Jonathan Lewis. If you get a chance you should really check it out. I have two sessions at this years symposium.[Read More]

Monday Jan 16, 2012

Upcoming events : RMOUG 2012

Even though the new year has just begun my calendar is already filling up with conferences. The first conference of the year is the Rocky Mountain Oracle User Groups Training days on Febuary 14 - 16 at the Colorado Convention Center in Denver, Colorado. It a great conference with over 700
attendee and some really great speakers. I am going to be delivering three session at this years conference:

[Read More]

Monday Oct 31, 2011

Upcoming events : UKOUG 2011

UK Oracle User Group Conference 2011, takes place in Birmingham on December 4th - 7th. This year there will be 15 different streams and over 250 sessions to choose from. I am lucky enough to be presenting two session at this years conference.

Hope to see you at the conference!

Maria Colgan+

Tuesday Apr 19, 2011

Upcoming events : ODTUG Kaleidoscope 2011

ODTUG Kaleidoscope 2011, June 26 - June 30 Long Beach CA is a great conference for Oracle developers and architects, offering the best content by renowned experts. I will be delivering two Optimizer sessions this year, 'Explaining the Explain plan' and 'Oracle Optimizer- Top Tips to get Optimal SQL Execution'. In the Explain the Explain plan session we will discuss each aspect of an execution plan (from selectivity to parallel execution), explain what information you should be getting from the plan, and how it affects the execution. While in the Top tips session, I will show you how to identify and resolving the most common SQL execution performance problems including, poor cardinality estimations, wrong access method being used, and much more. This session is packed with clear how-to examples making it accessible for even the most novice of Oracle Users.

ODTUG is a great conference where you can learn lots in a fun and casual atmosphere. Looking forward to seeing some of you there!

Monday Feb 21, 2011

Upcoming events : Hotsos Symposium 2011

This year for the first time, I will present at the Hotsos Symposium in Dallas Texas, March 7 - 9. I will present on two topics Top tips for Optimal SQL Execution and Implement Best Practices for Extreme Performance with Oracle Data Warehousing.

I am really looking forward to attending some excellent sessions at the conference from folks like Tom Kyte, Cary Millsap, Doug Burns, and Dan Fink. Hope to see you there!

About

The Oracle Optimizer blog is written by members of the Optimizer development team. The goal of this blog is to provide an insight into the workings of the Optimizer and the statistics it relies on. The views expressed on this blog are our own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect ours.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today