As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue.
- 1513912.2 – TFA Collector — Install on all database servers to collect critical diagnostic information.
- 1268927.2 – ORACHK — New version comes out every quarter with patch updates and sometimes new features. A must run utility on all database servers. Take care of the recommendations to avoid an outage in the future.
- 301137.1 – OS Watcher — captures performance information from the Operating System.
- 215187.1 – SQLT — diagnose poorly performing SQL statements.
- 1500864.1 – oratop — utility similar to the unix OS utility top which gives an overview of database performance.
In addition to the above tools, MOS also provides several troubleshooting tools such as ORA-600, ORA-1578, ORA-2730x, ORA-3137, ORA-4030, ORA-4031, ORA-7445, RAC Node Eviction and so on. All of these tools are documented in MOS note 559339.1 Diagnostic Tools Catalog.