LightProfiler - profiler and diagnoses tool for Oracle extended SQL trace files, generated by 10046 pseudo-event. It converts trace file in detailed report, that displays resource profile, usage of database files, event's timeline, information about SQL errors (real and supposed) and much more. Also you can compare two or more resource profiles to estimate your optimization efforts.
Main features:
1) Free and Open (run on Python 2.6-3.1 )
2) Cross-platform (distibuted in exe, deb, rpm and source scripts)
3) User-friendly interface
4) Unicode support
5) Can process trace files from different version of Oracle databases (8-11)
6) Generate detailed resource profile for session and SQL statement
7) Allow to compare resource profiles from few trace files
|