A graphical desktop tool for visualizing Active Session History (ASH) data from Oracle and PostgreSQL databases.
ASH Viewer is a desktop application that visualizes Active Session History (ASH) data from Oracle and PostgreSQL databases. It provides graphical charts and drill-down capabilities to help database administrators monitor performance, identify bottlenecks, and analyze session activity without requiring Oracle's licensed Diagnostic Pack. The tool stores ASH data locally and emulates ASH for databases that lack native support.
Database administrators, performance engineers, and developers who manage Oracle or PostgreSQL databases and need cost-effective performance monitoring tools, especially those without access to Oracle Enterprise Manager's Diagnostic Pack.
ASH Viewer offers a free, open-source alternative to Oracle's proprietary performance monitoring tools, providing similar Top Activity visualization and drill-down analysis. It uniquely supports ASH emulation for PostgreSQL and Oracle Standard Edition, stores data locally for offline analysis, and includes robust security features for database credentials.
ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides a Gantt-like chart similar to Oracle Enterprise Manager, allowing real-time and historical session monitoring without the Diagnostic Pack license, as shown in the README's Top Activity screenshot.
Captures and stores active session data locally for Oracle Standard Edition and PostgreSQL, filling the gap where native ASH is unavailable, as explained in the 'How it works' section.
Uses embedded Oracle Berkeley DB to store ASH data on the local machine, enabling offline analysis and historical review without dependency on database server storage.
Offers AES-256 encryption and Windows DPAPI for secure credential storage, with clear recommendations in the Security section to avoid weak alternatives like PBE.
Only supports Oracle and PostgreSQL, excluding other popular databases like MySQL or SQL Server, which restricts its use in mixed environments.
Includes deprecated PBE encryption and weak storage options like configuration files, which the README explicitly advises against using, posing security risks if misconfigured.
Requires users to manually download and configure JDBC drivers for each database, adding complexity to the initial setup compared to all-in-one solutions.
ASH Viewer is an open-source alternative to the following products: