Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: tracing SQL

Re: tracing SQL

From: Antoine BRUNEL <antoinebrunel/yahoo.fr>
Date: Sun, 8 Aug 2004 04:46:02 +0200
Message-ID: <411593ea$0$17473$79c14f64@nan-newsreader-07.noos.net>


Hi from Paris

have a look at DBMS_SYSTEM.SET_EV

for event 10046...

cdlt

"Jose" <josepinchero_at_yahoo.com> a écrit dans le message de news:b9dff992.0408020827.156401b5_at_posting.google.com...
> Hello,
>
> I'm a bit new to Oracle. We have Oracle 9 on Win2000.
>
> I'd like to trace (ala SQL profiler) the fully formed SQL in and out
> of our database, from a start and end time (and optionally, some info
> on execution time)
>
> how do i do this? i cant see to find good oracle support for this
> sort of thing.
>
> Thanks.
Received on Sat Aug 07 2004 - 21:46:02 CDT

Original text of this message

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