11g -- install statspack

11g -- statspack install statspack in 11g2, preferably sys user installation. The installation process is as follows: 1. First, create a tablespace for storing the data generated by statspack: create tablespace perfstat datafile '/u01/app/oracle/oradata/orcl/perfstat01.dbf' size 500 m; 2: Execute SQL> @? /Rdbms/admin/spcreate. SQL where @: Indicates executing an SQL?: Number indicates that oracle will automatically create the user perfstat and require you to define a password Choose the PERFSTAT user's password --------------------------------- Not specifying a password will result in the installation FAILING Enter value for perfstat_password: perfstat then asks you to specify the Default tablespace of perfstat, and then give the specified tablespace to him: Choose the Default tablespace for the PERFSTAT user ------------------------------------------------- Below is the list of onl Ine tablespaces in this database which canstore user data. specifying the SYSTEM tablespace for the user's sdefault tablespace will result in the installation FAILING, asusing SYSTEM for performance data is not supported. choose the PERFSTAT users's default tablespace. this is the tablespacein which the STATSPACK tables and indexes will be created. TABLESPACE_NAME CONTENTS STATSPACK DEFAULT TABLESPA CE certificate --------- ---------------------------- prestat permanentsysaux permanent * users permanent Pressing <return> will result in STATSPACK's recommended defaulttablespace (identified by *) being used. enter value for default_tablespace: perfstat oracle also specifies the Temporary tablespace. Generally, the system uses the built-in tablespace: Choose the Temporary tablespace for the PERFSTAT user ----------------------------------------- ------------ Below is the list of online tablespaces in this database which canstore temporary data (e.g. for sort workareas ). specifying the SYSTEMtablespace for the user's temporary tablespace will result in theinstallation FAILING, as using SYSTEM for workareas is not supported. choose the PERFSTAT user's Temporary tablespace. TABLESPACE_NAME contents db default temp tablespace ------------------ ------------ --------- ------------------------ Temp temporary * Pressing <return> will result in the database's default Temporarytablespace (identified by *) being used. enter value for temporary_tablespace: Run statspack after TEMP is installed. Note: The interval between two executions is within 20 minutes. The collection cannot be manually executed across the downtime (that is, the shutdown cannot be performed again): execute statspack. after the command is executed by snap, oracle generates a report based on the information of the mobile phone system (at least two times before the command is executed to generate a report :@? /Rdbms/admin/spreport after executing this command, oracle will ask you to enter the start snapshot id and the end snapshot id (which generates a report using these two snapshots after oracle ): specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~ Enter value for begin_snap: 1 Begin Snapshot Id specified: 1 Enter value for end_snap: 2End Snapshot Id specified: 2 then oracle will ask you to specify the report name, the default name is sp _ <start id >_< end id>. lst: sp_1_2.lst. This file is stored under $ ORACLE_HOME/rdbms/admin/by default.