Re: trace SQL

From: Roeland Stouthart <oracle_at_worldonline.nl>
Date: 1997/03/19
Message-ID: <01bc33ea$9229ad60$dd141b91@oracle.kpmg.nl>#1/1

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

Try the EXPLAIN PLAN clause, first install the explain_plan table (installation guide).

The get info about the #processed records, hits, etc you have to enable the trace in your session. Use TKPROF to format the output.

Succes

Roeland Received on Wed Mar 19 1997 - 00:00:00 CST