Timesten - Cache Agent

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

The cache agent process is responsible for managing the interaction and data synchronization between the Oracle database and the cache database.

Changes that originate in the Oracle tables are refreshed into the cache by the cache agent.

The cache agent connects to the Oracle database as the cache administration user to create and maintain Oracle objects.

Advertising

3 - How to

3.1 - Get the cache agent policy

Use the ttAdmin utility to set or get the cache agent policy.

[[email protected] ~]$ ttAdmin MyDSN
RAM Residence Policy            : inUse
Replication Agent Policy        : manual
Replication Manually Started    : False
Cache Agent Policy              : manual
Cache Agent Manually Started    : False

3.2 - How to start or stop it ?

Use the ttAdmin utility to start or stop the cache agent

[[email protected] ~]$ ttAdmin MyDSN
RAM Residence Policy            : inUse
Replication Agent Policy        : manual
Replication Manually Started    : False
Cache Agent Policy              : manual
Cache Agent Manually Started    : False

or SQL Developer

4 - Documentation / Reference