SQL Monitor

SQL Monitor – Freeware to Capture Client SQL Calls

• SQL Monitor – a utility that monitors Oracle, MySQL, and DB2 Client DLL calls, allowing you to capture all SQL calls a program sends to the database via the client DLLs.
• Quest Calibrate – utility to quickly find wasted space and other performance metrics!
• Quest Error Manager - framework that will help you standardize the management of errors in a PL/SQL-based application.
• And many others …

Let’s examine that first freeware – SQL Monitor. Some of you may have already come across SQL Monitor since it used to be included with Toad for Oracle (prior to version 10.5) and was launched from Toad’s UI via the External Tools button as shown in Figure 1.

Figure 1: SQL Monitor used to be included with Toad for Oracle

However SQL Monitor has now been replaced inside Toad for Oracle with a new utility called SQL Tracker, which is launched from the Main Menu -> Database -> Monitor -> SQL Tracker as shown in Figure 2.

Figure 2: SQL Tracker replaced SQL Monitor in Toad for Oracle

Fortunately SQL Monitor is still available as an (unsupported) free utility on Toad World. For those of you less familiar with the SQL Monitor, let me explain what it does.

SQL Monitor is a utility that monitors Oracle, MySQL, and DB2 Client DLL calls, allowing you to capture all SQL calls a program sends to the database via the client DLLs.
In Oracle, for example, this would include Toad for Oracle, SQL*Plus, SQL Developer, etc.
Originally built by the Toad development team to help with troubleshooting, many users have already found this to be an extremely useful utility.

Figure 3: SQL Monitor monitoring Toad for Oracle session SQL

The main window of the program consists of two parts:

Left pane

• Applications Click this tab to see a list of Windows applications that are connected to Oracle, DB2 or MySQL. These may include sqlplusw.exe, Toad, etc.
• Services Click the Services tab to see a list of the Windows NT services that are connected to Oracle. For example, these may include Oracle itself, third-party application servers that run as NT services, etc.

Right pane The right pane contains a tab for each process being monitored. Click the appropriate tab to see the process.

• Monitoring Processes In the left pane, select the process you want to monitor by clicking the checkbox.
  If you want to monitor an application that is not running, you can click the Launch button on the toolbar, or press Control-L. The new application will start and you can monitor it from the time it starts running.

Major features of SQL Monitor include:

• Supports Windows NT/2000/XP
• Supports Oracle clients starting with version 7.3
• Displays SQL statements that come from processes in real-time, eliminating the necessity to turn on tracing and look into poorly formatted trace file
• Allows monitoring NT services
• Displays logon attempts, both successful and unsuccessful (username, password, TNS alias, success)
• Performs syntax highlighting
• Displays values of bind variables for SQL statements
• Shows even statements that fail to execute. Displays Oracle error code and message for those statements.
• Allows you to copy and paste statements from the output to one of your SQL analyzing tools (Toad, SQL Navigator, or even SQL*Plus)
• Monitors applications like Import/Export, SQL*Loader, Server Manager (svrmgrl.exe), as well as applications written with Oracle Forms or Pro*C

To download SQL Monitor, simply click this link .

We would be more than happy for you to tell us what you think about SQL Monitor should you go ahead and try it out. That way, we can look at improving it further.

fonte: