Diagnose a Full Cache Administration User Tablespace

Check for the following conditions if the cache administration user tablespace is full:

  • Is the autorefresh state set to PAUSED? Change log records accumulate when the state is PAUSED.

  • Has the cache group been created but not loaded? The default autorefresh state for cache group creation is PAUSED.

  • Is a cache group being created or is a database being duplicated? Both of these operations temporarily stop clean-up operations on the change log table.

  • Are the cache agents on all TimesTen databases running? If a cache agent is not running, change log records accumulate.

  • Has a database been abandoned without dropping cache groups with autorefresh in the database? Abandoned databases result from scenarios such as the following:

    • The database is destroyed by ttDestroy -force.

    • The application connected to the database with the Overwrite connection attribute set to 1, but the cache groups that were in the old database are not recreated.

    If the database still exists, connect to the abandoned database and drop the cache group.

Use the cacheInfo.sql script to find out how large the change log tables are for each cached Oracle database table. Use the output to verify that the databases are still in use. See Display Information from Change Log Tables.

If the databases are still in use, verify that the cache agents are running.

Compare the autorefresh progress on TimesTen to the maximum log sequence number on the change log table. If TimesTen is behind, then call the ttCacheAutorefreshStatsGet procedure to see whether the autorefresh operations are successful. See Retrieve Information About Autorefresh Operations.

If the status is InProgress longer than seems reasonable, see Poor Autorefresh Performance.

You may need to decrease the autorefresh interval or increase the size of the cache administration user tablespace.

There are options on how to manage what happens when the cache administration user tablespace is filled. See Considerations When a Tablespace Is Full.