| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: windows application to show sql being executed by a client
windows application to show sql being executed by a client programhow can I do it for unix processes ? ...
Bp
BBabu,
Like he said, talk directly to the developer ... read the README.eng file.
Thanks Jacques for finding this product ... I already like it and am in touch with the author with some issues. Raj
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
From: BanarasiBabu Tippa [mailto:btippa_at_ORsoftware-india.com]
Sent: Friday, February 07, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: windows application to show sql being executed by a client
Hi Jacques
The tool is very good and usefull. I suggest try to include explain plan for every SQL statement captured.
Thanks
Banarasi
-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]
Sent: Thursday, February 06, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: windows application to show sql being executed by a client
Pretty cool...
A future Quest product ??? ;)
.... Just wondering... :)
- Kirti
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com]
Sent: Wednesday, February 05, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Subject: windows application to show sql being executed by a client progra
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/
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: BigP INET: big_planet_2000_at_hotmail.com 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).Received on Fri Feb 07 2003 - 11:34:04 CST
 |
 |