Re: plustrace role and Oracle 8i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 25 Jul 1999 21:01:36 +0100
Message-ID: <932933196.1594.0.nnrp-02.9e984b29@news.demon.co.uk>

Look in $ORACLE_HOME/sqlplus/admin.
The role is only needed for getting stats out from SET AUTOTRACE in sqlplus,
nothing to do with EXPLAIN PLAN.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ron Reidy wrote in message <379B688B.62FB71EF_at_uswest.net>...
>Hi,
>
>In Oracle 8.0.5, the plustrace role existed. It appears to me (or am I
>just missing something?) this rolw is now gone in 8i. Is this true?
>
>When I look at DBA_ROLES, it is not listed. I searched through all
>files in $ORACLE_HOME/rdbms/admin for this and found nothing. The docs
>say that this role must be granted in order to use explain plan.
Received on Sun Jul 25 1999 - 15:01:36 CDT