We used the following monitoring tools in this solution:

  • Oracle Automatic Workload Repository

    • (AWR) reports with Automatic Database Diagnostic Monitor (ADDM). AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes for Oracle Database. This tool can generate reports for analyzing Oracle performance. ADDM analyzes data in AWR to identify potential performance bottlenecks. For each of the identified issues, it locates the root cause and provides recommendations for correcting the problem.Find more information on Oracle AWR here

  • Oracle dynamic performance (V$) views and Oracle Alert log to check for errors

  • Linux system activity report (SAR)

    • Linux SAR helps collect and evaluate a variety of information regarding system activity. With performance problems, SAR also permits retroactive analysis of the load values for various subsystems (CPUs, memory, disks, interrupts, network interfaces, and so on). Find more information on Linux SAR here

check-circle-line exclamation-circle-line close-line
Scroll to top icon