Re: Explain Plan in Oracle Top Sessions Monitor

From: Ronald <ronr_at_wxs.nl>
Date: Tue, 12 Jan 1999 6:20:17 +0100
Message-ID: <01HW.B2C09A2100005FE91274ADA0_at_news.wxs.nl>

On Mon, 11 Jan 1999 16:58:02 +0100, Gerard Szyja wrote (in message <ecpm2.14906$U1.2675693_at_news.tpnet.pl>):
>
>
> Ronald wrote in message <01HW.B2BDF722000060271274ADA0_at_news.wxs.nl>...
>

>> try running utlxplan.sql first. It creates the plan_table in the current 
>> schema. I am not 100% sure but I know there was something like this to 
>> run. 

>
>
> Smptsi80.sql script run utlxplan.sql. plan_table is in schema SYS and
> SYSTEM.
>
>

Are the tables visible to the connected user (sysdba -> sys); do you have public synonyms for the tables ?

-- 
Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html
        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl
 

Received on Tue Jan 12 1999 - 06:20:17 CET