ttCacheLoadSCNGet

This procedure returns the load SCN a specific SCN value that corresponds to the last time a cache group was loaded from the Oracle database into the TimesTen cache. This is applicable only for log-based cache groups.

Required Privilege

This procedure requires the TTPRIV_CACHEMGR privilege.

Related Views

This procedure has this related view.

SYS.V$CACHE_GROUP_LOAD_STATUS

Syntax

ttCacheLoadSCNGet('cache_group_owner', 'cache_group_name')

Parameters

ttCacheLoadSCNGet has these parameters:

Parameter	Type	Description
cache_group_owner	TT_VARCHAR2(30)	Cache group owner.
cache_group_name	TT_VARCHAR2(30) NOT NULL	The name of the cache group.

Result Set

ttCacheLoadSCNGet returns the result:

Column	Type	Value
load_scn	VARCHAR2(21)	The SCN (System Change Number) at which the cache group was last loaded from the Oracle database.

Examples

Command> CALL ttCacheLoadSCNGet('HR', 'EMP_CACHE');
Load_SCN: 3943852 

Returns the SCN when the EMP_CACHE cache group owned by HR was last loaded.

You can also use the cachegroups command to find the SCN value. See Task 3: Create TimesTen Users and Tables in the Oracle TimesTen In-Memory Database Cache Guide.