Title: 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

Reply via email to