Re: ???.plan_table

From: TANASESCU, IOSIF <iosif.tanasescu_at_bellsygma.com>
Date: Mon, 05 Oct 1998 16:39:55 -0500
Message-ID: <36193CAB.765F347@bellsygma.com>

run ..rdbms73\admin\utlxplan.sql for the user you want to run explain plan. It will create plan_table table.
Be sure you could select from all tables you want to see the execution plan (if are not in your schema)

Horst Pichler wrote:
>
> you can ceate a public synonym
>
> Horst
>
> Phil R Lawrence wrote:
> >
> > Hello,
> >
> > I created plan_table as a very privileged user and then granted security to
> > public. However, when I say:
> >
> > explain plan
> > set Statement_ID = 'TEST'
> > for
> > select etc...
> >
> > It says:
> > ERROR at line 1:
> > ORA-02402: PLAN_TABLE not found
> >
> > This is because it is looking for a plan_table owned by me, not that privelaged
> > user. Page 194 of "Advanced Oracle Tuning and Administration" (Covers through
> > 7.3) says "Although you can rename PLAN_TABLE, it is simpler to use the default
> > name." This gives me hope that there is some modification I can make that will
> > cause privileged_user.plan_table to be sought, rather than me.plan_table.
> >
> > Any clues on how to do this?
> >
> > Thanks,
> > Phil R Lawrence

--
Iosif Tanasescu
Consultant
The CGI Group Inc.
1800 McGill College, Suite 1600
Montreal, Quebec, Canada H3A 3J6

Tel: (514) 281-0149
Fax: (514) 847-0071
IIS:itanases

E_mail:Iosif.Tanasescu_at_BellSygma.com Received on Mon Oct 05 1998 - 16:39:55 CDT