Home » RDBMS Server » Performance Tuning » error while taking snapshot..!!
error while taking snapshot..!! [message #136366] Wed, 07 September 2005 14:50 Go to next message
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

Re: error while taking snapshot..!! [message #136368 is a reply to message #136366] Wed, 07 September 2005 15:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
increase your shared_pool_size.
Re: error while taking snapshot..!! [message #136369 is a reply to message #136366] Wed, 07 September 2005 15:02 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Guessing, but looks like there were problems during your installation of statspack. Check your install logs and correct the errors.

Didn't see Mahesh's answer, I would try his suggestion first.

[Updated on: Wed, 07 September 2005 15:03]

Report message to a moderator

icon9.gif  Re: error while taking snapshot..!! [message #136543 is a reply to message #136366] Thu, 08 September 2005 11:57 Go to previous message
rsone
Messages: 7
Registered: June 2005
Location: Jacksonville
Junior Member
Yes, this is absolutely lack of space in shared pool . Increase it!!!!!
Previous Topic: How to stop the Cache Effect ?
Next Topic: Function Index, is there a limit to the complexity ?
Goto Forum:
  


Current Time: Tue Dec 06 22:24:24 CST 2022