Take a look at Pete's paper. The information provided by the Oracle trace
facility is far in advance of MSSQL traces.
The tool provided by Oracle (tkprof) is not as nice as SQLProfiler, but in
my view that isn't actually that important given what the typical uses of
tracing are.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
"Jose" <josepinchero_at_yahoo.com> wrote in message
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 Wed Aug 04 2004 - 00:18:34 CDT
