Re: Can I trace an SQL statement?

You can try to use the table plan_table. One admistrator guide describes this table. Than use the SQL command :
  'explain plan set statement_id = 'xx'
  for
  select
   .......
  '
 Finally, select data from 'plan_table' to get the execution plan of your request.

Belakimem <belakimem_at_aol.com> wrote in article <1998081723443100.TAA19372_at_ladder01.news.aol.com>...
> Personal Oracle 7, windows 95.
>
> Is there any way to trace the path a particular SQL takes in Oracle?
>
> For Informix users, I am looking for something similar to
>
> SET EXPLAIN ON;
>
> which generates a text file showing which indexes were chosen, why
temporary
> tables were created and whether tables were sequentially scanned or not.
>
> This way the efficency of a SELECT can be analysed and modified, if
necessary.
>
Received on Tue Aug 18 1998 - 08:42:10 CEST