The OUC cache must be flushed periodically to avoid the accumulation of stale use counts in DBC.ObjectUsage. The following criteria trigger a flush of the OUC cache to disk:
•When a specific user-defined time interval is reached.
You can specify a time‑based flushing interval using the DBS Control parameter ObjectUseCountCollectRate. Teradata Database flushes the OUC cache when either of the following events first occurs.
•The specified elapsed time since the last flush of the cache is reached.
•The cache is full.
No comments:
Post a Comment