This Thursday, Feb 20, I will be giving a full day of free Oracle performance classes. Remember the serve the best lunch ever at the Oracle conference center . It’s top class!
Invite your developers to attend the free ADF Developer Lab. Details in the NoCOUG Journal.
Dear friend,NoCOUG member Gwen Shapira told us that when she was a mid-level DBA, she was attracted to NoCOUG when she heard that rock star Oracle guru Kyle Hailey was going to speak at a NoCOUG conference. That was the first of many NoCOUG conferences that Gwen attended. She gave her first Oracle presentation at NoCOUG the following year and her career began growing in leaps and bounds. Soon she was speaking all over the country and eventually became an Oracle ACE Director. You can read her interview in Oracle Magazine
.The winter conference next Thursday is supercalifragilisticexpialidocious because Kyle Hailey is conducting a full-day DBA boot camp. You can spend the whole day listening to Kyle’s insights into the mysterious inner workings of Oracle Database. Let’s all take this opportunity to learn from Kyle. RSVP here
The board members and volunteers of your favorite Oracle user group
DBA Boot Camp with Kyle Hailey—11:00–5:00
Kyle Hailey was a principal designer for the Oracle Enterprise Manager performance pages. He is a member of Oracle Oak Table and the co-author of Oracle Insights: Tales of the Oak Table, and he was a technical editor of Oracle Wait Interface. He holds a patent in the area of database performance diagnosis and has been a speaker at Hotsos, NOCOUG, RMOUG, NYCOUG, and Oracle World; he also organizes Oaktable World. Kyle teaches classes around the world on Oracle performance tuning. Currently Kyle works as a performance architect at Delphix, along with industry-leading software, kernel, and filesystem designers, to take corporate data management to a new level of agility.
Lies, Damned Lies, and I/O Statistics—11:00–12:00
Given a description of gas dynamics and the atmosphere, you would be hard pressed to forecast tornadoes. The term “emergence” refers to the phenomena of surprising behaviors arising in complex systems. Modern storage systems are complex and full of emergent behavior that makes forecasting application I/O performance fiendishly difficult. In collaboration with Matt Hayward, Adam Leventhal, and others, Kyle Hailey has learned some rules of thumb for how to make accurate I/O performance forecasts. You’ll learn about forecasting, benchmarking, and analyzing I/O performance in this talk.
Visual SQL Tuning—1:00–2:00
The load on the database is caused by SQL; thus it makes sense that performance bottlenecks are caused by poorly performing SQL statements. We will follow a solid step-by-step method for analyzing, understanding, and tuning these problem SQL statements though Visual SQL Tuning (VST) diagrams. VST is a method of laying out the tables and joins of a query graphically to indicate key features of the query in the graphics. Through the VST, you’ll learn how to quickly visualize any coding errors in the query; discover flaws in the underlying database schema; and most important, find the best execution path through the query.
Learn about ASH Masters, a GitHub repository of queries against Average Active History (ASH). Learn about ASH math, average active sessions, and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty-gritty of a performance bottleneck’s internal workings. ASH is the most powerful source of performance analytic data in Oracle. Querying ASH can be difficult, with a number of pitfalls, but the rewards of correct data analysis of ASH make it the most powerful tool a DBA has for performance analysis. Learn how to query ASH correctly, and learn where to get powerful prewritten ASH queries.
Agile Data: Revolutionizing Database Cloning—4:00–5:00
Database virtualization allows the same datafiles to be shared by multiple clones, allowing almost instantaneous creation of new copies of databases with almost no disk footprint. Along with storage efficiency, database virtualization allows agile management of database copies. The data agility eliminates bottlenecks in development by removing wait time for creating database environments, allows developers to have their own full copy of the database, and provides QA and UAT with immediate copies of the development environments for testing. This presentation will compare and contrast different types of database virtualization from Oracle 11 CloneDB, Oracle 12c Snap Clones, 12c Snapshot Manager Utility, Oracle ZFS Appliance, Delphix Appliance, VMware Data Director, NetApp Snap Manager for Oracle, and EMC. We’ll explain how database virtualization works and discuss the advantages and disadvantages of different approaches.