If you are using a multitenant container database (CDB) or
pluggable database (PDB), the Oracle cache administrator user can be one of
the following:
-
Local user: A local user is a database user that can
operate only within a single PDB. You must assign cache privileges
only within the PDB in which this user exists.
-
Common user: A common user is a database user known in
every container and has the same identity in the CBD root and in
every existing and future PDB in the CDB. You must assign cache
privileges within each PDB in the CDB in which you want to use
cache.
Note:
Each TimesTen database can be managed by only a single cache
administration user on the Oracle database. However, a single cache
administration user can manage multiple TimesTen databases. You can
specify one or more cache administration users where each manages one or
more TimesTen databases.
See Caching the Same Oracle Table on Two or More TimesTen Databases.
Designate the tablespace as the default tablespace for the Oracle
cache administration user. This user creates tables in this tablespace that
are used to store information about the cache environment and its cache
groups. Other Oracle database objects (such change log tables, replication
metadata tables, and triggers) are used to enforce the predefined behaviors
of cache groups with autorefresh and AWT cache groups are created in the
same tablespace. To create and manage these objects, the Oracle cache
administration user must have a high level of privileges. A cache group with
autorefresh refers to a read-only cache group or a user managed cache group
that uses the AUTOREFRESH MODE INCREMENTAL
cache group
attribute.
See Managing a Cache Environment with Oracle Database Objects for a list of Oracle
Database tables and triggers owned by the cache administration user.
Note:
If you create multiple cache administration users, each may
use the same or different tablespace as their default tablespace.
As the sys
user, use SQL*Plus to create the
Oracle database cache administration user cacheadmin
. In
the example below, the default tablespace for the
cacheadmin
user is cachetblsp
.
For the non-autonomous Oracle Database, the following SQL*Plus
example creates the cache administration user:
SQL> CREATE USER cacheadmin IDENTIFIED BY orapwd
DEFAULT TABLESPACE cachetblsp QUOTA UNLIMITED ON cachetblsp;
For the Transaction Processing workload type, the following
SQL*Plus example creates the cache administration user:
SQL> CREATE USER cacheadmin IDENTIFYED BY orapwd
QUOTA UNLIMITED ON DATA;