Re: trace SQL

Hi

turn on SQL_TRACE=TRUE in INIT.ORA
and/or
Alter session set sql_trace true

greetings cor

NB: after that you had a *.trc file on your USER_DUMP_DEST do TKPROF trace_file.trc from more significant data

In article <3328834D.1DE2_at_spark.net.gr>, Papadomichelakis John <michelos_at_spark.net.gr> says:
>
>Hi.
>
>
>How can I get some information of the execution plan
>of a SQL statement?
>
>I want to check if and how my queries take advantage of
>indexes, keys, etc...
>
>thank you
>
>--
>* * * * * Michelos * * * * * *
> http://spark.net.gr/~michelos
> email:michelos_at_spark.net.gr
>* * * * * * * * * * * * * * * *
Received on Tue Mar 25 1997 - 00:00:00 CST