9:00 am - 12:00 pm
Thinking Clearly About Performance
Cary Millsap, Accenture Enkitec Group
When I wrote Optimizing Oracle Performance with Jeff Holt back in 2003, my goal was to define a reliable, teachable method for fixing software performance problems. After a few months, I began to notice a trend in how people were responding to it. Many of the questions had started to repeat themselves: “Sure, ‘fixing’ problems is important, but how can I ‘prevent’ them?” “The book was fun, but of course I didn’t read the whole chapter on queueing theory; is that stuff really important, anyway?” “Where does capacity planning fit in?” ...And, sadly, I continued to see people make the same mistakes that we had tried to warn people about in the book.
One day, in response to a sequence of questions to which I had responded hundreds of times (at least it seemed), I sat down to write the simplest summary I could of everything I thought people needed to know about software performance. My goal was to connect all the topics in the software performance domain that people needed to understand. To my surprise, the paper just flowed out in a coherent document that really wasn’t too long or too difficult to read. It has been downloaded more than 22,000 times from our method-r.com web site, won numerous awards at user groups, and was published in ACM Queue and Communications of the ACM. This workshop will get you thinking clearly about performance. It is absolutely my favorite material I’ve ever presented. I think that’s because it touches upon almost everything I’ve ever done as a professional.
Cary Millsap is a teacher, consultant, writer, software designer and developer, and Oracle software performance specialist, currently at Accenture Enkitec Group. He also owns and operates Method R Corporation, a company that provides software tools and education services to firms including Fortune 100 companies. Cary has presented at hundreds of events and his blog is read by thousands of people each month. He is published in journals including Communications of the ACM and wrote Optimizing Oracle Performance, for which he and co-author Jeff Holt were named Oracle Magazine’s 2004 Authors of the Year. His latest book is The Method R Guide to Mastering Oracle Trace Data. Cary worked for Oracle Corporation throughout the 1990s, where he founded and grew three consulting practices, and educated thousands of users in Oracle technology. In 1993, he was named the Oracle USA national consultant of the year, and in 1996 he was awarded Oracle Consulting’s top honor for the Americas Division. When he left Oracle in 1999 to become an entrepreneur, he was a Vice President in charge of the US$20M System Performance Group.
10:00 am - 4:00 pm
Enterprise Manager Cloud Control, from Installation to Cloud
Erik Benner, Mythics, Werner De Gruyter, Oracle Corporation, Courtney Llamas, Oracle Corporation
Enterprise Manager Cloud Control (OEM 12c) delivers centralized management functionality for the complete IT infrastructure, including systems running Oracle and non-Oracle operating systems, database and applications. In this hands-on lab, students will learn about the OEM 12c architecture, and how to install a simple instance to test drive the features. The workshop will cover the following:
• the concepts and different components of the OEM 12c Architecture
• the steps involved in the installation of OEM 12c
• installation of the OEM 12c Agent
• system monitoring features to monitor Oracle environment
• event notifications
• monitoring various targets using OEM 12c, including an Oracle 12c Database, Oracle ZFS Storage and Weblogic Application servers.
• define and monitor services and service levels
• creating administrators and roles.
Workshop Requirements: The entire lab is delivered using Oracle Virtual Box, so a notebook with at-least 8G of memory is required, and 16G of ram is recommended. The students also need to have full admin privileges on the notebook, and have the following software downloaded before the class. (Note, I will update URLs a week before the class)
• Oracle Linux 6.x
• OEM 12c for Linux
• Oracle Database 12c for Linux
• Oracle Weblogic Server.
Erik Benner is an Oracle ACE, a published author and an Enterprise Architect with Mythic's Enterprise Architecture & Technology Solutions Group. He has worked with Oracle and Sun Systems since the mid 90s, and is experienced with most of the core Oracle technologies. Erik leverages his experience with systems like SuperCluster, T and M series, OVCA, ODA and ZS3 storage to provide holistic designs that combine database, middleware, and virtualization technologies. He often speaks at Oracle events, is the SIG Leader of the IOUG Solaris SIG and is actively involved with the IOUG RAC SIG, and the IOUG and OAUG OEM SIGs.
Courtney Llamas started as an Oracle DBA and ended up managing one of the largest Oracle Enterprise Manager environments used for critical monitoring and management of more than 3,000 databases. She now shares her experience and knowledge with customers of the Strategic Customer Programs team for EM helping them follow best practices. Using her work with customers and operations experience, she contributes to best practices, whitepapers, blogs, webcasts, and presentations.
Werner de Gruyter is a respected Enterprise Manager expert who frequently presents at conferences on the internals of EM. He co-authored the Oracle Enterprise Manager 10g Handbook and is the developer of the much used EMDIAG tool kit. As an Architect in the Enterprise Manager Strategic Customer Programs team, he works with the world's top customers and implementations of EM.
1:00 pm - 5:00 pm
Demystifying App/DB Performance by Example
Vlado Barun, Oracle Corporation
As the amount of data multiplies, our user base expands, the feature set grows, and systems become more complicated. While these events put even more importance on identifying the root cause of a performance issue, the process itself becomes more difficult. This workshop is for Developers/DBAs/Architects who want to stop the madness of applying band-aids to "fix" recurring production issues. Using live demos of real-world customer performance issues, attendees will learn techniques and methods to:
• identify and understand the root cause(s) of sub-optimal performance
• find an appropriate solution
• maximize performance/scalability out of your existing hardware
We will cover non-trivial scenarios for both OLTP and BI systems, including (but not limited to) optimizing SQL, connection pools, Parallelism, ETL and using practical High-performance Data Processing Algorithms. This is an interactive workshop and lively discussion is expected as we demystify App/DB Performance, by example.
Vlado Barun is part of the Real-World Performance Team at Oracle Corporation, focusing exclusively on optimizing database performance and scalability for large, mission-critical systems. Prior to joining Oracle, Vlado assisted a variety of organizations as DB Engineer, DBA, Database Architect and Manager of Database Development & Operations.
1:00 pm - 4:00 pm
StreetSmarts® Upgrading to E-Business Suite R12.1 and 12.2: How-To, New Features, Functionality and Better Ways to Get Things Done!
Bill Dunham and Michael Barone, OATC, Inc.
This workshop will take a step-by-step approach of upgrading to Release 12.1 and 12.2 of Oracle EBS Applications. We will cover project planning, getting to the first working R12 instance, remediating CEMLIs (customizations), functional challenges, and defining, designing, building, and executing testing. Attendees will leave this workshop with knowledge of performing an upgrade, an understanding of issues and problems, documentation to navigate the upgrade and confidence to execute an R12 upgrade within their organization.
Bill Dunham, founder and principal owner of OATC, Inc., is a well -known Oracle Applications and Technology consultant having worked with Oracle products since 1985 and Oracle EBS Apps since 1991. Bill has worked in many IT and project capacities over the years mostly focusing as a EBS Program/Project Manager, Architect, Technical/Functional Lead, QA Manager and client advocate. Bill has presented papers at many local and regional Oracle Application Users Group (OAUG) events and at Oracle OpenWorld (OOW) and is the author of numerous articles and several books.
Michael BaroneMichael Barone has 25 years of IT experience and 16 years of Oracle Applications (E-Business Suite) DBA experience. Most recently, he has worked on installing, setting up, upgrading and administering the production, test, and development databases for major international organizations, federal/state/local government agencies, and manufacturers and upgrading existing Oracle Databases and Oracle Applications. Michael has extensive hot/cold E-Business Cloning and backup/restore/disaster-recovery experience on multiple E-Business versions.