Presentation Title: Variance Analysis, Profiling and Trending Using ASH and AWR Data
Presentation Abstract: Active Session History (ASH) and Automatic Workload Repository (AWR) are two powerful tools to help an organization diagnose performance issues. Though each tool comes with custom reports, they provide a limited view and only show single points in time. Using the data automatically gathered, you can write custom reports to examine trending, create alerts for known issues, and track changes to your systems. Dan reviews the ASH and AWR data structures and some of the nuances for reporting before moving into generating reports for activity and event trending, creating custom alerts for unusual activity, and comparing performance in light of system changes.
Biography: Daniel Fink is a Senior Consultant/DBA with Arisant. He started as a DBA on Oracle 7.0.16 running Parallel Server on OpenVMS and has experience on major Unix platforms and releases up to 11G. He is a member of the OakTable network, BAAG, and BAARF. He has presented on a wide variety of Oracle performance and diagnosis topics, including Developing A Disciplined Approach to Diagnosis, Oracle Performance for Developers, and Tracing Logical I/O.
To sign up, please visit our registration page.
We hope to see you in March!