In the previous recipe, we have seen how to distribute Oracle files on different disks to obtain better performance. In this recipe, we will see how to stripe objects using different tablespaces or data files, to improve performance.
The following steps will demonstrate how to stripe objects across multiple disks:
CONNECT / AS SYSDBA
EXAMPLE2, on a different disk:
CREATE TABLESPACE EXAMPLE2 DATAFILE '/u01/oradata/TESTDB2/example2.dbf' SIZE 100M;
CUSTOMERStable of the
SHschema to the newly-created tablespace:
ALTER TABLE SH.CUSTOMERS MOVE TABLESPACE EXAMPLE2 NOLOGGING;
SELECT INDEX_NAME, ...