Hi,
You can use sql trace and than tkprof for example:
alter session set sql_trace=true
run your query
alter session set sql_trace=false

Best Regards
Krystian Zieja / mob
>
>
> Hi GURUS,
>
> I am not a DBA. But I would like to know how to know the
> performance of a sql query. How to get the statistics? So that I can
> improve the sql query statement.
>
>
>
> Thanks in advance......
>
> Regards,
> Raj
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page