Re: new statspack install seems to hang

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 25 Sep 2007 20:51:12 +0200
Message-ID: <fdblar$2k3$2@news1.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

eAddict wrote:

> 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

connect / as sysdba
grant execute on sys.dbms_shared_pool to perfstat;

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG+VigLw8L4IAs830RAgUbAJ0T1cLWSZ7PXynq0xi6DU5403Xc2gCeOZu/ GRdXEZmshMf89Uw4P+dwlcM=
=Wbwp
-----END PGP SIGNATURE----- Received on Tue Sep 25 2007 - 13:51:12 CDT