Hotsos Symposium 2012 Speaker Spotlight - Doug Burns

Hotsos is very pleased to announce that Doug Burns is returning for Hotsos Symposium 2012! He has graciously accepted the spots formerly held by Randolf Geist, who had to cancel. While we will miss meeting Mr. Geist, we are very happy that Doug agreed to take his slots.

Doug Burns is an independent contractor who has 20 years of experience working with Oracle in a range of industries and applications. As well as presenting at a number of conferences, he has developed, taught, and edited performance-related courses for both Oracle UK and Learning Tree International. He is a member of The Oak Table Network and an Oracle Ace Director.

Doug's Topics: Statistics on Partitioned Objects 2012 and Falling in Love All Over Again ... OEM 12c Performance Page Enhancements

Descriptions of Sessions: Statistics on Partitioned Objects 2012 – Optimal SQL execution plans are rooted in the quality of the statistics describing the underlying objects that are used by the Cost Based Optimizer.

Statistics maintenance is a particular challenge on Data Warehouse systems holding large data volumes that support complex and flexible user reporting requirements. Such systems are likely to use partitioned tables and indexes to complicate the picture further.

Continuing the theme of last years presentation, the 2012 version will look at additional lessons learned during the past year and focuses on 11g features.

Review of Core Issues

• The quality/performance trade off
  
  • Global and Approximate Global statistics METHOD_OPT and Column Statistics
• Alternative Strategies
  
  • Copying statistics
  • Setting statistics
• 11g improvements
  
  • AUTO_SAMPLE_SIZE
  • Incremental Statistics

The presentation will discuss a variety of problems and bugs with the various approaches that should be avoided as well as offering guidelines to help you design the best statistics collection strategy for your requirements.

Falling in Love All Over Again ... OEM 12c Performance Page Enhancements – Oracle 10g introduced significant instrumentation enhancements and the OEM 10g Performance Pages illustrated them to make performance analysis much easier. OEM 12c is the latest evolutionary stage of the Performance Pages and this presentation shows the new features that make them even more compelling and useful in more situations.

There are a few more seats available for Hotsos Symposium 2012, but you'll need to register soon! We don't want you to miss out on all these fabulous speakers. ;)

Hotsos Symposium 2012 Discussion Forum

Hotsos is pleased to announce that we have set up a discussion forum for each of the presentations for Hotsos Symposium 2012. Your questions will be answered by the speakers. The forum is moderated, and you will be required to create a login to participate.

To access the Hotsos Symposium 2012 Forum, please visit www.hotsos.com/forum.html. Create an id, and start entering your questions.

Comments or questions about this forum can be sent to support@hotsos.com. We hope that you will find value in this new offering.

Hotsos Symposium 2012 Speaker Spotlight - Cary Millsap

The Hotsos Symposium 2012 Speaker Spotlight is focusing on Cary Millsap this week. Cary is a returning speaker, and a co-founder of Hotsos and the Hotsos Symposium. Read more about him and his topic below. To view a list of the additional speakers, please visit the Hotsos Symposium Speaker page.

