Statspack was first introduced in Oracle Database 8i R8.1.6. We shall now look at how to use this tool.
To use Statspack, we have to set up a tablespace to store its structures; if we don't, in the installation process we have to choose an already existing tablespace—
SYSAUX is the tablespace proposed by default. To create the tablespace, we will use the following command (with the necessary change in the
datafile parameter, according to the platform used and the database location):
CREATE TABLESPACE statspack DATAFILE '/u01/oracle/db/STATSPACK.DBF' SIZE 200 M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K SEGMENT SPACE MANAGEMENT AUTO PERMANENT ONLINE;
To collect timing information in the dynamic ...