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: ODBC Trace

Re: ODBC Trace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 13 Feb 2002 00:41:04 +1100
Message-ID: <3c691b8a$0$12796$afc38c87@news.optusnet.com.au>


Yup. Standard things like selecting from v$sqlarea. Using Log Miner (for DML only). Even execute dbms_system.set_sql_trace_in_session (x, y, true) would do the trick (x and y being the SID and SERIAL# of the session as determined from v$session). It's always possible to see exactly the commands issued by any session. Nothing to do specifically with ODBC.

Regards
HJR "Peter K" <P.Kloo_at_mylius.com> wrote in message news:a4av7d$1dqoac$1_at_ID-43420.news.dfncis.de...
> Hi,
> is there a tool for tracing commands generated by the client's ODBC-driver
> in an Oracle8i environment (Win2k/nt4) ?
> Regards,
> Peter
>
>
>
>
Received on Tue Feb 12 2002 - 07:41:04 CST

Original text of this message

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