APPM - Oracle Database Performance Monitor

Performance monitor and workload sample collector for Oracle Standard Edition.

APPM collects, analyzes and displays historical and current performance statistics of an Oracle Database. It collects performance data such as wait events and active session history. Collected data is stored in central repository and is used to identify and analyze performance issues like, for example, identifying a resource intensive SQL statement.

There are two editions, a Free Edition and a commercial offering known as Enterprise Edition.

Highlights:

  1. Central Repository
    Compare performance statistics between different environments and time frames.
  2. Graphical frontend for variety of performance related tools
    Such as sql tracing, sql patching, statspack, etc...
  3. Minimal production footprint
    No data is stored on production database.
  4. Oracle Standard Edition compatibility
    Provides alternative for ASH & AWR functionality which is only available in Enterprise Edition