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 26, 12:43 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> The error stack was quite obvious.
>
So I am curious. Why does the command not affect it now?
sapdb:oraprd 82> sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 26 13:23:57 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> grant execute on dbms_shared_pool to perfstat;
Grant succeeded.
SQL> connect perfstat/**********
Connected.
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 45 ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53 ORA-06512: at "PERFSTAT.STATSPACK", line 2737 ORA-06512: at line 1Received on Wed Sep 26 2007 - 13:26:21 CDT
![]() |
![]() |