| error while taking snapshot..!! [message #136366] |
Wed, 07 September 2005 14:50  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
we are using statspack to take report regarding performance & tuning.we have installed the statspack and while taking snapshot by executing procedure as " exec statspack.snap " from the perfstat user, it blows the errors as follows
SQL> exec statspack.snap;
BEGIN statspack.snap; END;
*
ERROR at line 1:
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
we execute the procedure from perfstat user with the execute privilege on the procedure granted to the user.
db-->oracle 9i
os-->linux
where we stuck up..?
plz help out.
[Updated on: Wed, 07 September 2005 14:52] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
