Reports detailed usage information for tables accessed by the workload.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Tables created in SYSTEM are not reported.
Column name |
Description |
|---|---|
TableName |
Table name |
Owner |
User name of table owner |
UID** |
Table unique identifier |
LastDT |
Date/time of last access |
NRef |
Number of query references |
**UID is a number assigned by the system that uniquely identifies the instance of the table (where instance is defined when an object is created).