Thanks Tim Gorman; great presentations!
Arizona Oracle User Group (AZORA)
October 20, 2016 (Thursday)
When: Thursday October 20, 2016 – 12:30 pm to 2:30 pm
Where: Republic Services – 3rd Floor Conference Room
14400 N 87th St (AZ101 & Raintree), Scottsdale, AZ
Change In Plans – Tim Gorman comes to Phoenix! Stephen Andert had a sudden business commitment come up making it impossible for him to speak at Thursday’s meeting.
Fortunately, Tim Gorman of Delphix will be coming from Denver to speak instead. Tim is an internationally-renowned speaker, performance specialist, member of the Oak Table, Oracle Ace Director, Rocky Mountain Oracle User Group (RMOUG) President, author, and technical consultant at Delphix (many thanks to Delphix for supporting AZORA and letting Tim fill in on short notice). The topic is still troubleshooting performance, but it’s a different presentation.
Title: RDBMS Forensics: Troubleshooting Errors using ASH (Active Session History)
Topic categories: Active Session History, troubleshooting, database internals
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 two case studies on 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 for DBAs, are also useful diagnostic tools for everyone, particularly developers.
Attendees will learn a forensic, empirical approach to troubleshooting and see a demonstration of a complex troubleshooting task resulting in a non-intuitive but empirically sound resolution. This presentation should make you think of Active Session History as something like queryable diagnostic information captured and stored within the database.