ObjectUseCountCollectRate - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

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 Teradata Vantage™ - Data Dictionary, B035-1092.
resetting the object use count Data Dictionary columns Teradata Vantage™ - Database Administration, B035-1093.
the DBQL BEGIN/END QUERY LOGGING statements Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.