slo | eng

APPM - Abakus Plus Performance Monitor

Oracle database management and performance tuning tool.

It offers similar functionality as Oracle ASH, but it also works on Standard and Express Edition, where Oracle ASH is not permitted.

In APPM, Special attention is dedicated to locking. APPM shows the entire tree of locked sessions - the top most session is the one that is the most responsible for locking the entire chain. It shows all locked objects too.

APPM supports user control (profiles, roles, privileges). There is an entire section for administration of DBMS_SCHEDULER jobs. Space consumption (tablespaces, datafiles) is shown too - including ASM disk groups.

Features

  • overview of problematic SQL statements with current execution plans
  • simple analysis of Oracle trace files
  • control of database performance
  • problems diagnostics
  • performance optimization

References

Documentation / title Document type
User Manual .html | .pdf
Installation Guide .html | .pdf