EVENT_PK

NUMBER

Sequential primary key. Constraints required.

SERVICE_NAME

VARCHAR2(256)

Virtual service name. Constraints required.

SERVICE_VERSION

VARCHAR2(256)

Version of a virtual service or an API. By default, for every version of a virtual service a system version number is generated. At the same time, user can also provide a version number which is set as a user version.

OPERATION_NAME

VARCHAR2(256)

Virtual service operation hosting the invocation. Constraints required.

NATIVE_ENDPOINT

VARCHAR2(4000)

Native service endpoint to which the request has been routed.

BINDING_NAME

VARCHAR2(256)

This column is currently not used.

TARGET_NAME

VARCHAR2(64)

The target name specified in the Integration Server Administrator's Solutions > Mediator > Administration > CentraSite Communication page.

EVENT_CREATE_TS

TIMESTAMP(6)

Timestamp when the event was created by the virtual service runtime. This is not the time the database performed its insert (for example, this is calculated by the Mediator policy engine and is not a database function).

EVENT_SOURCE

VARCHAR2(80)

Policy name that produced the event.

INCLUDE_FAULTS

CHAR(1)

Boolean. This value impacts the min/max/avg response calculations since faults will be included in those metrics if this value is true.

INTERVAL_START

TIMESTAMP(6)

Start time of metrics collection interval.

INTERVAL_STOP

TIMESTAMP(6)

Stop time of metrics collection interval.

AVAIL

NUMBER

The percentage of time that a virtual service was available during the current interval.

LIVELY

CHAR(1)

Boolean. Specifies whether the service was considered available at the end of the current interval.

FAULT_COUNT

NUMBER

The number of failed service invocations during the current interval.

SUCCESS_COUNT

NUMBER

The number of successful service invocations during the current interval.

TOTAL_COUNT

NUMBER

The total number of service invocations during the current interval.

MAX_RESP

NUMBER

The maximum amount of time it took the service to complete an invocation in the current interval.

MIN_RESP

NUMBER

The minimum amount of time it took the service to complete an invocation in the current interval.

AVG_RESP

NUMBER

The average amount of time it took the service to complete an invocation in the current interval.