Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Disclaimer
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.
Maria Colgan
Maria Colgan
Upcoming events & presentations
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 am 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!
Categories
- cursor sharing (4)
- diagnosability tools (2)
- event announcements (3)
- explain plan (1)
- introduction (1)
- open world (5)
- optimizer statistics (3)
- query optimization (2)
- sql plan management (5)
- understanding execution plans (2)
- upgrade (2)
8 comments:
Wonderful! Thanks for doing this, I'm sure it will be very useful! Looking forward to your blog entries!
hi there,
I really liked the post.Going to add it my blogroll,site.Hope I shall learn alot about my optimizer.
Keep the good posts coming.
Cheers,
Aman....
Excellent job guys, looking forward for more posts
Malak Aziz
I'm having trouble with a production query that is exhibiting strange behavior. The first time or 2 that it is parsed following an instance start, it chooses a bad plan. Shortly thereafter it will start choosing a different (better) plan. What factors could cause this behavior? The stats have not changed, nor have the system stats. I have 10053 traces for both the good and bad plans. Is this an ok forum to ask such a question? I've had an SR open for more than 2 months with no valuable suggestions to show for it.
Thank you very much for this wonderful blog...Hope 2 become better developers...
This is what we need it. In an age where MISinformation can cause a lot confusion/frustrations. It's refreshing, to get information right from the source.
This is what we need it. In an age where MISinformation can cause a lot confusion/frustrations. It's refreshing, to get information right from the source.
sounds like a good blog
Post a Comment