Install and configure statspack

Note:OracleStatspack is a performance tuning tool provided by Oracle. When statspack automatically collects activities, it obtains relevant information in the memory structure and stores it in the statspack table.

Environment: WindowsXP, release 10.2.0.1.0

InstallPrerequisites:Sysdba permission

Process:

1. log on to sqlplus

Sqlplus/As sysdba

2. Create a perfstat tablespace

Create tablespacePerfstatDatafile 'd: \ oracle \ product \ 10.2.0 \ oradata \Orcl\ Perfstat. dbf'size 500 m;

2. Execute spcreate. SQL in sqlplus

SQL> @ D: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ admin \ spcreate. SQL

Input parameter values during execution

Enter the perfstat_password value:Perfstat

Enter the value of defalut_tablespace:Perfstat

Enter the value of temporary_tablespace:Temp

......

After the installation is complete, the system exits under the SQL> prompt symbol.

After the installation is complete, it will be changed to the perfstat user by default, which can be viewed through show user.

 

Installation Complete

 

If the input is incorrect or the installation is accidentally canceled, you should first use spdrop. SQL to delete the user (perfstat) and installed views before the next attempt to install statspack. After statspack is installed, a file named spcpkg. Lis is created. If an error occurs, check the file. However, as long as a valid tablespace name is provided (and no perfstat user is available), the statspack package can be installed smoothly.