You can start a trace on the session by using
dbms_system.set_sql_trace_in_session, it will produce
a trc file in user_dump_dest. Then do a tkprof on the
file.
- "Daiminger, Helmut" <Helmut.Daiminger_at_gedas.de> a
icrit : > Hi all!
>
> Is there a way (on the server side) to trace (or
> spool into a file) all the
> SQL statements that a specific client sends to the
> database server?
>
> This is 8.0.5 and 8.1.5 on NT and Digital Unix.
>
> Thanks,
> Helmut
> --
> Author: Daiminger, Helmut
> INET: Helmut.Daiminger_at_gedas.de
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Received on Fri Jun 09 2000 - 03:59:25 CDT
