Re: new statspack install seems to hang

On Sep 24, 3:15 pm, eAddict <eAdd..._at_gmail.com> wrote:
> I just finished installing statspack on a bunch of servers (6) all
> running 9.2.0.8.
> My last one, running 9.2.0.4, there is an issue. Statspack just seems
> to
> hang. When I finally cancel the job I get:
>
> SQL> exec statspack.snap;
>
> BEGIN statspack.snap; END;
> *
> ERROR at line 1:
> ORA-01013: user requested cancel of current operation
>
> or
> SQL> exec statspack.snap
> ;
> BEGIN statspack.snap; END;
>
> *
> ERROR at line 1:
> ORA-01013: user requested cancel of current operation
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "SYS.DBMS_SHARED_POOL", line 35
> ORA-06512: at "SYS.DBMS_SHARED_POOL", line 43
> ORA-06512: at "PERFSTAT.STATSPACK", line 2708
> ORA-06512: at line 1
>
> SP2-0223: No lines in SQL buffer.
>
> So.... I can't upgrade the 9.2.0.4 server to 9.2.0.8 right now.
> What are my options? What is statspack doing that is making
> it hang?
>
> Thanks for any help!
> Vince

Did you forget to run dbmspool.sql?

jg

--
@home.com is bogus.
"Blimey, this is complicated." - Mark Rittman