16.10 - ObjectUseCountCollectRate - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Specifies the amount of time (in minutes) between collections of object use-count data. The system updates the Data Dictionary table DBC.ObjectUsage with this data. This table allows you to find the use count and last access timestamps of any of the following database objects:

  • Columns
  • Databases
  • Indexes
  • Macros
  • Stored Procedures
  • Tables
  • Triggers
  • UDFs
  • Users
  • Views
Object use-count data is not recorded for EXPLAIN, INSERT EXPLAIN, or DUMP EXPLAIN statements, or for Data Dictionary objects.

Field Group

General

Valid Settings

IF you set this field to… THEN…
an integer between 1 and 32767 the Data Dictionary is updated with collected object use count data at an interval (in minutes) based on the set value.

If you specify a decimal value, DBS Control ignores the fractional part and uses only the integer part. For example, if you specify 12.34, DBS Control uses 12 for the field value and ignores .34.

The recommended minimum value is 10 minutes. Any rate below 10 minutes severely impacts performance.
a value higher than 32767 DBS Control displays a warning message.
a negative value DBS Control displays an error message.

Default

10 minutes

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

If you are performing an archive/recovery operation for Data Dictionary tables, the system may disable ObjectUseCountCollectRate if it experiences any contention or locking.

Use the DBQL BEGIN/END QUERY LOGGING statements to control object use count logging on an individual database basis.

Related Topics

For more information on… See…
the object use count Data Dictionary columns Data Dictionary
resetting the object use count Data Dictionary columns Database Administration
the DBQL BEGIN/END QUERY LOGGING statements SQL Data Definition Language