Skip to Main Content

Oracle Autonomomous Health Framework Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours.

Header container

September 24, 2019

Exploring Cluster Health Advisor GUI
Click on SHOW MORE for video highlights! Products and functionality covered in the Autonomous Health Framework's (AHF) family include the Applied Machine Learning-based products of Cluster Health Advisor (CHA), Hang Manager (HM) and Trace File Analyzer (TFA), as well as performance management and continuous availability functionality in ORAchk/EXAchk, Memory Guard, Cluster Health Monitor Cluster Verification Utility and QoS Management.

Klaus Thielen joins me for this session covering the Cluster Health Advisor GUI and its functionality to drill down into the analysis and evidence of database and cluster node issues.

03:40 - What is Oracle’s goal in developing the Cluster Health Advisor GUI (CHAG)?
04:50 - Since it was internal, why was it made available to Oracle customers?
05:40 - What does this tool look like ?
08:10 - I see the Nodes and DB are listed separately. Are they correlated?
09:12 - What is the difference between using it in real-time and offline?
11:09 - How do I get this “mdb” file to analyze?
12:00 - Could you provide some insight in what direction will be with CHA and MGMT DB on Exadata environments?
13:20 - Can you walk through a typical use scenario of CHAG?
19:00 - You mention “predicted values” for each metric. Can I see what these are?
23:18 - Is the predicted time based upon historic data of the system itself? Are there any hard ranges on top of this?
24:33 - What with systems that gradually start getting higher wait events?
26:56 - What are some other scenarios that CHAG is useful fo?
31:13 - How can I tell which Problems were happening most frequently?
34:53 - Where can I get the CHA GUI?
35:45 - What is involved in installing the CHA GUI?
37:44 - Which DB versions does CHA GUI support?
39:00 - Does this tool require the GIMR to be deployed?
40:18 - What happens now that the GIMR is optional?
43:37 - There is another CHA tool called CHA Finding Explorer. How do they compare?
45:00 - Can CHAFE and CHAG work together?
46:00 - Is it necessary to run the CHA at server side or we can run this at a client machine?

Subscribe to give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Autonomous Health Framework you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.


Your Experts
Mark Scardina
Mark Scardina, Director of Product Management - Oracle Autonomous Health    
20+ years at Oracle, raised on XML, matured on Security, and procreated on Autonomous Health. Currently responsible for Oracle Autonomous Health Framework (AHF) which encompasses the applied machine learning-based products, Cluster Health Advisor (CHA), Hang Manager (HM) and Trace File Analyzer (TFA), as well as the performance management and continuous availability functionality in Cluster Health Monitor (CHM), Cluster Verification Utility (CVU), Oracle Health Check (ORAchk/EXAchk), Memory Guard (MG), and Oracle Quality of Service Management (QoSM).
Klaus Thielen
Klaus Thielen, Architect
30+ years at Oracle, joined as sales consultant in Germany, specialized in performance management, did benchmarks and proof of concepts, was responsible for the relationship between customers in Germany and the Development organization. Joined the Cluster Health Advisor (CHA) team as a virtual team member, later as a real team member. Presently responsible for data generation for visualization, integration of CHA into the Autonomous Heath Framework and life cycle management – working from Germany.