15.10 - DatabaseUseCountV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.DatabaseName

UsageType

CHAR(3) LATIN

NOT NULL

X(3)

ObjectUsage.UsageType

AccessCount

BIGINT

--,---,---,---,---,---,--9

ObjectUsage.UserAccessCnt

Possible Values for UsageType

 

Name

Description

DML

Data Manipulation Language

STA

Optimizer usage of statistics

The following SELECT statement shows the number of accesses occurring on a particular database:

SELECT AccessCount FROM DBC.DatabaseUseCountV WHERE DatabaseName = 'Personnel';

Result:

        AccessCount
--------------------------
                        16