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 126.96.36.199+ (backport not planed for 11g)