Lab128
 Tools for Advanced Oracle® Tuning and Monitoring
128 Consulting LLC 
New Hampshire, USA 
Oracle silver partner logo 

About

Lab128 info in other languages:

Miscellaneous:

Free Downloads.

No additional Oracle licenses required to use this freeware software! No OEM, or Performance/Diagnostic packs needed.

Lab128 Freeware version.
The ultimate tool for Oracle real-time monitoring.

Lab128 freeware is an important tool for DB administrators, developers, and performance specialists. It shows what Oracle instance is doing at the moment, how resources are used, how it is executing long running queries, and many other Oracle internal functioning. This is valuable both in production and development environment. When developing or troubleshooting large queries, this tool is indispensable because it can uncover ongoing performance problem without waiting for the query to complete.

To run Lab128 freeware: download the zip file below; uncompress into some directory; then start lab128fw.exe digitally signed file.

LAB128 freeware,
version 1.6.5.0

9-Jun-2014
lab128-v1650fw.zip Length: 4,314,941 bytes
SHA-1 = 2da0e29b7b850d84622e00e0dcc145f984380b6d
MD5 = ec4bda77ee20408b613bc97b1a5c9ad3

This free version is based on Lab128 Advanced Monitoring and Troubleshooting tool. Table below shows differences between these two versions. And remember, if your needs outgrow the scope of real-time monitoring, you can download Lab128 with free trial period.

FeaturesLab128 freewareLab128 premium version
Number of monitored instances2unlimited
Sessions windowcheckcheck
Tablespaces windowcheckcheck
Locks and locked objects windowcheckcheck
Transactions windowcheckcheck
Other real-time monitoring screenscheckcheck
Reportscheckcheck
SQL Centralcheckcheck
Clusterware Commandercheckcheck
SQL Explorer / SQL Statistics History check
Single SQL History check
Activity Explorer / Active Session History check
Single Session History check
Buffer Explorer check
Saving Performance data into the file check
Creating Reference Loads and comparing loadscheckcheck
Stage and Fix SQL Statementcheckcheck

Click here to see System requirements and supported Oracle versions.


Oracle 10053 Trace Viewer (v10053.exe)

Oracle 10053 trace event provides information on how the Cost Based Optimizer (CBO) came to its decision (the final execution plan). This is often helpful troubleshooting "bad" SQL execution plan. Unfortunately, 10053 trace files can be enormous. This free viewer will help you navigate quickly to the most important sections of the trace file. Also it highlights section headers and formats the transformed final query for enhanced readability, see screenshot.

Start this digitally signed executable file v10053.exe, then open trace file using standard Open File dialog. Alternatively, indicate .trc file in the command line:
v10053.exe filename

Please send your comments and suggestions to:  general AT lab128.com

V10053, version 1.6.3.0
Oct-2013, Freeware
Digitally signed exe file: v10053.exe Length: 1,806,048 bytes

File integrity and Digital code signing

We are using a code signing certificate from Comodo. The EXE files are signed using Microsoft Authenticode technology. In order to check file integrity and authenticity, download it first (don't open it), then in Windows Explorer right-click on the file and select Properties. Check under "Digital Signatures" to verify that the name of the signer is 128 Consulting. If you use Windows XP, SP2 or later, you will be presented with the signature automatically once the executable is started. For more details, see How Code Signing Works.

  Copyright © 128 Consulting LLC