Configuring Tablespace Usage Threshold Notifications

To prevent the Oracle cache administration user's tablespace from becoming full, you can configure a tablespace usage threshold in TimesTen. When an update operation (such as an UPDATE, INSERT, or DELETE statement) on a trigger-based cached Oracle Database table causes the tablespace usage to exceed this threshold, TimesTen generates an SNMP trap and increments the corresponding system statistic.

Call the ttCacheConfig built-in procedure as the TimesTen cache administration user from any of the TimesTen databases that cache tables from the Oracle database. Pass the AutoRefreshLogTblSpaceUsagePCT string to the Param parameter and the threshold as a numeric string to the Value parameter. The threshold value specifies the percentage of space used in the Oracle cache administration user's tablespace at which an update operation on a cached Oracle Database table triggers an SNMP trap and increments the corresponding system statistic. Do not pass in any values to the tblOwner and tblName parameters as they are not applicable to setting a threshold for the usage of the Oracle cache administration user's tablespace.

The Oracle cache administration user must be granted the SELECT privilege on the Oracle Database SYS.DBA_DATA_FILES table in order for the TimesTen cache administration user to set the threshold on the Oracle cache administration user's tablespace usage, and for the Oracle cache administration user to monitor its tablespace to determine if the configured threshold has been exceeded.

The following example sets the AutoRefreshLogTblSpaceUsagePCT parameter to 80, configuring an 80 percent tablespace usage threshold:

% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet"
Command> CALL ttCacheConfig('AutoRefreshLogTblSpaceUsagePCT',,,'80');

To determine the current Oracle cache administration user's tablespace usage warning threshold, call ttCacheConfig passing only the AutoRefreshLogTblSpaceUsagePCT string to the Param parameter:

Command> CALL ttCacheConfig('AutoRefreshLogTblSpaceUsagePCT');
< AutoRefreshLogTblSpaceUsagePCT, <NULL>, <NULL>, 80 >

The default tablespace usage threshold is 0 percent. In this case, no SNMP trap is generated regardless of tablespace usage. The Oracle cache administration user's tablespace usage threshold applies to all TimesTen databases that cache tables from the same Oracle database and have the same Oracle cache administration user name setting.

See ttCacheConfig in the Oracle TimesTen In-Memory Database Reference.