Friday Sep 27, 2013

Oracle Open World 2013 - It's a wrap

Thanks to all those that attended the Optimizer sessions and stopped by the Optimizer demopod during this years Oracle OpenWorld. It was an amazing conference this year with lots of great technical sessions and interesting discussion at the demo grounds.

Since so many folks have emailed me requesting a copy of the Optimizer session presentations I thought it would be a good idea to post them here. The presentation were unfortunately were larger than the 2MB file limit so I have broken them multiple files. Enjoy!

Session CON8622 :

Session CON8643 :


Wednesday Sep 25, 2013

Day 4 of Oracle OpenWorld 2013 September 25th

Thanks to all those who stopped by the demogrounds  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 demogrounds, so if you haven't had a chance to stop by yet, do so today. The Optimizer developers will be there from 9:45 am until 4pm.

There are also some great technical session on today, including:

  • Oracle Database In-Memory—The Next Big Thing
    Session GEN9312 Presented by Juan Loaiza at 11:45am in Moscone South - room 103
    This session provides a deep-dive explanation of how the new Oracle Database In-Memory works. It's a must see for everyone interested in performance.

  • Optimizer Statistics: A Fresh Approach
    Session CON7442 Presented by Conor McDonald at Moscone South - room 308

Tuesday Sep 24, 2013

Day 3 of Oracle OpenWorld 2013 September 24th

Hopefully you enjoyed yesterday, the first full day of technical sessions at Oracle OpenWorld and are ready for more today!

Today we give our second technical session, Oracle Optimizer Boot Camp: 10 Optimizer Tips You Can’t Do Without (Session CON8643) at 5:15pm, in Moscone South - room 104.


In this session Jonathan Lewis will join us to explain the process of analyzing and solving 10 of the most common SQL execution performance problems. A must see for all those interested in the Optimizer and SQL tuning or England versus Ireland match ups!

The Optimizer team will also be at the Oracle Database Demogrounds all day.  Demogrounds open at 9:45 am and run until 6pm. So stop by and find out what's new with the Optimizer and the statistics that feed it.

Monday Sep 23, 2013

Day 2 of Oracle OpenWorld 2013 September 23rd

Oracle OpenWorld started yesterday and San Francisco is just buzzing with Oracle folks and the excitement generated by the new Oracle Database In-Memory announcements made by Larry Ellison during last nights keynote!

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, Oracle Optimizer: What’s New in Oracle Database 12c? Session CON8622 is on today at 3:15pm in Moscone North, room 131.

This session provides a deep-dive explanation of how the new adaptive approach to query optimization works. We will use a real-world demo to show the different components of the adaptive model and how they help the optimizer learn additional information during query execution that can be used to improve not only the performance of the current SQL statement but all statements.

Members of the Optimizer team will also be available from 9:30am to 6pm at the demogrounds, to answer any Optimizer questions you might have. This may also be your last change to snag the limited edition Optimizer bumper stickers!

+Maria Colgan

Sunday Sep 22, 2013

Day 1 of Oracle OpenWorld 2013 September 22nd

The biggest day of the Oracle calendar has arrived. Oracle OpenWorld 2013 officially starts today!

The show kicks off with ton's of great technical sessions selected by the Oracle User Groups including several sessions on the optimizer:

  • 11:45 AM - 12:45 PM The Query Optimizer in Oracle Database 12c: What’s New?
    Session UGF3062 delivered by Christian Antognini in Moscone West - room 3002

  • 1:00 PM - 2:00 PM Solving Critical Customer Issues with the Oracle Database 12c Optimizer
    Session UGF5498 delivered by Nicolas Jardot in Moscone West - room 3002

And of course, Larry's keynote is this evening 5:15pm – 7:00pm, Moscone North. A must see, as he is bound to make some exciting announcements to get the show started! One of which may be very close to my heart but you will have show up to find out what it is!

All right I will give you a hint .........


Hope to see ya there!

Sunday Sep 08, 2013

Oracle OpenWorld 2013 - Time to plan your schedule

There are only two weeks to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on September 22nd 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 2 technical sessions;

  • Monday, September 23rd at 3:15pm  Oracle Optimizer: What’s New in Oracle Database 12c?
    Session CON8622
    at Moscone North - room 131
    This session provides a deep-dive explanation of how the new adaptive approach to query optimization works. We will use a real-world demo to show the different components of the adaptive model and how they help the optimizer learn additional information during query execution that can be used to improve not only the performance of the current SQL statement but all statements.

  • Tuesday, September 24th at 5:15pm Oracle Optimizer Bootcamp: 10 Optimizer tips you can't do without
    Session CON8643 at Moscone South - room 104
    Jonathan Lewis will join us to explain the process of analyzing and solving 10 of the most common SQL execution performance problems. These problems include poor cardinality estimates, bind peeking issues, the selection of sub-optimal access methods, and many more. Through clear how-to examples, you will learn how to identify and quickly resolve these issues and add 10 new tricks to your SQL tuning arsenal.

If you have 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:45am until 5:30pm. You may even be able to pick up an optimizer bumper sticker.

The full searchable OOW catalog is on-line, or you can browse the speakers by name. So start planning your trip today!

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
« September 2013
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
9
10
11
12
14
15
16
17
18
19
20
21
26
28
29
30
     
       
Today