Monday Jun 25, 2012

Last chance to vote in Optimizer Bumper Sticker Competition

There is still time to vote in our competition to find the best Optimizer bumper sticker, which we will give away at the Optimizer demo booth at this years Oracle Open World.

Click here to vote for your favorite. Then stop by the Optimizer demo booth at Oracle Open World to claim your bumper sticker!

Remember voting will close on June 30th and the winning slogan will be announced in early July.

+Maria Colgan

Saturday Jun 09, 2012

Optimizer Bumper Sticker Competition

For the last couple of months we have been running a competition on twitter (@SQLMaria) looking for the best Optimizer bumper sticker, which we will give away at the Optimizer demo booth at this years Oracle Open World. We got tons of excellent entries and had a tough time narrowing it down to just 5 but we have. So now we need your help to pick the final winner. Click here to vote for your favorite. Then stop by the Optimizer demo booth at Oracle Open World to claim your bumper sticker!

[Read More]

Friday Mar 09, 2012

Oracle OpenWorld 2012 Call For Papers

I can't believe it's time once again to start thinking about Oracle OpenWorld! The Oracle OpenWorld 2012 call for papers opens March 14th. Oracle customers and partners are encouraged to submit proposals to present at this year's Oracle OpenWorld conference, which will be held September 30 - October 4, 2012 at the Moscone Center in San Francisco. Details and submission guidelines are available on the Oracle OpenWorld Call for Papers web site. The deadline for submissions is April 9th 2012 at 11:59 pm PDT. We look forward to checking out your sessions on the Optimizer, SQL Plan Management, and statistics!

[Read More]

Monday Oct 17, 2011

Open World 2011 recap

We had a great time talking to everyone at Open World 2011 both at our Demogrounds booth and  in our  technical sessions.  We got asked a lot of interesting questions and we plan to address them in future blog posts... so stay tuned.


The slides from our session on managing optimizer statistics are now available on Oracle Open World Content Catalog. The slides for our session on preventing suboptimal plans should be posted soon.


We are still working on a good mechanism for sharing the exercises from the hands - on lab but we will blog more about that once its in place.


If you didn't get to attend the conference, but have a question about the Optimizer you would like to see answered on the blog, you can submit it through via email.



We look forward to see you all next year at Open World 2012

Maria Colgan+

Wednesday Oct 05, 2011

Day 5 of Oracle Open World 2011 October 6th

Its the last day of Oracle Open World and we have saved the very best for last. So hopefully you are still awake and functioning at this stage!


We present our top tip session today at 12 noon in Moscone south, room 104. The session is called  Oracle Optimizer: Tips for Preventing Suboptimal Execution Plans (Session 14069). This session is a continuation from a session we did last year called Top Tips for getting optimal SQL execution every time. This year we answers questions like why an index wasn't used, why partition eliminations did not occur, why statistics were ignored, and many more. With clear how-to examples, you will learn to identify and quickly resolve these issues without the need for optimizer hints or initialization parameters.


 We hope you have enjoy the conference so far and will stop by our session this afternoon.


Maria Colgan+

Tuesday Oct 04, 2011

Day 4 of Oracle Open World 2011 October 5th

Thanks to all those who stopped by the demoground  to chat with the Optimizer developers and to check out what is new in the Oracle Optimizer over the last two days. Remember today is the last day of the demoground, so if you haven't had a chance to stop by yet do so today. The Optimizer developers will be there today from 9 am until 4pm.

To day at Open World we will be giving a sessions on Optimizer statistics. The session starts at 10:15 am and is called Oracle Optimizer: Best Practices for Managing Optimizer Statistics (Session 13961) and is in Moscone South, room 103. In this session we 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 environments.  This is your opportunity to finally understand Optimizer statistics and when and how you should gather them.

Looking forward to seeing you at our session or at the demoground!

Monday Oct 03, 2011

Day 3 of Oracle Open World 2011 October 4th

Hopefully you enjoyed yesterday, the first full day of technical sessions at Oracle Open World and are ready for more today! The Optimizer team are not presenting a session today but we at the Oracle Database Demo Grounds all day. Demo Grounds open at 9:45 am and run until 5:30pm.  So stop by and find out what's new with the Optimizer and the statistics that feed it!

Sunday Oct 02, 2011

Day 2 of Oracle Open World 2011 October 3rd

Oracle Open World started yesterday and San Francisco is just buzzing with Oracle folks! If you are attending the conference don't miss the opportunity to chat with the Optimizer development team at one of our technical sessions, or at the Oracle Demo grounds.


Our first technical session happens today at 12:30pm. Our hands on lab, Oracle Optimizer: Prevent Suboptimal Execution Plans (Session 29380) is scheduled at the Marriott Marquis hotel in Salon 12 / 13. In this hands on lab you will get an opportunity to solve 4 SQL tuning problems either on your own or with the help of the Optimizer development team. The problems will include scenario like, why was my index not selected, why statistics were ignored, and many more.


Hope you can join us at the hands-on lab!


Friday Jul 22, 2011

