Statspack安装配置使用说明!

strongliq

[YOU HAVE NEW MAIL]
$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
JServer Release 8.1.7.4.0 - 64bit Production

SVRMGR> exit
Server Manager complete.
$ sqlplus sys/***password

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Apr 2 18:32:06 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
JServer Release 8.1.7.4.0 - 64bit Production

SQL> @$ORACLE_HOME/rdbms/admin/spcreate.sql
... Installing Required Packages

Package created.


Grant succeeded.


View created.


Package body created.


Package created.


Synonym created.


Grant succeeded.


View created.


Synonym created.


View created.


Synonym created.


View created.


Synonym created.


View created.


Synonym created.


View created.


Synonym created.


View created.


Synonym created.


View created.


Synonym created.

... Creating PERFSTAT user

User created.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Below are the list of online tablespaces in this database.
Decide which tablespace you wish to create the STATSPACK tables
and indexes.  This will also be the PERFSTAT user's default tablespace.
Using the SYSTEM tablespace to store statistical data is
NOT recommended.

TABLESPACE_NAME
------------------------------
TOOLS
RBS
INDX
JIANGUAN
CONSTRUCTOR
PERFSTAT
COCS
COCS_JBQKB
COCS_TEMP
CEIN
CEIN_TEMP

11 rows selected.


Specify PERFSTAT user's default   tablespace
Enter value for default_tablespace: perfstat
Using perfstat for the default tablespace

User altered.


User altered.

Specify PERFSTAT user's temporary tablespace
Enter value for temporary_tablespace: temp
Using temp for the temporary tablespace
alter user PERFSTAT temporary tablespace temp
*
ERROR at line 1:
ORA-00959: tablespace 'TEMP' does not exist


Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Producti
on
JServer Release 8.1.7.4.0 - 64bit Production
$ sqlplus system/***password

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Apr 2 18:32:47 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
JServer Release 8.1.7.4.0 - 64bit Production

SQL> alter user perfstat identified by ***password;

User altered.

SQL> connect perfstat/***password
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


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


SQL>

Sandybillows

你操作里面有两个问题：

1、 你没有temp的表空间，你为什么要输入临时表空间为temp？？？
TABLESPACE_NAME
------------------------------
TOOLS
RBS
INDX
JIANGUAN
CONSTRUCTOR
PERFSTAT
COCS
COCS_JBQKB
COCS_TEMP
CEIN
CEIN_TEMP

你应该输入你自己的temp表空间名，应该是COCS_TEMP或者CEIN_TEMP！

2、你建立statpack失败后，重新运行前，必须现运行脚本把statpack建立脚本刚刚建立的表和权限删掉才行，817下我记不得是什么sql了，反正也是stat...什么开头的，可能是statdrop.sql，你自己找一下，执行完drop后再执行create

strongliq

多谢沙行者！！

Sandybillows

最初由 strongliq 发布
[B]多谢沙行者！！ [/B]

  welcome

zhouyunming

谢谢