Problem with STATSPACK
Database: Oracle 8.1.7 EE
OS: Solaris 7
I would like to use STATSPACK. When I ran spcreate.sql got the following errors:
$ cat spcusr.lis
... Installing Required Packages
Package body created.
create view X_$KCBFWAIT as select * from X$KCBFWAIT
ERROR at line 1:
ORA-00955: name is already used by an existing object
Could you please explain why I am getting this?
Thanks in advance.
don't know what happened but you can certainly drop statspack and recreate it by doing the following:
be sure using SQL not SVRMGRL
1. log in as SYS
2. run spdrop.sql to drop statspack
3. log in as perfstat/perfstat
4. run spcpkg.sql
5. run statspack.snap
Thanks for quick reply.
I have done the same as you mentioned. After running spdrop.sql I tried to connect with perfstat user:
test2:sys> conn perfstat
ORA-01017: invalid username/password; logon denied
Thanks once again for your time.
After RTFM, found that if we need to run spcreate.sql as batch mode, we have to specify default & temporary tablespaces. Otherwise, it will create PERFSTAT user, tables, indexes and packages under SYSTEM tablespace.
STATSPACK is ready to use now!
Anyway, thanks guys for help!
Click Here to Expand Forum to Full Width