Re: new statspack install seems to hang

On Sep 24, 7:31 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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

Didn't help...

sapdb:oraprd 7> sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 25 09:53:24 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> @dbmspool

Package created.
Grant succeeded.
View created.
Package body created.

SQL> connect perfstat/**************
Connected.
SQL> exec statspack.snap; <----30 min wait before cancel 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 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "PERFSTAT.STATSPACK", line 2708
ORA-06512: at line 1