Re: Explain Plan in Oracle Top Sessions Monitor

From: Ronald <ronr_at_wxs.nl>
Date: Sun, 10 Jan 1999 6:20:18 +0100
Message-ID: <01HW.B2BDF722000060271274ADA0_at_news.wxs.nl>

On Fri, 8 Jan 1999 11:38:39 +0100, Gerard Szyja wrote (in message <Pell2.8700$U1.1482500_at_news.tpnet.pl>):
>
> I am trying to show explain plan using Oracle Top Sessions Monitor (Oracle
> Performance Pack from Oracle Enterprise Manager ver. 1.2.2 ) on Oracle 8 (on
> Oracle 7.x - OK) as SYSTEM or SYS user. I get an error message ORA-02421
> ????
>
> The Smptsi80.sql script passed OK.
Gerard,

[Quoted] 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.

have luck,

-- 
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 Sun Jan 10 1999 - 06:20:18 CET

This message: [ Message body ]
Next message: mcox: "Re: PeopleSoft: Upgrade 5.12 to 7.5 - anyone tried direct path???"
Previous message: Caobin Zhu: "Re: Developer/2000: view list of tables with ODBC connection"
In reply to: Gerard Szyja: "Explain Plan in Oracle Top Sessions Monitor"
In reply to Gerard Szyja: "Explain Plan in Oracle Top Sessions Monitor"
Next in thread: mcox: "Re: PeopleSoft: Upgrade 5.12 to 7.5 - anyone tried direct path???"
Reply: Gerard Szyja: "Re: Explain Plan in Oracle Top Sessions Monitor"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message