|Timestamp||Session ID||Title||Abstract||Date||Time||Location||Speaker(s)||Company||Session URL||Session URL2|
|7/29/2010 5:44:01||S318615||IOUG: Oracle Indexing Tips Tricks and Trapss||This presentation looks at various tips, tricks, and traps regarding the use and implementation of Oracle indexes. Topics include indexes and constraint management; how different types of indexes are needed for different constraint options; and how constraints, in turn, influence the cost-based optimizer (CBO). Next the session discusses subtle differences between unique and nonunique indexes and why these differences matter. It looks at tricks that make B-tree indexes extremely useful even if columns have few distinct values, as few as just one value. It also looks at how NULLs can actually be indexed effectively in B-tree indexes. Finally, it considers various problems with index monitoring and why the results can't be trusted.||2010-09-19 (Sunday)||12:30:00||Moscone West L2, Rm 2005||Richard Foote||Australian Federal Government||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=318615||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S318615|
|7/29/2010 19:45:26||S316189||Under the Hood of Oracle Clusterware 2.0: Grid Infrastructure||This presentation examines the internals of Oracle Clusterware to provide cluster administrators with a clear path for troubleshooting common issues based on understanding all components, their role, and their interactions, and the reasons behind implementing this solution. It also introduces the Oracle grid infrastructure that arrived with Oracle Database 11g Release 2. It explains what improvements were made and why they were needed. You will find out that the grid infrastructure has been seriously redesigned to enhance stability, manageability, and flexibility as well as data safety. Learn how to get the most out of Oracle's grid infrastructure.||2010-09-19 (Sunday)||13:30:00||Moscone West L2, Rm 2001||Alex Gorbachev||Pythian||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=316189||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S316189|
|7/28/2010 20:27:34||S318372||OAUG Database SIG||The OAUG Database SIG is holding a brief business meeting, after which this session includes an open discussion of the impact of database desupport dates on users of Oracle ERP applications. It is followed by a presentation on tips and tricks for minimizing downtime during the database upgrade process.||2010-09-19 (Sunday)||15:00:00||Moscone West L3, Rm 3008||Michael Brown, Kaberi Nayak, Mark Farnham||Colibri Limited, Mitre Corporation, Rightsizing, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=318372||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S318372|
|8/1/2010 10:23:11||S318494||Messed-Up Apps: a Study of Performance Antipatterns||Cary Millsap presents examples of applications that perform poorly and the patterns that result in reliably poor performance, no matter what development language you're using.||2010-09-19 (Sunday)||15:00:00||Moscone West L2 2014||Cary Millsap||Method R Corporation||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=318494||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S318494|
|7/29/2010 5:46:21||S319069||Indexing New Features in Oracle11g R1 and R2||This session discusses and analyzes in some detail many of the exciting new features introduced in Oracle Database 11g Release 1 and Release 2 in terms of indexes. Among the topics: • Invisible indexes and why they can be so extremely useful (and dangerous) • New CBO capabilities for using index-related statistics (the hidden new feature) • The CHANGE_DUPKEY_ERROR_INDEX and IGNORE_ROW_ON_DUPKEY_INDEX insert hints (and why they're unique) • Index segment creation on-demand capabilities • Index segment creation on demand capabilities • Online index creation and rebuild enhancements • Bitmap join indexes on index-organized tables • Creation of virtual columns without function-based indexes.||2010-09-20 (Monday)||14:00:00||Moscone South, Rm 303||Richard Foote||Australian Federal Government||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319069||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319069|
|7/28/2010 13:36:39||S317166||Real-World Performance Panel Session||This session is your chance, via written questions, to ask a panel stacked full of real-world performance talent all those questions to which you've just wanted to get a simple answer. You can write your questions on postcards available in the meeting room. Please focus on performance topics and not system debugging!||2010-09-20 (Monday)||17:00:00||Moscone South, Rm 306||Graham Wood, Greg Rahn, Michael Hallas, Andrew Holdsworth||Oracle||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=317166||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S317166|
|7/30/2010 8:19:04||S315043||Evidence-Based JD Edwards Best Practices/Oracle Real Application Testing 11g||WTS, a leader in managed hosting and disaster recovery services on Oracle's JD Edwards EnterpriseOne, developed a set of best practices for JD Edwards EnterpriseOne on Oracle Database and other database platforms. With the availability of Oracle Real Application Testing 11g, WTS undertook an effort to validate those practices by repeatedly subjecting test systems to real-life customer workloads under various database configurations. It collaborated with its customers and Oracle experts Blue Gecko to develop test scenarios and perform iterative testing with database replay. It not only empirically validated its best practices but also developed new recommendations based on test results. This session covers the project approach and findings.||2010-09-20 (Monday)||17:00:00||Moscone South 236||Jeremiah Wilton||Blue Gecko, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=315043||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S315043|
|8/29/2010 22:26:41||S315110||Optimizing Servers for Oracle Database Performance||Oracle on Modern Intel Servers. Topics include Nehalem EX, SMT and NUMA.||2010-09-20 (Monday)||17:00:00||Moscone South Rm 302||Wallis Pereira, Kevin Closson||Intel / Oracle||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=315110||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S315110|
|8/1/2010 10:22:06||S315449||Thinking Clearly about Performance||Creating high-performance as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable. This paper describes those principles, linking them together in a coherent journey covering the goals, the terms, the tools, and the decisions that you need to maximize your application’s chance of having a long, productive, high-performance life. Examples in this paper touch upon Oracle experiences, but the scope of the paper is not restricted to Oracle products.||2010-09-21 (Tuesday)||12:30:00||Moscone South 306||Cary Millsap||Method R Corporation||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=315449||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S315449|
|7/28/2010 13:34:34||S317165||Oracle Database Performance Secrets Finally Revealed||Have you ever seen a real-world database performance engineer solve Oracle Database performance problems? Wouldn't you like to know all the performance secrets they know? In this session, real-world database performance engineers will go over many of the performance secrets they use to get extreme performance out of the Oracle Database. Not only will they tell you about these secrets but they will demo them for you as well. This session is specifically for those wanting to advance their database performance knowledge and experience.||2010-09-21 (Tuesday)||14:00:00||Moscone South, Rm 103||Greg Rahn, Michael Hallas||Oracle||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=317165||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S317165|
|7/28/2010 20:36:01||S319101||Managing Transactions with Disappearing Indexes||If a system gets information that drives transaction processing, it can be necessary to follow the transaction detail through several stages of processing or processing steps that may vary, depending on the source data. When processing of a given row is complete, there are more efficient means than deletion to remove it from consideration in continuing passes of transaction processing. This session covers one method, using a "disappearing index," that is particularly useful and efficient. This method takes advantage of the fact that index column sets that become completely null are eliminated from the index, so that at a steady state, a fast full scan of the index to find candidate rows for further processing is fast and efficient.||2010-09-21 (Tuesday)||17:00:00||Moscone South, Rm 304||Mark W. Farnham||Rightsizing, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319101||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319101|
|7/28/2010 20:43:51||S319052||Applications Performance Panel||This applications performance panel session, sponsored by the OAUG DBSIG, 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.||2010-09-22 (Wednesday)||11:30:00||Moscone West L2, Rm 2011||Mark Farnham, Michael Brown,Ahmed Alomari,Sandra Vucinic||Rightsizing, Inc.,Colibri Limited, Cybernoor Corporation, VLAD Group, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319052||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319052|
|7/29/2010 3:14:56||S319105||Interfacing with Your Database via Oracle XML DB||The Oracle XML DB development team developed protocol server functionality and added it to the known |
listener functionality. Based on the shared-server architecture, new methods have become available for moving
data in and out of the database. Since then, this feature has enabled many new possibilities such as local
support of sharing Oracle Application Express without requiring a Web technology. This session shows ways to
make maximum use of these protocols, such as HTTP(s), FTP, and WebDAV.
It explains and demonstrates new ways of sharing your data via Oracle Database 11g Native Database Web
Service functionality, via PL/SQL or XDB Repository Events. The session also covers what you can do with
out-of-the-box Oracle XML DB functionality.
|2010-09-22 (Wednesday)||11:30:00||Hotel Nikko||Marco Gralike||AMIS||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319105||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319105|
|7/28/2010 14:59:14||S316683||Join Techniques||This presentation explains how the query optimizer joins multiple sets of data to each other. First it explains the operation of the basic join methods (nested loop, hash join, and merge join) and the possibilities we have to influence their performance. Then it presents some more advanced optimization techniques such as the transformations applied to joins, and partition-wise joins.||2010-09-22 (Wednesday)||13:00:00||Moscone South, Rm 304||Christian Antognini||Trivadis||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=316683||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S316683|
|7/30/2010 11:03:00||S313251||Stats with Confidence||Collecting new optimizer stats is a double-edged sword: it might improve the performance but, equally likely, break it. In this session, learn how to 1. Confirm that the stats will produce accurate plans *before* the optimizer sees them. Publish the stats after this check to prevent unnecessary risk. 2. Use SQL plan management (SPM) to create multiple baselines and choose the best plan among them--especially useful with canned applications. 3. Use pending stats with the SQL performance analyzer to see the impact of the new stats on the entire application, not just a few queries. 4. Roll back stats to a previous set, and export the pending stats to another database for testing. The session features live demos of all these points.||2010-09-22 (Wednesday)||16:45:00||Moscone South 104||Arup Nanda||Starwood||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=313251||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S313251|
|7/29/2010 19:49:08||S315988||How-To: Implement Oracle Automatic Storage Management Successfully||Oracle Automatic Storage Management has been one of the most successful new features since Oracle Database 10g, but migrating data to another storage platform represents several challenges and Oracle Automatic Storage Management adds new flavors to DBA responsibilities. If you are evaluating this technology or are on the migration path, this session will help you plan your migration without having to discover Oracle Automatic Storage Management from scratch and will answer many questions such as:|
* What software do I install before I can use ASM?
* Is ASM a free product?
* Should I use ASM mirroring or hardware mirroring?
* What is the best striping to use with ASM?
|2010-09-23 (Thursday)||9:00:00||Moscone South, Rm 200||Alex Gorbachev||Pythian||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=315988||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S315988|
|7/28/2010 14:07:48||S316311||Query Transformations||One of the first operations performed by CBO during the SQL statement optimization phase is query transformation. The goal of query transformation is to generate semantically equivalent form of SQL statement which produces the same results, but differ in performance. In the presentation we will discuss the most common transformations like sub-query un-nesting, predicate move around, and join predicate push-down into view, simple and complex view merging and others.||2010-09-23 (Thursday)||12:00:00||Moscone South Room Rm 300||Joze Senegacnik||Senegacnik Joze - Raziskovanje v naravoslovju||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=316311||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S316311|
|7/30/2010 8:20:31||S315044||High-Performance Oracle Database 11g in the Amazon Cloud||With so many firms claiming that their technology is part of the cloud, it can be hard to separate the marketing-speak from real technical solutions. After reviewing the types of architectures that are known as cloud computing, this session focuses on the Amazon Elastic Computing Cloud (EC2). With live examples and demos, it shows various ways to manage and deploy computing resources for Oracle technology. Cloud computing is a new architecture with unique deployment, performance, and management challenges. The session shows how those deploying Oracle Database on the Amazon cloud can overcome those challenges and create a high-performance Oracle-technology-based service with Amazon?s dynamic, scalable, professionally managed architecture.||2010-09-23 (Thursday)||12:00:00||Moscone South 306||Jeremiah Wilton||Blue Gecko, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=315044||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S315044|
|7/30/2010 11:05:53||S314207||Analyzing Application Performance in RAC||Tracing a session--via SQL Trace or the 10046 event--is one of the fundamental tools for performance diagnosis, but it becomes a challenge in an Oracle Real Application Clusters (Oracle RAC) environment with many sessions connecting to and disconnecting from multiple instances. In addition, the use of connection pools that can have data from multiple applications makes it impossible to pinpoint a specific application. This session shows how to use automatic enablement of tracing, combining the traces across multiple instances via trcsess, filtering out the relevant applications from a set of traces, and analyzing via tools such as tkprof and Trace Analyzer, available free from Oracle. It includes live demos and covers Oracle Database 11g.||2010-09-23 (Thursday)||13:30:00||Moscone South 104||Arup Nanda||Starwood||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=314207||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S314207|
|7/28/2010 20:49:06||S319071||Physical Ordering of Data: Is It Ever Useful?||Some operations, small ones such as lookup lists and large ones such as batch jobs and reports, can perform better if the data's physical order matches the predominant order of use. When is it worthwhile to try this ordering? How does automatic segment space management (ASSM) affect the ability to physically order data? An expensive mission to periodically physically order all of your data in the best-possible order for the queries you expect to run on it is silly. But if you verify that a one-time complete or periodic partial physical ordering of some of your data will have a reasonable cost nearly certain to be greatly exceeded by lower cost of projected queries against a constrained resource, it isn't silly. Learn more in this session.||2010-09-23 (Thursday)||15:00:00||Moscone South, Rm 303||Mark W. Farnham||Rightsizing, Inc.||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319071||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319071|
|7/29/2010 19:51:19||S316417||When Oracle Databases Meet the Cloud, It Might Rain||With all the cloud computing hype, Oracle Database technologists are seriously considering infrastructure as a service( IaaS) and platform as a service (PaaS) vendors for their database needs. In this session, learn how you can leverage cloud computing offerings with Oracle databases and see whether it's easy to host Oracle databases in the cloud. Can they perform well? What are the licensing implications? You will see that cloud hosting isn't always cost-efficient for running the whole Oracle database, but even then, there are several very effective ways to offload some database components such as offsite backups, disaster recovery options, external SecureFiles storage, and data archiving.||2010-09-23 (Thursday)||15:00:00||Moscone South, Rm 307||Alex Gorbachev||Pythian||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=316417||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S316417|
|8/2/2010 8:38:09||S319046||CERN Achieves Database Scalability and Performance with Oracle and NetApp||This presentation highlights CERN's four-year experience running more than 80 Oracle databases on NetApp storage. CERN shares details of its successful deployment of Data ONTAP 8 to provide performance, scalability, and large-scale Oracle Real Application Clusters (Oracle RAC) database support for database applications--some of which generate database growth in excess of 3.5 TB per month--for the operation of the LHC accelerator. In addition, CERN highlights the benefits of Oracle Database 11g direct Network File System (NFS), provides tips and tricks for running databases on NFS, and offers feedback on its deployment of Oracle VM on NetApp storage systems.||2010-09-23 (Thursday)||15:00:00||Moscone South, Rm 270||Eric Grancher and Steve Daniel||CERN and NetApp||http://www.eventreg.com/cc250/sessionDetail.jsp?SID=319046||http://search.oracle.com/search/search?group=Oracle+OpenWorld&q=S319046|