| 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: 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. |
|