Re: getting a simple trace of sql statements executed

On Jan 16, 8:07 am, Mark Harrison <m..._at_pixar.com> wrote:
> I would like to get a trace of all the sql statements
> executed in my program. I don't want to coalesce the
> statements, such that the report tells me "select 2+2
> from dual" was executed 20 times for a total time
> of X seconds.
>
> Rather, I want to see a list of the statements in the
> order they were executed, so I can correlate them
> with my source program and ensure that my logic
> is being executed as I expected.
>
> Many TIA,
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

type tkprof help=y
and refer to
aggegrate=yes|no

Other than that *please* RTFM prior to asking here.

-- 
Sybrand Bakker
Senior Oracle DBA