Title: RE: Set Autotrace on
|
I understood it too.
But i need to do it with a simple user
...
How can I do it ?
Eriovaldo do Carmo Andrietta
Limeira/SP - Brasil
----- Original Message -----
Sent: Wednesday, February 14, 2001 7:10
PM
Subject: RE: Set Autotrace on
> -----Original Message-----
>
From: Shakeel Qureshi [mailto:[EMAIL PROTECTED]]
>
> In oracle 8.1.6 I only run as a
schema owner
> the utlxplan.sql and everything
works fine. I just set
> sql trace explain and it
gives me all the details of
> execution
plan.
My understanding is that running
"$ORACLE_HOME/sqlplus/admin/plustrce.sql" will allow a user without DBA or
"select any table" privilege to do a 'set autotrace .... statistics" in
SQL*Plus.
Jacques R. Kilcho�r
x8816
|
