Solving Performance Issues
Tuesday, August 19, 1:00 p.m. MT
2001 Blake St.
Denver, CO 80205
Looking to stay on top of your career and latest industry trends and techniques while staying close to home? The IOUG Master Class Series is coming to Denver to help you do just that. IOUG invites you to participate in this one day class which includes complimentary registration and the opportunity to attend the evening's Rockies game vs. the Kansas City Royals!
Performance is one of the hottest topics affecting Oracle technologists. In this one-day Master Class you will explore methods to quickly and efficiently solve performance issues affecting your database. Through real world examples and discussions from Oracle experts you will return to work with a plan of attack for any future performance issues - saving your company time and money.
Those that attend the S1 & IBM Flash presentation immediately following the Master Class will receive a complimentary ticket with food & beverage to the evening's ballgame! Enjoy networking with your fellow Oracle professionals right along the first base line!
If you are interested in attending the baseball game please choose the appropriate registration type below - please note that seats are limited and IOUG will contact you to confirm your seat upon registration. We ask that you do not reserve a ticket for the game unless you are positive you can attend. While this event is complimentary, your attendance directly affects future IOUG events.
IOUG Master Class: Solving Performance Issues
1:00 p.m. - 2:00 p.m. -
Detailed AWR Analysis
Speaker: Mike Ault, Oracle Guru, IBM
In this presentation the top-down method of Oracle tuning using the AWR report is covered. The attendees will learn:
- The different sections of the AWR report
- What wait events are most important and how to use that to determine the next section of AWR to review
- What the SQL sections of the report tell you
- When to analyze latches, locks and mutexes
- What are enqueues and what do they tell you
- What the physical segment sections are used for
- What statistics are important
- Important initialization parameters
2:15 p.m. - 3:15 p.m. - EM12c Performance Features
Speaker: Kellyn Pot'Vin, Consulting Member of Technical Staff, Strategic Customer Program, Oracle
AWR and ASH are the cornerstone of performance data in the database and used heavily in the new Enteprise Manager 12c. Understanding the power of the data, knowing how to use the advanced features, and knowing how to solve challenging problems through the UI's amazing performance features is crucial to any administrator when you need to resolve issues quickly.
With Release 4 of EM12c, (aka 188.8.131.52) a slew of new features, including the much anticipated AWR Warehouse have emerged. This granted users the ability to view AWR in a whole new way and retain it indefinitely for any source database. This, along with many of those newly enhanced features will be the topic of this talk along with demos and a Q&A.
The attendee will leave the session with clear knowledge of the following features:
- The power of the ADDM Comparison Report
- How Search SQL, a long-time, but little known feature can offer answers with AWR data that's been missing from your analysis
- How the SQL Performance Analyzer can deter from performance impacts
- Database Replay- Reviewing the plays to isolate and identify problems
- AWR Warehouse: What is it? Why is it important? How does it work?
3:30 p.m. - 4:00 p.m. - Customer Case Study
Speakers: Lance Teel, National Account Manager, S1 IT Solutions and David Bannister, Director of Global Infrastructure & Operations, Aon
A technical discussion on how one of the largest insurance services companies in the world was able to increase their application response time 10x by using Flash technology. We will review how they were able to utilize Flash to enhance the performance, efficiency, reliability and design of their essential enterprise applications.
This session includes a deep dive into a case study on how Aon, one of the largest Insurance companies in the world, lowered front end response time from 30 m/s to 3 m/s and avoided 20,000 hours in reprogramming.
4:15 p.m. - 5:00 p.m. - Solving Performance Issues Roundtable
Bring the entire day together with a panel focused on solving performance issues. This is an opportunity to bring your real world examples, questions and performance challenges to the speakers and attendees. The panel will consist of the customer and oracle speakers who will discuss performance topics such as:
- Organizational challenges and opportunities related to performance
- How performance issues affect DBAs
- Most challenging performance issues technologists face and how these can be addressed
- Tips & tricks on solving performance issues
- Relate to performance challenges and solutions from fellow attendees and bring real world examples back to your office
S1 & IBM Flash Event
Attend S1 & IBM Flash presentation and receive a complimentary ticket with food & beverage to the evening's Rockies vs. Royals Game! Enjoy networking with your fellow Oracle professionals right along the first base line!
5:30 p.m. - 6:00 p.m. - Flash Presentation|
Speaker: Mike Ault, Oracle Guru, IBM
Is your Infrastructure Ready for Flash? Searching for extra processing speed? Join S1 IT Solutions and IBM to take a fresh look at your storage. You may find your server is waiting for your current storage system to access your business critical data. IBM FlashSystem provides proven solutions for driving significant performance and efficiency improvements in storage infrastructures.
Find out how IBM FlashSystem can give you up to:
You are cordially invited to join an evening of fun and discover how S1 & IBM have helped businesses like your answer the critical question: Is your infrastructure ready for Flash?
- 45x performance improvement
- 10x more durability
- 115x better energy efficiency
- 315x superior density
- 19x more efficient $/IOPS
6:40 p.m. - First pitch
Meet Our Speakers
Following a six year Navy enlistment in the Nuclear Navy riding submarines, Mike began working with computers in 1980 programming in Basic and Fortran IV on the PDP-11architecture in the nuclear industry. During Mike’s nuclear years he worked with PDP, IBM-PC, Osborne and later VAX-VMS and HP architectures as well as with the Informix and Ingres databases. Since 1990 Mike Ault has worked with a variety of industries utilizing Oracle both in house and as a consulting talent. Mike got extensive Flash experience as the Oracle Guru for Texas Memory Systems. Mike transitioned to IBM as the Oracle Guru for the STG Flash group when IBM purchased TMS in 2012.
Mike has published over two dozen Oracle-related books including the 7.0, 8.0, 8i and 9i versions of his Oracle Administration and Management with Wiley, the Oracle8 Black Book and Oracle DBA OCP ExamCram series (for versions 8 and 8i) with Coriolis and multiple titles including Oracle9i RAC and Oracle10g Grid and RAC with Rampant Technical Press.
Mike has written articles for Oracle, Select, DBMS, Oracle Internals and several other database-related magazines. Mike is also a highly sought after keynote speaker and expert instructor for local, regional and international Oracle conferences.
Kellyn Pot’Vin is a member of the Oak Table Network and was an Oracle ACE Director until joining Oracle as the Consulting Member for the Strategic Customer Program, a specialized group of Enterprise Manager specialists. She specializes in environment optimization tuning, automation and creating systems that are robust and enterprise level. Kellyn works almost exclusively on mult-TB size databases, including Exadata and solid state disk solutions and is known for her extensive work with both the Enterprise Manager 12c and its command line interface. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content. She is the co-author on a number of technical books, hosts webinars for numerous technical groups, including All Things Oracle and has presented at Oracle Open World, HotSos, Collaborate, KSCOPE, along with other US and European conferences. Kellyn is a strong advocate for Women in Technology, (WIT) citing education on topics regarding stereotypes and presenting opportunities early as the path to overcoming challenges.
With his military background, Lance knows the value of leveraging a network to bring the best resources together. And for him, nothing beats the thrill of determining the most effective technology solution for a customer to drive business value — except maybe also making some friends along the way.
Lance has a bachelor’s degree in engineering from the U.S. Air Force Academy and multiple industry certifications. As a captain in the Air Force working on technology and satellites, he served in the Middle East and Bosnia. In addition to working with Cisco Systems and NetSolve Remote Networking, he also worked with NASA in placing Air Force tests on the space shuttle.
David Bannister is the Director of Global Infrastructure & Operations at Aon eSolutions where he is responsible for a number hosted SaaS solutions for the risk management industry. Prior to joining Aon in 2009, David spent 6 years working for a boutique consulting firm specializing in Oracle database deployments in the public sector. David holds a BS in Information systems from Kennesaw State University, is married with three children and enjoys short walks on long beaches."
Cancellations: The IOUG reserves the right to cancel any event with at least 24 hours prior notice to attendees.