ttCacheStop

This procedure stops the TimesTen cache agent for the connected database.

Required Privilege

This procedure requires the CACHE_MANAGER privilege.

Related Views

This procedure has no related views.

Syntax

ttCacheStop(timeout)

Parameters

ttCacheStop has the parameter:

Parameter	Type	Description
`timeout`	`TT_INTEGER`	Specifies that the TimesTen daemon should stop the cache agent if it does not stop within `timeout` seconds. If set to `0`, the daemon waits forever for the cache agent. The default value is `100`.

Result Set

ttCacheStop returns no results.

Examples

To stop the cache agent, use:

CALL ttCacheStop();

Notes

This procedure is available only for cache operations.
Do not shut down the cache agent immediately after dropping or altering a cache group. Instead, wait for at least two minutes. Otherwise, the cache agent may not get a chance to clean up the Oracle database objects that were used by the AUTOREFRESH feature.
When using this procedure, no application, including the application making the call, can be holding a connection that specifies database-level locking (LockLevel=1).