Re: tracing SQL

Jose wrote:

> 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.

The ability in Oracle goes far beyond what SQL Server can do. But, as you might expect, it requires some effort on your part.

The first thing you have to do is read up on the subject.

Look up the following topics at:
http://tahiti.oracle.com
and/or
http://www.psoug.org (click on Morgan's Library)

EXPLAIN PLAN
TKPROF
TRACE
TRACE ANALYZER

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)