Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.
Session Title: Trace File Analyzer (TFA) Suite Deep Dive and New Features
Presenter: Sean Scott
Session Date: August 30th
Session Time: 12:45pm - 2:45pm - Lunch will be served at noon
Oracle's Trace File Analyzer is a robust suite of tools capable of capturing incident diagnostics and database and operating system metrics, identifying system changes and providing analysis of logs to improve troubleshooting and event resolution. It's lightweight, cluster aware and suitable for standalone and RAC databases and engineered systems. Originally designed to supplement log and data collection when creating service requests, TFA has become the preferred tool for collecting files and diagnostics for troubleshooting issues with Oracle Support on Unix and Linux platforms and in mid-2017 added support for Windows systems. The latest version, 126.96.36.199.1, is a milestone release that includes new data collection options, notifications, new cluster and log management features and a new menu-driven interface.
Service requests created via TFA are resolved more quickly and now database administrators working on all major platforms can take advantage of TFA's Service Request Diagnostic Collection (SRDC) to automate and expedite the SR process with Oracle Support Services.
Following a brief introduction to TFA and its use cases this session will discuss installation, upgrade, configuration and customization of TFA, an overview of the command set and new menu options, then dive into demonstrations of:
* The core diagnostic collection (SRDC) features of TFA, from basic to advanced.
* TFA 188.8.131.52.1 new features including the SUMMARY command, log management, incident reporting and the new SRDC options for collecting diagnostics for upgrades and patching.
* Managing the TFA repository.
* Performing full lifecycle health checks within TFA.
* Configuring and using Remote Diagnostic Agent (RDA) integrations within TFA.
* Supplemental tools for analysis, discovery and troubleshooting databases, clusters and environmentsâ€”ORATOP, OSWATCHER and PROCWATCHER.
* Redacting sensitive data within TFA.
* Using the SQL Test Case Builder to aid Oracle Support during investigation of database and performance issues.
Sean has been working with Oracle technologies for over 25 years, spending the last 22 as a database administrator and engineer specializing in database design, performance optimization, disaster recovery, high availability and development. He's an active contributor in the Oracle community, holding leadership roles at the user group level, participating in SIGs and as an author and presenter for regional user groups, IOUG/Collaborate, Oracle Open World and OAUG. His interests include developing tools, integrations and automation to improve and streamline database administration workflow.
After this beginning session, there will be an advanced session. If you already have experience with TFA, we encourage you to come for the second half starting at 3 pm (separate registration).