Statspack的安装

Statspack是Oracle自带的性能分析工具。安装需要使用sysdba权限的用户，并需要指定Statspack的用户密码、默认表空间和临时表空间。
脚本路径：$ORACLE_HOME/rdbms/admin
安装脚本：spcreate.sql
删除脚本：spdrop.sql （如果安装失败，可以通过spdrop.sql删除已经创建的内容，然后分析spcpkg.lis日志，确定问题后可以再次使用spcreate.sql进行安装）
安装成功后或切换到PERFSTAT下

具体安装步骤如下：
1、cd $ORACLE_HOME/rdbms/admin
2、sqlplus / as sysdba
2、执行 spcreate.sql(@spcreate.sql)
执行spcreate.sql后，开始statspack的安装，内容（这里删除了系统日志）如下：

点击(此处)折叠或打开

1. SQL> @spcreate.sql
   
2. 
   
3. Choose the PERFSTAT user\'s password
   
4. -----------------------------------
   
5. Not specifying a password will result in the installation FAILING
   
6. 
   
7. Enter value for perfstat_password: moyefeng
   
8. 
   
9. Choose the Default tablespace for the PERFSTAT user
   
10. ---------------------------------------------------
    
11. …………
    
12. Choose the PERFSTAT users\'s default tablespace. This is the tablespace
    
13. in which the STATSPACK tables and indexes will be created.
    
14. 
    
15. TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPACE
    
16. ------------------------------ --------- ----------------------------
    
17. EXAMPLE PERMANENT
    
18. PERFSTAT PERMANENT
    
19. SYSAUX PERMANENT *
    
20. USERS PERMANENT
    
21. 
    
22. Pressing <return> will result in STATSPACK\'s recommended default
    
23. tablespace (identified by *) being used.
    
24. 
    
25. Enter value for default_tablespace: PERFSTAT
    
26. 
    
27. Using tablespace PERFSTAT as PERFSTAT default tablespace.
    
28. 
    
29. 
    
30. Choose the Temporary tablespace for the PERFSTAT user
    
31. -----------------------------------------------------
    
32. …………
    
33. Choose the PERFSTAT user\'s Temporary tablespace.
    
34. 
    
35. TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
    
36. ------------------------------ --------- --------------------------
    
37. TEMP TEMPORARY *
    
38. 
    
39. Pressing <return> will result in the database is default Temporary
    
40. tablespace (identified by *) being used.
    
41. 
    
42. Enter value for temporary_tablespace: TEMP
    
43. 
    
44. …………
    
45. Creating Package STATSPACK...
    
46. 
    
47. Package created.
    
48. 
    
49. No errors.
    
50. Creating Package Body STATSPACK...
    
51. 
    
52. Package body created.
    
53. 
    
54. No errors.
    
55. 
    
56. NOTE:
    
57. SPCPKG complete. Please check spcpkg.lis for any errors.
    
58. 
    
59. SQL> show user
    
60. USER is "PERFSTAT"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20753330/viewspace-1136534/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20753330/viewspace-1136534/