Re: Priveleges for EXPLAIN PLAN

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Tue, 25 May 1999 10:58:47 +0200
Message-ID: <374A6647.3B23BAA3@si.unirioja.es>

Allen Worthington escribió:
> =

> Can anyone tell a newbie what the *minimum* required privileges are in =
order
> to be able to execute EXPLAIN PLAN?

You must own the plan_table or granted acces to it. To create the plan_table, simply execute the utlxplan.sql in your $ORACLE_HOME/rdbms/admin/ directory
 =

> TIA
> =

> Wor

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Tue May 25 1999 - 03:58:47 CDT