ttCacheDbCgStatus

Description

Returns the automatic refresh status of the data store and the specified cache group. If you do not specify any values for the parameters, the procedure returns the automatic refresh status for the data store.

Required privilege

This procedure requires no privilege.

Syntax

ttCacheDbCgStatus([cgowner, cgName])

Parameters

ttCacheDbCgStatus has these optional parameters:

Parameter	Type	Description
`cgOwner`	VARCHAR2(30)	Specifies the user name of the cache group owner.
`cgName`	VARCHAR2(30)	Specifies the cache group name.

Result set

ttCacheDbCgStatus returns the result:

Column	Type	Value
`dbStatus`	VARCHAR2(20)	Specifies the status of all the cache groups in the data store with respect to autorefresh. The status is one of: `alive` - The data store is alive. The status of all cache groups is `ok`. The cache agent has been in contact with the Oracle Server. `dead` - The cache agent was not able to contact Oracle within the timeout period. The status of all of the cache groups with the autorefresh attribute is `dead`. `recovering` - Some or all of the cache groups with the autorefresh attribute are being resynchronized with the Oracle Server. The status of at least one cache group is `recovering`.
`cgStatus`	VARCHAR2(20)	Specifies the autorefresh status of the specified cache group. The status is one of: `ok` - The specified cache group is synchronized with the Oracle database. The cache agent has been in contact with the Oracle Server. `dead` - The cache agent was not able to contact Oracle within the timeout period and the specified cache group may be out of sync with the Oracle Server. `recovering` - The specified cache group is being resynchronized with the Oracle Server.

Examples

This example shows that the automatic refresh status of the data store is alive. The automatic refresh status of the cache group is ok.

CALL ttCacheDbCgStatus ('terry', 'cgemployees');
< alive, ok >
1 row found.

To determine the automatic refresh status of the data store, call ttCacheDbCgStatus with no parameters:

CALL ttCacheDbCgStatus;
< dead, <NULL> >
1 row found.

Notes

This procedure is available only for IMDB Cache.