我先建立了PERFSTAT tablespace
然后
sql>@spcreate
输入密码,tablespace,查*.lis没有任务错误信息..
但是我在做
SQL> exec statspack.snap 时竟然报了这个错误
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-02291: integrity constraint (PERFSTAT.STATS$SNAPSHOT_FK) violated - parent
key not found
ORA-06512: at "PERFSTAT.STATSPACK", line 1725
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1
--------------------------------------------------
我不知道是什么原因造成的.有没有大师碰到过??
看上去应该不是什么bug..
下面是我版本信息...
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
eygly. 我是参照http://www.eygle.com/pdf/Statspack-v3.0.pdf 和 Oracle perfomance tunning 文档做的
1. SQL> create tablespace perfstat
2datafile '/opt/oracle/oradata/oradb/perfstat.dbf'
3size 150M
4extent management local;
Tablespace created.
2. SQL> @?/rdbms/admin/spcreate
entry the password:
Specify PERFSTAT user's default tablespace
Enter value for default_tablespace: perfstat
Specify PERFSTAT user's temporary tablespace.
Enter value for temporary_tablespace: temp
creating Package STATSPACK...
Package created.
No errors.
Creating Package Body STATSPACK...
Package body created.
No errors.
NOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.
执行完后
查过 *.lis..没发现有错误
SQL> conn perfstat/perfstat
Connected.
SQL> show user
USER is "PERFSTAT"
SQL> execute statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-00001: unique constraint (PERFSTAT.STATS$DATABASE_INSTANCE_PK) violated
ORA-06512: at "PERFSTAT.STATSPACK", line 1685
ORA-06512: at "PERFSTAT.STATSPACK", line 91
ORA-06512: at line 1
----------------------------------------------------------------------------------------------
后来我drop掉STATS$DATABASE_INSTANCE_PK 这个PK..
exec statspack.snap运行就可以成功.成功运行后.检查sys$database_instace 这个表。发现插入了两条一样的纪录。
statspack的脚本不知道为什么会有这样的错误..drop掉那个PK后会不会对以后的report 有什么影响??? 我在metalink 也找不到相关的bug..
有大师知道有相关的经验吗?多谢
-----Oracle DB的版本是------
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production