New version - 0.8.00

posted Feb 25, 2012, 11:05 AM by Mid Tier

Released new version of the application - 0.8.00

Change log:
  • Core

    • added ability to import/export xtrc-file via command line

    • import operation was merged with file open

    • implemented processing event for Oracle database

    • implemented processing for LOB% events (LOBREAD, LOBWRITE etc.)

  • Interface

    • added list of recently generated reports

    • implemented call of user-defined commands via toolbar

    • fixed some of navigational bugs

  • Reports

    • added optimization report for SQL statement

    • added section with preamble for trace file in resource profile

    • added section with trace file info in resource profile

    • added feature to copy SQL statement with values of bind variables in clipboard (thanks to ZeroClipboard project)

    • implemented the ability to personalize reports (include title, logo)

    • added section with SQL statements stack (under 5) for snapshots

  • Tools

    • added opportunity to plug additional modules (see Tools)

    • created tool for session management on the database server (session info, turn-on(off) tracing, disconnecting session)

    • created tool for merging trace files (PX) or extracting data for specified session

    • created tool for splitting trace file on several parts with specified size

  • Options

    • implemented calling the preferences dialog with toolbar or with using of short-keys (Ctrl-O - application, Ctrl-P - the active profiler)

    • implemented tool for tracking user-defined values of bind variables

    • changed list of available options

  • Experimental

    • added processing for time markers “*** YYYY-MM-DD...” as event “wait (others)“

    • converting time markers as nanoseconds / 1024

Uploaded new version of the application - 0.8.00 beta

posted Jul 31, 2011, 2:00 AM by Mid Tier   [ updated Jul 31, 2011, 2:02 AM ]

Uploaded new version of the application - 0.8.00 beta 

Major changes: 
  • Core 
    • fixed bugs with processing events for Oracle DB version 
    • added "LOB..." events handling
  • Interface 
    • following sections "R by events", "R by statements", "R by cursors", "Snapshots" now can be viewed using interface
    • user commands now can be called from applications toolbar
  • Reports 
    • in report "Resource profile" added section "Preamble" 
    • in report "Resource profile" added block with information about trace file
    • introduced a new type of report - "Optimization for SQL statement profile"
    • now you can personalise reports (setting title, logo)
    • in report "Resource profile" added ability to copy SQL statement text with values of bind-variables to clipboard. This feature uses library ZeroClipboard and require enabled flash for local folder with reports
  • Settings 
    • changed names for some options
    • for options added experimental section
    • in experimental section added option «ptm» - generate event «wait (others)» for the time markers like as *** YYYY-MM-DD ... 
    • in experimental section added option «ntim» - align time as nanoseconds / 1024
  • Tools 
    • added ability to plug-in additional modules - called "tools"
    • implemented tool «LpCombiner» - application for consolidation of trace files or extracting data for specific session only.
    • implemented tool «LpDbMonitor» - application for monitoring your Oracle server''s sessions. Allows you to start, stop tracing for a specified session or disconnecting it.

P.S. The beta version may contain some bugs, please treat this with understanding. 
P.P.S. Current user guide will be added in the stable version. 

Patch for 0.7.00

posted Mar 23, 2011, 11:55 AM by Mid Tier   [ updated Mar 23, 2011, 11:56 AM ]

Uploaded patch p1 for current version 0.7.00.
* Fixed some bugs (parsing Oracle 11.2 file)

New version 0.7.00 released

posted Feb 17, 2011, 11:44 AM by Mid Tier   [ updated Feb 17, 2011, 11:47 AM ]

  • Added a new report "optimization"
  • Added ability to export / import profile
  • User guide
  • Added use of custom commands
  • Created deb/rpm packages for OS *nix
  • Increased speed of the application
  • Some bugs fixed

Uploaded beta version 0.6.50

posted Dec 14, 2010, 12:14 PM by Mid Tier   [ updated Dec 14, 2010, 12:20 PM ]

  • fixed bugs with parsing event from Oracle 11g
  • fixed bugs in interface
  • added new options
  • added magic function - Parse & Profile
  • added new features - user command (add new item in "Tools" menu with any OS command)
  • some changes in profile (added "Speed" section for datafiles usage, new style of "Common parameters" section)

New version released 0.6.00

posted Nov 10, 2010, 1:03 PM by Mid Tier   [ updated Nov 10, 2010, 1:49 PM ]

  • Added russian support
  • The graphic interface is completely refined
  • Possibility of parallel processing several files is added
  • Algorithms of analysis and report creation are refined
  • Added possibility of report reconstruction without additional parse
  • Changed format of command line options
  • Some bugs fixed...
Also created Russian part of out site

Version update

posted Sep 29, 2010, 11:25 AM by Mid Tier   [ updated Sep 29, 2010, 11:29 AM ]

1) Minor update (some bugs...) for current version 0.5.50
2) *.exe generated on Python 2.7

Visit Downloads page

New version 0.5.50 released

posted Aug 23, 2010, 11:44 PM by Mid Tier   [ updated Aug 23, 2010, 11:56 PM ]

  • Profile:
    • Analysis of events is completely rewritten
    • Calculation of time lost in database calls
    • Calculation of time lost between database calls
    • Calculation of general not considered time 
    • The histogram of allocation of events
    • Grouping of SQL statements on a body/body without literals (with equal dep)
  • Added section of snapshots of SQL statements:
    • Snapshot of SQL statement caused a fetch/exec or parse error
    • Snapshot of SQL statement executed before transaction rollback
    • Snapshot of SQL statement executable before "break/reset from/to client events" (e.g: possible not processed error by call RPC, PL/SQL)
    • Snapshot of SQL statement executable with bind, containing the text "ORA-..."  (e.g.: statement like "insert into user_log (:B1);" where B1 = ' program abort: ORA-01403 no data found at...'
  • The section for variables of binding is refined:
    • Added maximum duration of SQL statement with a specific set of variables
    • Added duration for operations of executing, fetching
    • Output of section as a part of snapshot section 
You can download LightProfiler direct from this site ( visit Downloads ) or from

New version 0.5.00

posted Apr 18, 2010, 9:34 PM by Mid Tier   [ updated May 11, 2010, 10:48 AM ]

New version 0.5.00 available ! (download now !)
  • GUI: new style, new features (see Gallery) Attention: ttk-module needed for python 2.6 (if you use app source) 
  • profile: code optimized
  • profile: output in monolithic file or separate statements in created directory (default)
  • profile: added database action dispensions
  • common: some bugs fixed
    and more...

New version available!

posted Feb 1, 2010, 6:20 AM by Mid Tier   [ updated Feb 1, 2010, 8:38 PM ]

Version 0.4.01 available for downloading (python source and windows installer)
  • profile: added bind section
  • other: slightly increased perfomance
  • other: some bugs fixed
  • GUI: some bugs for Windows and Linux hosts fixed

1-10 of 13