Oracle Database Discussions

Hello All,
I want to use Statspack for gathering performance stats in my Oracle 9i Database running on Enterprise linux. I have created perfstat user using spcreate.sql . Now i am able to connect to perfstat user but when i am executing statspack.snap it is giving the following error:-

SQL> connect perfstat/perfstat;
Connected.
SQL> execute 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

Also when I am trying to execute spreport.sql to gather report . It is asking for me to give begin snap_id and end_snap . I am not clear about what these are . Although I am giving values of 1 and 2 resp. .After giving the values it is getting hanged and is not showing anything. Result is:-

SQL> @spreport.sql;
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
from stats$database_instance
*
ERROR at line 7:
ORA-00942: table or view does not exist



Using 1719231136 for database Id
Using 1 for instance number
, stats$database_instance di
*
ERROR at line 9:
ORA-00942: table or view does not exist




Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End Snapshot Id specified: 2


So could you clarify on these as I am using statspack to gather stats for the first time and don't have any more knowledge about it.

Thanks and Regards,
Gaurav Yadav