RE: windows application to show sql being executed by a client

Nice tool but the major draw back that I find it it only monitors the applications you kick off. It would be nice if it would monitor like the TOAD monitor does. I like the fact that it scrolls the previous command and you can look back and see what happens that you did not know or understand. This tool showed the source of a strange command as a command generated by the VB ADO as discussed in another message.  You Guys are right on with the correct answers. Ron

>>> David.Schmoldt_at_gazettecommunications.com 02/06/03 01:34PM >>> Looks pretty nice. Real similar in concept to TOAD's SQL Monitor, but adds
the option of seeing the values of bind variables, formatting the SQL, watching processes, etc.  

Worth the download, IMHO.  

Dave

-----Original Message-----
Sent: Wednesday, February 05, 2003 7:59 PM To: Multiple recipients of list ORACLE-L

Hello list members.
A colleague of mine has written a small Windows client utility that allows
you to view the SQL statements being issued by another client application.
The utility has to be running on the same machine as the other client application.

I use it myself pretty often instead of turning on tracing a session.

His description says:
- 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 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, SQLoader, Server Manager (svrmgrl.exe), as well as applications written with Oracle Forms or Pro*C
• Supports Oracle clients starting with version 7.3
• It's FREE!

He has told me that I can publicize it on the list. All he asks is some
feedback / bug reports.
Here's the link:
http://www.fastalgo.com/ <http://www.fastalgo.com/>

P.S. You should send the feedback to him and not to me.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).