How to monitor Oracle RAC with DBTuna

The best way to monitor Oracle RAC with DBTuna is to configure an agent for each node of the RAC cluster. This way you are able to view the performance of each node in isolation including the CPU consumption of the node hardware, by configuring DBTuna's OS monitoring.

The installation is as normal, with the exception of the Oracle SID which is often confused in an Oracle RAC set up. Whereas normal RAC clients connect to the cluster via the service name, DBTuna needs to connect to each node individually via the local instance name. To find out the local instance name you need to connect via sqlpls (or equivalent) and run the following command:

SQL> show parameter instance_name;

Once you have done this, you should have no problems starting your agents, and will have comprehensive deep-dive monitoring!

Happy monitoring!