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

• Post for FREE via your newsreader at post.usenet.com ****

"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

You could write a daemon to poll the v$sql for new entries. I can't remember the exact tables, but you can join that table with some other v$ tables to get the Oracle user/ OS User and machine name.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=