The image shows the tasks necessary for preparing an Oracle database for cache.

  1. Create tablespace for cache.

  2. Create cache administration user.

  3. Identify schema and its respective schema owner whose tables are to be cached.

  4. Grant cache privileges to both users.