15.00 - ObjectUseCountCollectRate - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

ObjectUseCountCollectRate

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
  • Note: 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.

    Note: 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.

    WARNING:

    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