Jul
7
Written by:
John Pocknell
Tuesday, July 07, 2009
You may already be familiar with the Toad World Exclusive Freeware area from where you can download and use really useful utilities such as the PL/Vision Code Library and the Freeware version of Quest Code Tester for Oracle.
Now there are two more which I’d like to introduce you to – one which has been around for many years and the other a relative newcomer.
The first one is called SQL Monitor. Some of you may have already come across it since it’s included with Toad for Oracle and can be launched from Toad’s UI via the External Tools button.
Launching SQL Monitor from Toad for Oracle
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.
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 . 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 or go to the Exclusive Toad World Downloads page from the Downloads tab on the home page.
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.
Please post a comment at the end of this blog.
13 comment(s) so far...
Re: Introducing a New Free Utility Download – SQL Monitor
Hi
what is the difference Between that and the one shipped for instance with SQL Navigator?
(It seems a new version but besides that is the same app, right? (same funcionality))
Thanks
By FilipeSilva on
Friday, July 10, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi Filipe,
It's the same thing.
By Pockers on
Friday, July 10, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
I just tried using SQL Monitor via TOAD (9.7.2.5). It keeps hanging up with "Not Responding".
By berendtium111 on
Wednesday, August 05, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi,
Which Windows OS are you using and which applications are you trying to monitor?
John
By Pockers on
Wednesday, August 05, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
XP Pro. I had clicked on frmbld.exe, toad.exe and frmweb.exe. Just clicking on the tabs on the right caused monitor to lock up. Sometimes it doesn't lock up but then when I go to my running web form, that screen is locked up.
By berendtium111 on
Wednesday, August 05, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
OK thanks. Let me check with my dev team whether we are ok with Oracle Web Forms.
John
By Pockers on
Wednesday, August 05, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi John,
I work almost entirely (99.99999999.....% in Clinical Data Validation (both CT and OC) . I see very little discussion on this topic. I can use some advice. (I cannot connect to OL fron this email account).
Thanks for your patience.
Deon
By Deon on
Tuesday, August 11, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi Deon,
This sounds like a general question on Toad. Could you please email me direct (john.pocknell@quest.com) and describe what requirements and issues you are currently having and I can advise you on the best solution.
Thanks,
John
By Pockers on
Tuesday, August 25, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Response to berendtium111:
I checked with my dev team and the SQL Monitor is very unlikely to work with Oracle Web Forms since it's a very old utility and doesn't receive the updates a commercial product like Toad does.
Regards,
John
By Pockers on
Tuesday, August 25, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi, I try to monitor Services on a Win 2K3-SA SP1 running under a local user account with local administrator permissions. Unfortunately I can only see the services running under Local System.
Running the SQLMonitor.exe with these local user account credentials does not result in a solution. Nor starting the service from within the SQLMonitor.exe does not work.
How can I monitor Services running under another account then Local System?
Best Regards,
Leo
By BenG on
Wednesday, August 26, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
I recommended SQL Monitor to one of our QA folks for testing our application written in VB6 and C# on .Net 3.x. SQL Monitor crashes the application every time.
By dclamage on
Tuesday, December 01, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi Leo,
Sorry about the late response! Our dev team were able to re-create this issue but as yet not been ablle to rectify it.
I will update you if there are any developments.
John
By Pockers on
Wednesday, December 02, 2009
|
Re: Introducing a New Free Utility Download – SQL Monitor
Hi dclamage,
I'm sorry SQL Monitor is causing you problems. I have contacted our development team for advice, but I suspect it will be that SQL Monitor was not designed to operate and therefore hasn't been tested on .Net.
I'll update you when I get a response.
Thanks,
John
By Pockers on
Wednesday, December 02, 2009
|