RE: windows application to show sql being executed by a client
Title: windows application to show sql being executed by a client program 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:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: windows application to show sql being executed by a client
Title: windows application to show sql being executed by a client program 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 Jamadagni MIS, ESPN Inc. 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:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 3:49 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: 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. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re[2]: windows application to show sql being executed by a client
Hello Banarasi, I'm Sergey Ten, the one that wrote the tool Jacques is referring to. Thanks for the feedback. I'd also like to see some functionality like that, but Quest Software already has SQLab that does it (means I'd have to compete against my own employer). Besides, my tool does not establish a connection to Oracle, which allows it to monitor multiple processes, and establishing connection and dealing with plain table is necessary for that kind of features. Glad to hear you like the tool! Friday, February 7, 2003, 12:48:50 AM, you wrote: BT Hi Jacques BT The tool is very good and usefull. I suggest try to include explain plan for BT every SQL statement captured. BT Thanks BT Banarasi -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergey Ten INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: windows application to show sql being executed by a client
Title: windows application to show sql being executed by a client program how can I do it for unix processes ? ... Bp - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, February 07, 2003 5:09 AM Subject: RE: windows application to show sql being executed by a client 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 Jamadagni MIS, ESPN Inc. 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:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 3:49 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: windows application to show sql being executed by a client
Lindows?? -Original Message- how can I do it for unix processes ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Re[2]: windows application to show sql being executed by a client
Sergey, Does your utility monitor connections through ODBC interface(not OCI or OO4O)? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 07, 2003 11:09 AM Hello Banarasi, I'm Sergey Ten, the one that wrote the tool Jacques is referring to. Thanks for the feedback. I'd also like to see some functionality like that, but Quest Software already has SQLab that does it (means I'd have to compete against my own employer). Besides, my tool does not establish a connection to Oracle, which allows it to monitor multiple processes, and establishing connection and dealing with plain table is necessary for that kind of features. Glad to hear you like the tool! Friday, February 7, 2003, 12:48:50 AM, you wrote: BT Hi Jacques BT The tool is very good and usefull. I suggest try to include explain plan for BT every SQL statement captured. BT Thanks BT Banarasi -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergey Ten INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re[2]: windows application to show sql being executed by a client
For now it's NT platform only (NT/2000/XP) Friday, February 7, 2003, 9:34:04 AM, you wrote: B how can I do it for unix processes ? ... B Bp -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergey Ten INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re[4]: windows application to show sql being executed by a client
ODBC is just another layer on top of Oracle client - eventually it will call OCI functions. So does OO4O, I believe. So I don't see why not. Let me know if you have problems. Friday, February 7, 2003, 11:24:35 AM, you wrote: IN Sergey, IN Does your utility monitor connections through ODBC interface(not OCI or IN OO4O)? IN Igor Neyman, OCP DBA IN [EMAIL PROTECTED] -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergey Ten INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: windows application to show sql being executed by a client
Title: RE: windows application to show sql being executed by a client If anything it will be incorporated into an existing Quest Product. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Pretty cool... A future Quest product ??? ;) Just wondering... :) -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] 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.
RE: windows application to show sql being executed by a client pr
Title: windows application to show sql being executed by a client program 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-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: 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.
RE: windows application to show sql being executed by a client pr
Title: RE: windows application to show sql being executed by a client pr Well I guess the cat is out of the bag! I didn't think that TOAD with SQL Monitor had been released yet. Yes, an (earlier?) version of his app was chosen to be incorporated in TOAD. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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. -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] 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.
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
windows application to show sql being executed by a client progra
Title: windows application to show sql being executed by a client program 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.
RE: windows application to show sql being executed by a client
Title: windows application to show sql being executed by a client program Pretty cool... A future Quest product ??? ;) Just wondering... :) - Kirti -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: 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.