new statspack install seems to hang

From: eAddict <eAddict_at_gmail.com>
Date: Mon, 24 Sep 2007 22:15:35 -0000
Message-ID: <1190672135.707519.324580@w3g2000hsg.googlegroups.com>

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 Received on Mon Sep 24 2007 - 17:15:35 CDT