| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AUTOTRACE
Guys,
Another thing you should ascertain is that the plustrace role
has been granted to the user without which the autotrace won't
work. If the plustrace role hasn't been created, the script,
plustrce.sql ( in $ORACLE_HOME/sqlplus/admin ) can be executed
from Server Manager and the plustrace role can then be granted to
the appropriate user.
Anil Sikri
>From: Rahul <rahul_at_ratelindo.co.id>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: AUTOTRACE
>Date: Wed, 26 Apr 2000 05:30:33 -0800
>
>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.
> >
> > Thanks!
> > Sade.
> >
> >
>--
>Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |