|Timestamp||Session ID||Session Title||Session Abstract||Session Date||Session Time||Speaker||Room|
|8/8/2011 13:16:27||28060||IOUG: Administering Parallel Execution in Oracle RAC||Optimal parallel execution setup is akin to improving PQ/PX performance in RAC. There are varieties of ways to control the placement of Parallel slaves, each with a different approach in mind. Further, services can be effectively used to dynamically control the PQ execution. Instance_group, parallel_instance_group, service and parallel_instance_group, Parallel DML, parallel_execution_message_size, and partition wise join will be discussed in detail.||2011-10-02 (Sunday)||9:00:00||Riyaj Shamsudeen||Mascone West -2005|
|8/8/2011 20:44:31||4921||RDBMS Forensics: Using ASH for Troubleshooting||Arthur C. Clarke wrote that "any sufficiently advanced technology is indistinguishable from magic." That is true, and it sometimes makes troubleshooting seem like art. But it is not art; it is process—and this presentation uses a case study, such as resolving the ORA-03136 "connection lost" error, to demonstrate that process and to show how components such as ASH, typically thought of as performance tuning tools, are also useful diagnostic tools. Attendees will learn a forensic, empirical approach to troubleshooting and see a demonstration of a complex troubleshooting task resulting in a nonintuitive but empirically sound resolution.||2011-10-02 (Sunday)||13:30:00||Tim Gorman||Moscone West - 2009Moscone West - 2009|
|8/12/2011 12:00:35||28780||An Alternative to Star Transformations: Spiny Starfish||For a variety of reasons, an automatic star transformation plan may be unavailable when you are assembling a selection from a fact table and its associated dimensions and perhaps some additional ornamentation. Before bitmap indexes and star transformations existed in Oracle Database, this session's speaker found that you could routinely get a less costly result by assembling a rowid spine filtered according to tables and lists and then using that spine to drive the assemblage efficiently. This presentation extends the considerations beyond what is plausible for a blog post and suggests ways that what the speaker now calls "spiny starfish" plans may be useful.||2011-10-02 (Sunday)||13:45:00||Mark W. Farnham||Moscone West - 2004|
|8/13/2011 7:50:41||31460||Exadata for Oracle DBAs||So how much do you have to learn (and unlearn) to be a database machine administrator (DMA) of Oracle Exadata? You will be surprised to know that it's not much. As a DBA, you already know 60 percent of the concepts. In this session, learn the remaining 40 percent: what the secret sauce in Oracle Exadata is, how it is different, and why it performs so well. Understand the concepts of storage indexes, smart scans, nodes, cells, and basic CellCLI commands to be a starting DMA designing for your organization—all from the perspective of an Oracle DBA, narrated by a longtime DBA and recent DMA.||2011-10-02 (Sunday)||12:15:00||Arup Nanda||Moscone West - 2007|
|8/15/2011 13:13:31||42||OAUG DBSIG||The OAUG DBSIG will have a brief business meeting led by Michael Brown and Kaberi Nayak followed by presentations from Andrew Rivenes and Mark W. Farnham|
Andy's a presentation about secure files and hierarchical storage.
Mark's presentation is about organizing the order of change of tables and rows within transactions across the organization to minimize deadlocks.
The floor will be open for questions of general interest as time allows.
|2011-10-02 (Sunday)||9:00:00||Mark W. Farnham||Moscone West 3010|
|8/17/2011 8:10:22||13643||Real-World Performance: How Oracle Does It||Oracle's Real-World Performance Group has been achieving world-class performance for clients for more than 15 years. In this session, some of the senior engineers describe the techniques, philosophy, and tools they use to address performance challenges. The session is packed with demos and examples to convey the pragmatism required in real-world performance today.||2011-10-02 (Sunday)||13:15:00||Greg Rahn, Michael Hallas & Bob Carlin||Moscone South - 104|
|8/8/2011 4:35:36||8857||Oracle Database 11g Features for Developers||The days of a database developer's just knowing the INSERT, UPDATE, DELETE, SELECT syntax plus a little bit of PLSQL are long gone. Nowadays, it's a different story—just the SQL manual alone is a mind-boggling 1,500 pages! It's so hard to keep up with the technology that developers often quickly resort to antiquated solutions that are more complicated, slower, or plain wrong, leading to unjustified criticism of the database. This session takes a tour of the new features for developers in Oracle Database 11g and Release 11.2, so we can be armed with the right knowledge to get the most out of Oracle Database.||2011-10-03 (Monday)||15:30:00||Connor McDonald||Marriott Marquis - Salon 7|
|8/8/2011 6:11:36||12940||Top 10 Lessons Learned in Deploying Multiple Databases on Oracle Exadata||Most enterprises have several, if not hundreds of, Oracle Database instances. Given the power and flexibility of Oracle Exadata, it makes a lot of sense to use the platform to consolidate these databases onto a single Oracle Exadata system. There are significant benefits to hosting multiple databases on Oracle Exadata, including saving floor space and power; leveraging the available DBA resources; and, most importantly, saving money. In this session, learn technical tricks and best practices for hosting multiple mixed workloads on Oracle Exadata and hear how it was done in the real world. An Oracle Exadata customer shares its implementation experiences and what it learned.||2011-10-03 (Monday)||11:00:00||Dan Norris||Moscone South 310|
|8/8/2011 8:01:35||9355||Large-Scale Consolidation onto Oracle Exadata: Planning, Execution, and Validation||This session presents some patterns used and lessons learned from Oracle Exadata consolidation projects the speaker has been involved in. First it examines the consolidation planning phase, including basic capacity planning techniques, validation of applications' versions and Oracle Real Application Clusters compatibility, and gathering of performance baselines for later migration validation. Next it covers some lessons learned from executing the consolidation tasks, such as setting up proper services and resource allocation/management for the newly consolidated schemas and databases. Finally, it looks into post-consolidation monitoring that helps validate the performance of the consolidated databases and ensure that no resources are wasted.||2011-10-03 (Monday)||15:30:00||Tanel Poder||Moscone South 303|
|8/8/2011 9:08:54||6788||Thinking Clearly about Skew||"Skew" is the most important four-letter word that a performance analyst can learn. It is the insidious property, not just of the data in our tables' columns, but in our diagnostic performance data that twists our analyses and conceals our true performance problems from us. This session gives examples of the punishing effects of skew and how you can avoid them.||2011-10-03 (Monday)||15:30:00||Cary Millsap||Moscone South 302|
|8/9/2011 0:51:32||8984||Successful Oracle Database 10.2 to 11.2 Migration with Oracle Real Application Testing||How to best prepare the migration from one release of Oracle Database to another? Many application developers and DBAs validate a subset of the workload with synthetic testing, and often bad surprises can happen (execution plan change, and so on). This presentation demonstrates Oracle Real Application Testing and its usage for database migration. It shares CERN's experience, the pitfalls, and the huge benefits that can result from deploying Oracle Real Application Testing.||2011-10-03 (Monday)||12:30:00||Eric Grancher||Moscone South - 309|
|8/12/2011 10:45:47||26660||Oracle XML DB Birds of a Feather (BOF) Session||This session provides you with a chance to strike up a conversation with the Oracle XML DB product team. It presents an overview of what's new with Oracle XML DB in Oracle Database 11g Release 2 and then opens the floor up to a discussion of all aspects of Oracle XML DB and the Oracle XML DB repository. The Oracle XML DB product managers and senior development as well as some Oracle ACEs will be on hand to answer your questions and provide advice and best practices for solving your XML-related issues.||2011-10-03 (Monday)||19:30:00||Marco Gralike, Mark Drake||Marriott Marquis - Golden Gate C2|
|8/13/2011 8:00:38||8046||Oracle Exadata Management for Oracle DBAs||You have heard about it: Oracle Exadata is superfast. Under the covers, it's mostly an Oracle Real Application Clusters (Oracle RAC) Release 11.2 database, but what makes it different? If you are going to support it in your new role as the database machine administrator (DMA), what should you know? In this session, you will learn about the secret sauce that makes Oracle Exadata faster; what you have to learn about the new technology; and how to make sure the technology performs as expected and, more important, what to do when it does not perform well enough.||2011-10-03 (Monday)||11:00:00||Arup Nanda||Moscone South - 309|
|8/8/2011 0:24:39||9547||Getting the Best from the Cost-Based Optimizer||The Cost Based Optimizer (CBO) is getting better and better in each release. However, there are still situations when the prepared execution plan is sub-optimal one. In this presentation we will discuss the available mechanisms like extended statistics, histograms, selectivity and cost definitions for PL/SQL functions and packages, system statistics, execution plan stability, SQL profiles and more. Although the CBO uses some of them automatically there are many cases when one needs to change that automatics by applying proper values and thus helping the CBO to always produce near-optimal execution plans. We will discuss how one can use the right mechanism in order to eliminate the performance bottleneck.||2011-10-04 (Tuesday)||13:15:00||Joze Senegacnik||Intercontinental - Sutter|
|8/9/2011 0:52:56||30000||CERN Achieves Oracle Database Scalability and Performance by Building on NetApp||Looking for solutions that can help you cut IT costs in half? Interested in a flexible and efficient foundation for building a cloud? Want to gain competitive advantage by reducing your time to market? Attend this session to learn more about how storage technologies can help you achieve outstanding cost efficiencies and accelerate your business performance. CERN is one of the world's largest and most respected centers for scientific research in fundamental physics. Learn how NetApp supports critical Oracle environments at CERN, including the database with the highest number of rows in a single table known in production: approximately 2.5 trillion rows in a table supporting the particle accelerator.||2011-10-04 (Tuesday)||10:15:00||Eric Grancher||Novellus Theater|
|8/9/2011 22:42:40||7900||Performance and Stability with Oracle Database 11g's SQL Plan Management||This case study illustrates the use of Oracle 11g SQL Plan Management to safely upgrade a complex and critical Data Warehouse system, ensuring stable performance whilst taking full advantage of optimizer improvements in Oracle Database 11gR2. Subjects covered include - SQL Plan Management fundamentals - Alternative implementation strategies - Controlling execution plan evolution - Using SQL Plan Management to resolve complex performance challenges - The interaction between bind variables, histograms, Adaptive Cursor Sharing and SQL Plan Management.||2011-10-04 (Tuesday)||17:30:00||Doug Burns||Moscone South - 310|
|8/15/2011 1:41:53||6661||Challenges and Changes in the Oracle Database 11g Query Optimizer||With every new release of Oracle Database, the query optimizer is enhanced. Oracle Database 11g Release 1 and Release 2 are no exception to the rule. Specifically, they introduce key improvements in the following areas: indexing, optimization techniques, object statistics, and plan stability. The aim of this presentation is to review the new features from a practical point of view as well as to point out challenges related to them—in other words, to let you know what you can expect from the query optimizer when you upgrade to Oracle Database 11g.||2011-10-04 (Tuesday)||10:15:00||Christian Antognini||Intercontinental - Sutter|
|8/8/2011 9:10:03||6782||Instrumentation: Why You Should Care||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.||2011-10-05 (Wednesday)||11:30:00||Cary Millsap||Moscone South 104|
|8/17/2011 8:13:27||13641||Real-World Performance: The Forklift Upgrade||Today the motivation to consolidate and migrate existing data and applications into the extreme-high-performance database environments of Oracle Exadata and Oracle Exalogic is being driven by a desire to reduce costs and deliver increased performance and service levels to users. The process is often called a forklift migration, because applications and data are simply picked up and lifted onto new platforms. |
In this session, Oracle's Real World Performance group describes how best to maximize your investment and achieve world-class performance and discusses the challenges and compromises that need to be made in the process.
|2011-10-05 (Wednesday)||10:00:00||Andrew Holdsworth||Moscone South - 104|
|8/9/2011 8:35:26||7627||Scaling to Infinity: Partitioning Data Warehouses on Oracle Database||Several errors are common to many data warehouse implementations on Oracle Database. Central to these is the failure to use partitioning or ineffective use of partitioning. Partitioning is crucial and particularly well suited to large data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle Database does partitioning enable, how, and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully gained understanding of data warehousing realities. It provides straight answers to help you utilize Oracle Database features to ensure data warehousing success.||2011-10-06 (Thursday)||12:00:00||Tim Gorman||Intercontinental Ballroom A|
|8/12/2011 12:04:37||8789||Oracle Applications Tuning Panel||This applications performance panel session, sponsored by the Oracle Applications Users Group (OAUG) Database SIG, provides a Q&A forum focused on helping you address your Oracle Applications (Oracle E-Business Suite and Oracle's PeopleSoft Enterprise and Siebel applications) performance- and scalability-related issues. The panel comprises several well-known Oracle Applications performance experts. Topic areas include Oracle Database; the network; and the applications tier, including patching and upgrade performance. Even if you may not have any specific questions, come listen to the panel and leverage known working practices from the experts.||2011-10-06 (Thursday)||9:00:00||Panel including Mark W. Farnham, Michael Brown, Sandra Vucinic, and Ahmed Alomari||Moscone West - 2016|
|8/13/2011 7:58:43||6340||Migration to Oracle Exadata||So you have an Oracle Exadata Database Machine now. How will you move your existing databases into it? There is no single answer—there are many alternatives. This session explains the various options, their pros and cons, and suitable use cases. Finally, the speaker explains the path he followed in his organization and describes the results.||2011-10-06 (Thursday)||15:00:00||Arup Nanda||Moscone South - 103|
|8/17/2011 8:08:39||13640||Real-World Performance Questions and Answers||This is your chance to pose specific questions to Oracle’s Real-World Performance Group. All questions need to be in writing (yes, cards will be provided) and should relate to database performance challenges. In the past, the best questions have been related to specific topics of interest to the audience.||2011-10-06 (Thursday)||10:30:00||Greg Rahn, Graham Wood, Andrew Holdsworth, Bob Carlin & Michael Hallas||Moscone South - 104|