About Cary: Cary Millsap is an entrepreneur, software technology advisor, software developer, and Oracle software performance specialist. His technical papers are quoted in many Oracle books, in Wikipedia, in blogs all over the world, and in dozens of conference presentations each month. His blog is read by thousands of people each month. He has presented at hundreds of public and private events around the world. He wrote the book "Optimizing Oracle Performance" (O'Reilly 2003), for which he and co-author Jeff Holt were named Oracle Magazine's 2004 Authors of the Year. He is the founder and president of Method R Corporation (http://method-r.com), a company that creates frustration-free software that shows performance the way you've always wanted to see it. Cary is an Oracle Ace Director.

Cary's Topic: Instrumentation: Why You Should Bother

The Abstract: In our increasingly virtualized environments, it's ever more difficult to diagnose application defects — especially performance defects that affect response time or throughput expectations. Runtime diagnosis of defects can be an unbearably complicated problem to solve once the application is sealed up and put into production use. But having excellent runtime diagnostics is surprisingly easy if you design the diagnostic features into the application from its inception, as it is being grown, like you would with any other desired application feature.

There are still a few seats open so be sure to register soon!

Hotsos Symposium 2012 Speaker Spotlight - Christian Antognini

The Hotsos Symposium 2012 Speaker Spotlight is focusing on Christian Antognini this week. Christian is a returning speaker, and his sessions are always engaging. We think you'll find his topic and abstract especially interesting. Read more about him and his topic below. To view a list of the additional speakers, please go to the Speaker page.

Topic: Shareable Cursors

Abstract: The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused?

The aim of this presentation is not only to discuss what parent and child cursors are but also, and foremost, to examine in what situations it is possible to reuse them. In doing so, topics such as bind variable peeking, bind variable graduation, adaptive cursor sharing and cardinality feedback will be covered as well.

About Christian: Since 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management and optimization. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.

If Christian is not helping one of his customers get the most out of Oracle, he is somewhere lecturing on application performance management or new Oracle Database features for developers. In addition to classes and seminars organized by Trivadis, he regularly presents at conferences and user-group meetings. He is a proud member of the OakTable Network.

Christian is the author of the book Troubleshooting Oracle Performance (Apress, 2008).

Hotsos Symposium 2012 Speaker Spotlight - Carlos Sierra

Biography: Carlos has collaborated with Oracle Support since 1996. During this time, he has rotated through several groups including: EBS Manufacturing, Field Support, EBS Center of Expertise COE and for the past 5 years Server Technologies COE.

Carlos is the author of SQLTXPLAIN. A tool that is becoming the preferred choice by Oracle Support and Development to analyze and diagnose SQL statements performing poorly. This tool has been his main contribution to Oracle and the community for the past 10 years.

Carlos has been a speaker in regional Oracle user's groups in Florida. He has delivered several WebCasts about SQLTXPLAIN to Oracle's customers. He has developed two advanced Oracle internal workshops in the area of SQL Tuning and delivers them all over the world.

Carlos has made SQL Tuning his daily job and cherished hobby. He is always willing to help others when they need a second pair of eyes to review an issue in the area of SQL Tuning.

Presentation Title and Abstract: How to Creat in 5 Minutes a SQL Tuning Test Case using SQLTXPLAIN

Creating a reproducible Test Case is frequently a necessary step to progress a SQL Tuning issue. Oracle Support requires this all the time.

A Test Case needs the metadata to re-create the schema objects accessed by the SQL statement. It also requires the CBO schema object statistics. The CBO system statistics may be also needed. The entire CBO environment is a must (Parameters and Fix Control). Specific CBO Parameters set at the time the SQL was parsed are needed. The values of the bind variables at the time the SQL was parsed are also needed. Other elements may be required like Constrains and Policies.

Putting together a Test Case is not an easy task. The good news is that every time you use SQLTXPLAIN on any of its main methods (XTRACT, XECUTE, XTRXEC and XPLAIN) a Test Case is assembled and included within the output of SQLT. So, when you send to Oracle Support a SQLT ZIP file it includes such Test Case.

During this presentation, you will learn how to implement a SQLT Test Case as Oracle Support does. You can benefit from this functionality by easily creating a Test Case from your Production environment into your Test system. There you can apply some "what if" tests or reduce your TC in order to simplify it. You can even create a Test Case out of another Test Case. Being able to easily "copy" the tuning environment for a particular SQL from Production into Test is very desirable if you or your team perform in-house SQL Tuning.

Now...don't you want to sign up for Hotsos Symposium 2012? If Carlos' presentation doesn't tempt you, you may want to take a peek at our Speaker page at www.hotsos.com to see if any other's do. You won't find another conference completely dedicated to Oracle performance optimization. To sign up, please visit Registration. We hope to see you in March!

Hotsos Symposium 2012 Speaker Spotlight - Bryn Llewellyn

The Hotsos Symposium 2012 Speaker Spotlight is focusing on Bryn Llewellyn this week. We think you'll find his topic and abstract interesting. Visit registration to sign up. To view a list of the additional speakers, please go to the Speaker page.

About Bryn: Bryn has worked in the software field for 30 years. He joined Oracle UK in 1990, at the European Development Center, to work in the Oracle Designer team. He transferred to the Oracle Text team and then into Consulting as the Text specialist for Europe. He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the Product Manager for PL/SQL since 2001.

It's hard for Bryn to remember his life before Oracle. He started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN!) and then worked in Oslo, first at the Norwegian Computing Center and then and in a startup. In Norway, Bryn programmed in Simula (its inventors were his close colleagues). This language is recognized the first object-oriented programming language and was the inspiration for Smalltalk and C++.

Bryn's Presentation: Implement Extensible In-Database Analytics by Programming Map Reduce in PL/SQL

The Abstract: The MapReduce programming model lets developers without experience with parallel and distributed systems utilize the resources of a large, multi-CPU system. Hadoop clusters can be used to implement this model; but Oracle Database also provides mechanisms to support the same model – and with less programming. SQL's analytic capabilities are more powerful than many experienced programmers suspect; but detecting complex patterns within suitably characterized, independent subsets of the complete data set sometimes needs user-written procedural code. Enter in-database MapReduce: pipelined PL/SQL table functions declaratively specify, with a few keywords, how parallel query should do the "map"; then the procedural body does the "reduce".

Bryn addresses ways to implement an application to solve a specific problem where, because of the typically huge volumes of data that must be distilled down to provide interesting information, performance matters. A person whose job it is to work with an installed system, won't be able to use what he explains in his talk to tune its performance.

Now...are you ready to sign up??? Go to registration for more information and to register. Hope to see you in March!