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.
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.
|Features||Lab128 freeware||Lab128 premium version|
|Number of monitored instances||2||unlimited|
|Locks and locked objects window|
|Other real-time monitoring screens|
|SQL Explorer / SQL Statistics History|
|Single SQL History|
|Activity Explorer / Active Session History|
|Single Session History|
|Saving Performance data into the file|
|Creating Reference Loads and comparing loads|
|Stage and Fix SQL Statement|
|Capture and store Execution plans|
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:
Please send your comments and suggestions to:
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.