1. Getting Started with Cache Guide
  2. Prepare the Databases for Cache Operations
  3. Prepare the Oracle Database for Cache Operations
  4. Task 1: Create the Tablespace for Cache Metadata and Management Objects

Task 1: Create the Tablespace for Cache Metadata and Management Objects

The Oracle cache administration user needs to have a default tablespace to store cache metadata and management objects. It is recommended to create a dedicated tablespace just for cache operations. This tablespace should not be shared with other applications.

The following example creates the cachetblsp tablespace in the non-autonomous Oracle Database: 

SQL> CREATE TABLESPACE cachetblsp DATAFILE 'cachetblsp_f1.dbf'
                SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.

Skip this step for the Autonomous Transaction Processing. Autonomous Transaction Processing automatically configures default data and temporary tablespaces for the database. Adding, removing, or modifying tablespaces is not allowed. Autonomous Transaction Processing creates one or multiple tablespaces automatically depending on the storage size.