If you have a problem with your Oracle database performance you have several options and tools for tuning it. If the problem is caused by a wrong execution plan, then you can use Store Outlines, SQL Profiles or SQL Plan Management (SPM) to give oracle more informations for better optimizer decissions and execution plan stability.
You already know the Cluster Health Advisor (CHA) if you are familiar in troubleshooting Oracle RAC Problems.
- It detects cluster and database problems.
- It is started automaticaly and full integrated in Enterprise Manager Cloud Control (EMCC) incedent management.
- Here you find a good youtube video about „How it Works and How to Use It„
Now you can get a standalone, interactive, real-time Grafical User Interface CHA (CHAG)
- for advanced customer use with Oracle RAC Database 12.2+ / GI 18.104.22.168+ (backport not planed for 11g)
Behavior and Analysis
After we upgrades the VMWARE Version of an Actifio Appliance from ESX 6.5 Version 9 to 13 (the actual one) this Linux Guest crashed with VMware core dump again and again. Problem analysis was horrible.
Most time VMware HA had restarted the guest it crashed again if i tried to connect via SSH console. So it was a night mare in problem analysis but much time and a lot of retries later we succeded in scp download the vmcore files.
So we could analyse it and found the reason: