Re: How to monitor SQL*NET from the Client

You can look at the v$sqlarea or v$sqltext dynamic views in order to determine the SQL that is being executed. You have to join these two views to find out who is doing the querying (which session). I believe that you also can do a SQL*Trace on the particular session that is running the Oracle Forms application. Someone correct me if I'm wrong.

hope this helps,
mm

zaq42_at_yahoo.com wrote:

> We are tasked with porting part of an Oracle Forms / Oracle database to
> the web (against the same db). We have the appropriate DB account and
> have a copy of the forms application. We've also identified a handful
> of reports we want to mimmick on the web.
>
> The problem is that the database is very complicated and we're having a
> tough time identifying the tables/procedures that the reports are
> using. The source code isn't available to us.
>
> Is there a way we can monitor SQL requests coming out of SQL*NET? How
> about other tricks to see Oracle Forms db requests? Our last resort is
> to inspect the actual TCP/IP packets.
>
> Thanks for any insight!
>
> Zaq
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 31 2001 - 12:06:22 CST