LightProfiler is a diagnoses tool for performance analysis of the Oracle databases. It generates detailed resource profile for extended SQL trace files (10046 event), containing information about consuming of response time (by events, by cursors, etc.), data files usage, error analysis (SQL, PL/SQL) and much more. Also it contains tools for additional processing of trace files and for management of database’s sessions.
It converts raw trace file in human-readable format (session resource profile – method R), described session response time by varied statistics. Generated profile also contains valuable information about SQL errors (native and supposed) occured during session runtime.
Features:
- Compatible with Oracle database (version 8-11)
- Generates detailed resource profile both for the session and SQL statement
- Allows to compare generated resource profiles
- Contain tools for database sessions management (monitor state, disconnecting, tracing)
- [advt]Contain tools for additional processing of trace files (extract session data, splitting files)
- Easily extensible
- Cross-platform (distributed in exe, deb and source scripts)
- Has user-friendly GUI
- Free and Open (coded on Python 2.6-3.1)
Be the first to comment