You are cordially invited to join the BCOUG at our next Vancouver event on May 25, 2017.
Topic: Advanced Database Diagnostics with the Trace File Analyzer (TFA) Suite
Speaker: Sean Scott, Bodybuilding.com
Most database administrators know that Trace File Analyzer (TFA) is the preferred tool for collecting and preparing files for troubleshooting an issue with Oracle Support, but remain unaware that it is actually a robust suite of tools capable of capturing OS metrics, system changes, insights into alert and log files and automatically collecting diagnostic information to expedite troubleshooting of performance events and deadlocks. It's lightweight, cluster aware and suitable for standalone and RAC databases as well as engineered systems.
This session will go beyond the basic diagcollect command to cover more advanced capabilities of TFA, including system and database log analysis, user management, redaction and repository maintenance. The use of Automatic Diagnostic Repository (ADR) and the SQL Test Case Builder for investigating database and performance issues will also be demonstrated.
Topic: ADOP Patching gotchas!
Speaker: Oti Ometie, Independant Consultant
AD Online Patching(ADOP) as a utility eases the burden of constantly taking an outage to apply an E-Business Suite patch, however with that ease comes a complexity that can only be overcome with experience, creativity and an understanding of the documentation. This session aims to get you across pitfalls you may experience while using the utility. Walk you through scenarios you are likely to face when applying patches to multiple nodes and explain concepts like fs_clone and cleanup_mode = full. The session will be interspersed with interesting anecdotes and challenges I have encountered and resolved.
About the Speakers
Sean Scott - Bodybuilding.com
Sean is a database administrator with over 20 years experience managing Oracle. For 15 years he managed a database consultancy specializing in RDBMS management, backup and recovery, disaster recovery, performance tuning and database design. He's developed high performance solutions to meet the extreme demands of online gaming and e-commerce and designed and implemented high availability solutions for clients including Intuit, the University of Phoenix and the military. He has presented at IOUG/Collaborate, Oracle Open World, OAUG and regional user groups across the US and his work featured in magazines. He currently works for Bodybuilding.com, the world's largest online sports nutrition retailer, overseeing the company's e-commerce database environment.
Oti Ometie - Independent Consultant
Oti is an Oracle Certified Expert (OCE) currently working as an Oracle E-Business Applications DBA. He has worked on 3 continents and has over 14 years’ experience in database design, administration and performance tuning. He has a M.Sc. in Information Systems, and an MBA.
Registration is free and required for security access. Please also note that light refreshments will be provided at the event.