regarding statspack.... [message #115662] |
Wed, 13 April 2005 09:25 |
balavignesh
Messages: 180 Registered: March 2005
|
Senior Member |
|
|
hi,
i have installed statspack successfully but while taking the snapshot using exec statspack.snap , it gives error like
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'STATSPACK.SNAP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
only after executing this procedure only , the report can be taken.what to do further..?
any help is appreciated.
regards
bala
|
|
|
Re: regarding statspack.... [message #115685 is a reply to message #115662] |
Wed, 13 April 2005 11:33 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Did you try to execute this procedure as the owner of statspack (default user perfstat?
If not, grant execute on statspack to the user you are trying to execute the procedure with and either create a synonym or prefix the call with the owner of the statspack package.
(e.g. exec perfstat.statspack.snap)
hth
|
|
|
|
Re: regarding statspack.... [message #115732 is a reply to message #115662] |
Thu, 14 April 2005 01:17 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Show us what you did. Please cut and paste your results from sqlplus when you execute the following:
-- This will show us what you can see of the objects
-- Most likely there will only be a synonym visible
select owner
, object_type
from all_objects
where object_name = 'STATSPACK'
/
-- This will show us the owner of STATSPACK in case
-- you don't have permission
select table_owner
from all_synonyms
where synonym_name = 'STATSPACK'
/
-- Show us who you are
show user
-- Show us the exact errormessage, just in case it
-- differs from what we expected
exec perfstat.snap
hth
|
|
|
Re: regarding statspack.... [message #115798 is a reply to message #115732] |
Thu, 14 April 2005 09:12 |
balavignesh
Messages: 180 Registered: March 2005
|
Senior Member |
|
|
hi frank,
these are the results that i got when executing...
SQL> select owner , object_type from all_objects where
object_name ='STATSPACK';
no rows selected
SQL> select table_owner from all_synonyms where synonym_name='STATSPACK';
no rows selected
SQL> show user
USER is "PERFSTAT"
SQL> exec perfstat.snap
BEGIN perfstat.snap; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'PERFSTAT.SNAP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> exec statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'STATSPACK.SNAP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
regards
bala
|
|
|
Re: regarding statspack.... [message #115805 is a reply to message #115662] |
Thu, 14 April 2005 09:31 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Something must have gone wrong while installing statspack; it is not installed.
check spctab.lis and spcpkg.lis for errors. These are spoolfiles of the installation.
hth
|
|
|
|
Re: regarding statspack.... [message #115905 is a reply to message #115662] |
Fri, 15 April 2005 02:02 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
$ oerr ora 1659
01659, 00000, "unable to allocate MINEXTENTS beyond %s in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS
// for the segment being created.
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
// tablespace or retry with smaller value for MINEXTENTS, NEXT or
// PCTINCREASE
Seems your stat tablespace has too little space available. Add space to it as indicated.
hth
|
|
|
Re: regarding statspack.... [message #168676 is a reply to message #115662] |
Fri, 21 April 2006 09:54 |
ramsat
Messages: 49 Registered: November 2005
|
Member |
|
|
Hai,
I understood Ur problem, this happens when ur statspack tablespce doesnot have enough space to create objects in it.
Try the same by resizing the tablespace size to considerable say 100mB.
It will work for sure. i confirmed this by playing the same scenario.
thank U
ramesh
|
|
|
|
|
|
|