Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Brute Force Quickie Developer needs minor assistance finding code tool . . .

Re: Brute Force Quickie Developer needs minor assistance finding code tool . . .

From: Burt <burtpelt_at_bellsouth.net>
Date: Tue, 24 Dec 2002 19:55:47 -0600
Message-ID: <pm7O9.61297$C06.17015@news.bellsouth.net>


There is great tool for Oracle Developers/DBAs called TOAD (Tool for Oracle Application Development) that might help. A lot of ex-SqlServer developers and old-time Oracle Developers/DBAs at our site really like this tool.

You can get a copy of a addon-tool (SqlMonitor.EXE) that comes with the buy version of TOAD that will show every SQL statement passed from the client to the server on the current PC . This is a client tool, as opposed to other ways of doing this (sql trace - which create server trace files on the Unix server).

Another catch - the client PC must have Oracle8 (or 8i) installed for this to work. Even though your server is version 7, you should be able to run Oracle8i client software on the PC you install TOAD to.

You could download the TOAD trial and see for yourself....

It is a simple Windows install . The SqlMonitor.Exe is in a ZIP file with a DLL. Note: There is a freeware version of TOAD but I don't think you can run the SqlMonitor.Exe tool with it.

A page for links to download the evaluation copy of TOAD and freeware version is available at http://www.toadsoft.com/downld.html

The OCISPY tool is available by:
- Unzip a zip file ( www.toadsoft.com/ocispy.zip ) to your TOAD installed directory (probably C:\Program Files\Quest\TOAD or something like this - it's the directory where TOAD.EXE resides). - Then, just run the SqlMonitor.Exe program to see ALL Sql passed by any client/server tool such as TOAD, sqlplus, ODBC type tools, etc. . - Hit the refresh while in SqlMonitor to see any programs you start after starting SqlMonitor.Exe .

"Syster" <syster_at_sys.com> wrote in message news:a4oc0vgfcjrl7c3k4iskhpkkc20le88s95_at_4ax.com...
>
>
> Hello,
>
> I am new to Oracle. I've been programming various client and web
> based utilities for MS SQL for years, now we have an Oracle server and
> I can't proceed in the same fashion of brute force coding that I used
> to do.
>
> The hospital I work for buys turnkey solutions, and I work on the
> "workarounds". For MS SQL, I use trace to find any information
> regarding how the client software accesses the database. I use that
> information to build my add-on utilities, report and query tools.
>
> My next project is to build a automatic faxing system for our
> laboratory database. I built the last one for our MS SQL lab system,
> but we've since upgraded to Oracle. It some version 7 Unix server
> that I'm not very familiar with.
>
> Here's the problem. I need a tool that will trace the sql statements
> that pass from the client to the server, similar to SQL Trace for MS
> SQL. I need to be able to filter what gets traced, say by IP Address
> or perhaps the workstation name etc.
>
> I would greatly appreciate your wisdom.
>
>
> Sincerely,
>
> Tony Garrido
Received on Tue Dec 24 2002 - 19:55:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US