What the Optimizer team will be up to at Oracle Open World 2011

Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts will happen October 2-6 in San Francisco. Of course the Optimizer development group will be there and you will have multiple opportunities to meet the team, in one of our technical sessions, or at the Oracle demogrounds.


This year the Optimizer team has 3 technical sessions;



  • Monday, October 3rd at 12:30pm  our hands on lab, Oracle Optimizer: Prevent Suboptimal Execution Plans
    Session 29380 at the Marriott Marquis - Salon 12 / 13
    In this hands on lab you will get an opportunity to solve 4 SQL tuning problems either on your own or with the help of the Optimizer development team. The problems will include scenario like, why was my index not selected, why statistics were ignored, and many more.

  • Wednesday, October 5th at 10:15am Oracle Optimizer: Best Practices for Managing Optimizer Statistics
    Session 13961 at Moscone South - room 103
    In this session we 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 environments.

  • Thursday, October 6th at 12 noon Oracle Optimizer: Tips for Preventing Suboptimal Execution Plans
    Session 14069 at Moscone South - room 104
    This session is a continuation from a session we did last year called Top Tips for getting optimal SQL execution every time. This year we answers questions like why an index wasn't used, why partition eliminations did not occur, why statistics were ignored, and many more. With clear how-to examples, you will learn to identify and quickly resolve these issues without the need for optimizer hints or
    initialization parameters.


If you have some burning Optimizer or statistics related questions, you can ask them at the Optimizer demo booth in the Database area of the demogrounds. Members of the Optimizer development team will be there Monday to Wednesday from 9:45 am until 5:30pm. The full searchable OOW catalog is on-line, or you can browse the speakers by name. So start planning your trip today!

Wednesday Mar 16, 2011

Oracle OpenWorld 2011 Call For Papers

The Oracle OpenWorld 2011 call for papers is now open. Oracle customers and partners are encouraged to submit proposals to present at this year's Oracle OpenWorld conference, which will be held October 2-6, 2011 at the Moscone Center in San Francisco. Details and submission guidelines are available on the Oracle OpenWorld Call for Papers web site. The deadline for submissions is Sunday, March 27 2011 at 11:59 pm PDT. We look forward to checking out your sessions on the Optimizer, SQL Plan Management, and statistics!

Tuesday Sep 21, 2010

Update on Oracle Open World

Thanks to all those who stopped by the demoground yesterday to chat with the Optimizer developers and to check out what is new in Oracle Database 11g. If you haven't had a chance to stop by yet the developers will be there all day today and tomorrow.

To day at Open World we will be giving two sessions on the Optimizer. We will start at 11 am with the Explain the Explain plan session (session S316955 Moscone South/Rm 104), where we will examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaning from the plan. Then on this afternoon at 3:30 pm  we will build on what you learned in the morning session when we present Top tips for getting optimal SQL execution all the time (session S317019 Moscone South/Rm 103). This session will show you how to identify and resolving the most common SQL execution performance problems, such as poor cardinality estimations, bind peeking issues, and selecting the wrong access method.  

Looking forward to seeing you at our sessions or at the demoground!

Friday Aug 06, 2010

What to expect from the Optimizer team at Oracle Open World 2010

Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts will happen in September (19-23) when Oracle will host its annual user conference in San Francisco. And the Optimizer development group will be there!

You have multiple opportunities to meet the team, either at one of our technical sessions, or at the Oracle Demo grounds.  This year the Optimizer team has 3 technical session, all of which build from one another.  We will start on Tuesday morning at 11 am with the Explain the Explain plan session (session S316955 Moscone South/Rm 104), where we will examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaning from the plan.

Then on Tuesday afternoon at 3:30 pm  we will build on what you learned in the morning session when we present Top tips for getting optimal SQL execution all the time (session S317019 Moscone South/Rm 103). This session will show you how to identify and resolving the most common SQL execution performance problems, such as poor cardinality estimations, bind peeking issues, and selecting the wrong access method.  

Finally Wednesday morning at 11:30 am you get an opportunity to put what you learned at both of the technical presentations to good use when you join us for our first ever hands on lab, Explain Plan: How to read and Analyze Execution Plans (Session S318755 Marriott Marquis/Salon 10 / 11). In this hands on lab you will get to solve 4 SQL tuning problems using the techniques described in the technical sessions.

The Optimizer development team will also be at the Oracle demo grounds (Monday through Wednesday) to answer all of your burning questions and to demonstrate the latest 11g features.

Wednesday Oct 28, 2009

Oracle Open World 2009 Summary

We had a great time talking to you all at Open World 2009 both at our Demogrounds booth and at our two sessions. We received a lot of interesting questions during the Optimizer Roundtable discussion, but we did not get to answer all of them due to time constraints. We plan to address the questions we received (both answered and unanswered) in future blog posts... so stay tuned. If you didn't get to attend the discussion, but have a question about the Optimizer, submit it through the email link above.

For those of you who did not get a chance to stop by our Demogrounds booth, here's a recap of the new features that we talked about. Many of the topics have already been covered in earlier blog posts.

[Read More]
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
« July 2015
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
31
 
       
Today