|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
Location: Blogs
John Pocknell's Blog
|
|
| JohnPocknell |
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.
|
|
| Permalink |
Trackback |
Comments (13)
|
By FilipeSilva on
Friday, July 10, 2009 |
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 Pockers on
Friday, July 10, 2009 |
Hi Filipe,
It's the same thing. |
|
|
By berendtium111 on
Wednesday, August 05, 2009 |
| I just tried using SQL Monitor via TOAD (9.7.2.5). It keeps hanging up with "Not Responding". |
|
|
By Pockers on
Wednesday, August 05, 2009 |
Hi,
Which Windows OS are you using and which applications are you trying to monitor?
John |
|
|
By berendtium111 on
Wednesday, August 05, 2009 |
| 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 Pockers on
Wednesday, August 05, 2009 |
OK thanks. Let me check with my dev team whether we are ok with Oracle Web Forms.
John |
|
|
By Deon on
Tuesday, August 11, 2009 |
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 Pockers on
Tuesday, August 25, 2009 |
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 |
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 BenG on
Wednesday, August 26, 2009 |
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 dclamage on
Tuesday, December 01, 2009 |
| 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 Pockers on
Wednesday, December 02, 2009 |
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 |
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 |
|
|
|
|
|
|
|
|
|
|