RE: AUTOTRACE

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 26 Apr 2000 17:29:03 +0700
Message-Id: <10479.104176@fatcity.com>

SQL> set autotrace on
it's not a "tool" is't a sql*plus command which give the sql plan of sql's executed in after the trace is enabled...
you could also do "set autotrace on explain" this will only show the exec plan not the other stats...

make sure the plan table has been created in the schema... or run..
$ORACLE_HOME\rdbms\utlxplan.sql

> ----------
> From: Stephane Paquette[SMTP:spaquette_at_houra.fr]
> Reply To: Stephane Paquette
> Sent: 26 April 2000 17:58
> To: oracledba_at_lazydba.com
> Subject: Re: AUTOTRACE
>
> Autotrace is a sql*plus tool.
>
> Just do set autotrace to have the exact synthax.
> It can give you the access plan and some stats.
>
> It's a good tool, but it is not as good as tkprof .
>
>
>
> ----- Original Message -----
> From: Folasade Gbago
> To: oracledba_at_lazydba.com
> Sent: Wednesday, April 26, 2000 10:45 AM
> Subject: AUTOTRACE
>
>
> Hello DBAs',
> Would someone be kind enough to tell me more about AUTOTRACES. I've been asked to use it to monitor a particular index.
Received on Wed Apr 26 2000 - 05:29:03 CDT