LightProfiler is an application for 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), data files usage, error analysis (SQL, PL/SQL) and much more. It contains tools for additional processing of trace files (extract session data, splitting files) and for management of database's sessions (disconnecting, tracing, monitor parameters, blocking locks, events).
Features: 1) Compatible with Oracle database (version 8-11). 2) Generates detailed resource profile both for the session and SQL statement. 3) Allows to compare generated resource profiles. 4) Contain tools for database sessions management (monitor state, disconnecting, tracing). 5) Contain tools for additional processing of trace files (extract session data, splitting files). 6) Easily extensible. 7) Cross-platform (distributed in exe, deb and source scripts). 8) Has user-friendly GUI. 9) Free and Open (coded on Python 2.6-3.1).