invantive documentation
Invantive Support ForumsLog In / Sign Up

PERFORMANCEMEASUREMENTSLIVE: Data Dictionary Live Performance Measurements

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Live Performance Measurements

Live executed performance benchmarks on currently active data containers.

Can only retrieve data.

Parameters

Name Data Type Required Default Documentation
max_duration_sec number
max_tests number
sample_size number

Table Columns

The columns of the table PERFORMANCEMEASUREMENTSLIVE are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CATALOG varchar2 Catalog Catalog where the tables are contained in.
DURATION_MS double Duration Duration in milliseconds of the I/O.
ERROR_MESSAGE varchar2 Error Message Error message that occurred during executing the I/O.
EXECUTION_DATE_UTC datetime Execution Date Date at which the I/O was executed (UTC).
ID int32 ID Unique ID of the property.
PARTITIONS varchar2 Partitions Partitions on which the I/O was executed.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
ROW_COUNT int64 Rows Number of rows exchanged.
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SUCCESSFUL char Succesful Indicator whether the I/O completed successfully.
TABLE_NAME varchar2 Table Name Name of the table.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: