RE: Set Autotrace on

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 14 Feb 2001 14:56:05 -0800
Message-ID: <F001.002B49CF.20010214141047@fatcity.com>

> -----Original Message-----
> From: Shakeel Qureshi [mailto:msklq_at_yahoo.com]
>
> 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 Received on Wed Feb 14 2001 - 16:56:05 CST