LightProfiler analyzes Oracle extended SQL trace files generated with the 10046 pseudo-event, converting raw data into readable session resource profiles. It reports session and SQL statement statistics, including SQL activity and event distributions, and includes native and inferred SQL errors. Users can compare profiles, monitor or disconnect database sessions, enable tracing, and extract or split trace data.

LightProfiler is a profiling and diagnostic tool for Oracle database administrators and developers who need to investigate extended SQL trace files. It processes traces generated with Oracle’s 10046 pseudo-event and turns their raw contents into a readable session resource profile. The resulting view helps make session activity and response time easier to examine than in a raw trace file.

The profile summarizes resource use at both session and SQL statement level. It organizes timing and activity information into statistics such as SQL statements, event groups, and event distributions, helping users see how a session spent its time. LightProfiler also reports native and inferred SQL errors encountered during the session, which can provide diagnostic clues alongside performance data.

Profiles can be compared to examine differences between sessions or between trace results. The program also includes tools for working with database sessions: users can monitor session state, disconnect sessions, and enable tracing. For trace-file preparation, it can extract session data and split files into more manageable parts before analysis.

These features support investigations ranging from reviewing a single slow database session to comparing resource profiles while diagnosing changes in SQL behavior. Its graphical interface brings profile generation, comparison, session management, and trace-file processing into one tool. LightProfiler is open-source software and is designed for Oracle databases in versions 8 through 11. It is available for Windows, including Windows 7 and earlier listed Windows releases, as well as in other platform-specific and source distributions.

Major Update
processing event for Oracle database 11.2.0.2;processing for LOB% events;added new sections and reports;added new features (copy SQL statement from report to clipboard - thanks ZeroClipboard project);implemented the ability to personalize reports (include title, logo);some bugs fixed;
[ LightProfiler release history ]

Hyperlink code:
Hyperlink and Intro code:
Hyperlink for Forum code:

All LightProfiler reviews, submitted ratings and written comments become the sole property of Windows 7 download. You acknowledge that you, not windows7download, are responsible for the contents of your submission. However, windows7download reserves the right to remove or refuse to post any submission for any reason.

Windows 7 Download periodically updates pricing and software information of LightProfiler full version from the publisher, but some information may be out-of-date. You should confirm all information.
Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for LightProfiler license key is illegal and prevent future development of LightProfiler. Download links are directly from our mirrors or publisher's website, LightProfiler torrent or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, SendSpace, DepositFiles, DivShare, HellShare, HotFile, FileServe or MediaFire, are not used.