Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 1Received on Tue Sep 25 2007 - 09:56:00 CDT
![]() |
![]() |