1.

Should I Install The Statspack In Its Own Tablespace?

Answer»

Yes, we recommend that you install the statspack in a separate tablespace called PERFSTAT. You should create the tablespace as follows:

$SQLPLUS

SQL>CREATE TABLESPACE "PERFSTAT"

DATAFILE '<sap data>/perfstat 1/PERFSTAT.data1'

SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

brspace only SUPPORTS the creation of data tablespaces for SAP data, but not for non-SAP data. Therefore, you should use sqlplus, not brspace, to create the PERFSTAT tablespace.

Yes, we recommend that you install the statspack in a separate tablespace called PERFSTAT. You should create the tablespace as follows:

$sqlplus

SQL>CREATE TABLESPACE "PERFSTAT"

DATAFILE '<sap data>/perfstat 1/PERFSTAT.data1'

SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE 2000M

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

brspace only supports the creation of data tablespaces for SAP data, but not for non-SAP data. Therefore, you should use sqlplus, not brspace, to create the PERFSTAT tablespace.



Discussion

No Comment Found