Timesten - Cache Repository (Oracle Objects)

Timesten

The Timesten schema stores information in order to manage a cache grid.

Cache administration

Other objects (tables and triggers) stored in the admin schema are used to enforce the behaviors of particular cache group types (automatic refresh cache groups and AWT cache groups). They are used to manage a caching environment such as:

• change log tables,
• cache and replication metadata tables,
• and triggers

When particular cache grid and its cache groups operations are performed, it will create tables.

see the repository Objects

To view a list of the Oracle objects created and used by TimesTen to manage the caching of Oracle data, execute the following query:

SELECT owner, object_name, object_type FROM all_objects WHERE object_name 
LIKE 'TT\___%' ESCAPE '\';

The query returns a list of tables, indexes and triggers owned by either:

• the Oracle timesten user
• or the Oracle cache administration user.