Download

LightProfiler - profiler and diagnoses tool for Oracle extended SQL trace files, generated by 10046 pseudo-event. It convert raw trace file in human-readable format (session resource profile - method R), described session response time by varied statistics (e.g.: SQL statements, events groups, events dispensings and more...). Generated profile also contain valuable information about SQL errors (native and supposed) occured during session runtime.


Main 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)
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)