Re: tracing SQL

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 03 Aug 2004 01:16:36 GMT
Message-ID: <Xns9539B9ECC7DAFSunnySD@68.6.19.6>

josepinchero_at_yahoo.com (Jose) wrote in
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.
>

On a session by session basis
ALTER SESSION SET SQL_TRACE=TRUE; You can enable/disable SQL_TRACE for the whole DB, but it requires the DB to be bounced to change state. Received on Mon Aug 02 2004 - 20:16:36 CDT