Re: Oracle SQL Tace tool

From: David <darussell_at_msn.com>
Date: Sun, 26 Apr 1998 16:15:17 +0100
Message-ID: <eIV05YSc9GA.226@uppubnews03>

You need to set SQL_TRACE = TRUE in the init.ora then all SQL issued to the server will go to the user_dump_dest trace files. If you wish to collect this on a single session, issue alter session set sql_trace = true; Another option is to pick the SQL up in TopSessions (Enterprise Manager).

Regards
David Russell

Guido Le Lorrain wrote in message <6htlrn$q7g_at_news-central.tiac.net>...
>Hello
>
>Has anyone out there heard of or is using an Oracle trace tool that will
>allow a developer to see what SQL statements are being executed. I am aware
>that some Oracle ODBC drivers do have a trace option but I'm not using
ODBC.
>I'm actually using BDE native calls so I need a tool that actually captures
>the SQL statements passed to the Oracle database at the SQL Net level.
>
>I would be grateful for any sort help.
>
>Thanks
>
>Guido
>
>
>
Received on Sun Apr 26 1998 - 10:15:17 CDT