PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_SYMP_MONITORS_PREV
Stores the last and current collected Sysmonitor counter values. Serves the Statistics process for the calculation of the delta values of the counters.
Column Name | Column Description |
---|---|
SYMP_PWII_INSTANCE_ID | ID of the counter instance. |
SYMP_GROUP_NAME | Group that includes the counter. |
SYMP_FIELD_NAME | Counter name in the sysmonitor table. |
SYMP_FIELD_ID | Counter ID in the sysmonitor table. |
SYMP_VALUE | Counter value in the sysmonitor table. |
SYMP_TYPE | Marks if this is the last or current counter's value. |
PW_SYOU_OBJECTS_SPACE_USAGE_D
Holds statistics on the objects space. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYOU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYOU_DATABASE_ID | Name of the database, normalized in table |
SYOU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYOU_OBJECT_ID | ID of the table. |
SYOU_FULL_OBJECT_ID | The full object ID, normalized in table |
SYOU_INDEX_ID | ID of the index. |
SYOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SYOU_PWHG_ID | Hour group ID. |
SYOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYOU_O_ALL_ALLOC_MAX | Size in Megabytes allocated to the object. |
SYOU_O_ALL_USED_MAX | Size in Megabytes used by the object. |
SYOU_O_TEXT_ALLOC_MAX | Size in Megabytes allocated to text pages of the object. |
SYOU_O_TEXT_USED_MAX | Size in Megabytes used for text pages of the object. |
SYOU_O_DATA_USED_MAX | Size of data pages in Megabytes used by the objects. |
SYOU_O_INDEX_ALLOC_MAX | Size in Megabytes allocated to the indexes of the object. |
SYOU_O_INDEX_USER_MAX | Size in Megabytes used by the indexes of the object. |
SYOU_ROW_COUNT_MAX | Number of rows the table has. |
SYOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDU_DEVICES_SPACE_USAGE_D
Holds statistics on the space of devices. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYDU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDU_DEVICE_ID | ID of the device, normalized in table |
SYDU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYDU_PWHG_ID | Hour group ID. |
SYDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDU_DEVICE_SIZE_MAX | Maximum device size in Megabytes. |
SYDU_SPACE_USED_MAX | Maximum space used in Megabytes. |
SYDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYSU_SEGMENTS_SPACE_USAGE_D
Holds statistics on the space of segments. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYSU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSU_DATABASE_ID | ID of the database, normalized in table |
SYSU_SEGMENT_ID | ID of the segment, normalized in table PW_SYSN_SEGMENT_NAMES_N . |
SYSU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYSU_PRODUCTION_SEGMENT_ID | ID of the segment in Sybase. |
SYSU_DEVICE_ID | ID of the device, normalized in table |
SYSU_SEGMENT_TYPE | Segment type:
|
SYSU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYSU_PWHG_ID | Hour group ID. |
SYSU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSU_SEGMENT_SIZE_MAX | Maximum segment size in Megabytes. |
SYSU_SPACE_FREE_MAX | Maximum free space size in Megabytes. |
SYSU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYSC_STMT_CATALOG
Holds information on statements in the SQL workspace.
Column Name | Column Description |
---|---|
SYSC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSC_CABINET | Name of the cabinet in which the statement is stored. |
SYSC_FOLDER | Name of the folder within the cabinet. |
SYSC_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SYSC_WORKSHOP_ID | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
PW_SYEO_EXPLN_OPER
Holds information on batch access plans.
Column Name | Column Description |
---|---|
SYEO_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYEO_DATABASE_NAME | Name of the database to which the statement belongs. |
SYEO_PARSING_USER | One of the Sybase users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SYEO_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYEO_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the SQL workspace. Statements loaded into the PMDB have the value 0. |
SYEO_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SYEO_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SYEO_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SYEO_OPERATOR_TYPE | Physical operation in the access plan. |
SYEO_EXECUTION_ORDER | Sequence order of this operation in the whole access plan. |
SYEO_TREE_LEVEL | Tree level of this operation in the access plan. |
SYEO_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SYEO_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SYEO_OBJ_NAME | Name of the object accessed in this operation. |
SYEO_OBJ_NAME_ALIAS | Alias name of the object accessed in this operation. |
SYEO_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SYEO_ADDITIONAL_INFORMATION | Additional Information provided for this Explain step. |
SYEO_LOGICAL_READS | The optimizer is estimating how many pages will not be available in cache and will need to be read from disk. |
SYEO_PHYSICAL_READS | Number of logical reads performed on the specified table. The optimizer is estimating how many pages are likely to be in cache. |
SYEO_ROWS | Number of rows from the current table that is estimated to satisfy the join. |
SYEO_SCAN_COUNT | Number of times we scan the table. |
SYEO_LOGICAL_READS_SUB | Number of logical reads of sub-query. |
SYEO_PHYSICAL_READS_SUB | Number of physical reads of sub-query. |
SYEO_PARALLEL_IND | Indicates if the operation is performed in parallel. |
SYEO_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SYEO_OPERATOR_COST | Estimated cost for the operator in the execution plan |
SYEO_AVG_WIDTH | Estimated average width of row returned by the operator |
SYEO_CPU | Estimated CPU cost for the operator in the execution plan |
SYEO_CPU_SUB | Estimated CPU cost for the sub tree starting from the operator |
SYEO_PAGES | Estimated number of pages accessed by the operator |
SYEO_PREFETCH | Indication if prefetch performed by the operator |
SYEO_IOSIZE | Estimated I/O size for the operator |
SYEO_BUFREPLACE | Buffer replacement strategy used in the operator |