Provides a description for all columns in a monitoring table used to optimize query performance for the monitoring tables.
The metadata view for this table is identical for all instances in a shared-disk cluster.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monTableParameters are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
TableID |
int |
Unique identifier for the table |
|
ParameterID |
int |
Position of the parameter |
|
TypeID |
int |
Identifier of the datatype of the parameter |
|
Precision |
tiny_int |
Precision of the parameter, if numeric |
|
Scale |
tiny_int |
Scale of the parameter, if numeric |
|
Length |
small_int |
Maximum length of the parameter (in bytes) |
|
TableName |
varchar(30) |
Null |
Name of the table |
ParameterName |
varchar(30) |
Null |
Name of the parameter |
TypeName |
varchar(20) |
Null |
Name of the datatype of the parameter |
Description |
varchar(255) |
Null |
Description of the parameter |