Precise for J2EE tables

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column Name	Column Description
`PWII_ID`	ID of the instance. Columns of `XXXX_PWII_INSTANCE_ID` have values from the column.
`PWII_INSTANCE_NAME`	Name of the instance.
`PWII_TECHNOLOGY`	Two characters defining the technology of the instance (such as `OR` for Oracle and `JE` for J2EE).
`PWII_SERVER`	Name of the server on which the instance is installed.

Summarizes each aggregated invocation.

Column Name	Column Description
`JESR_PWII_ID`	Instance ID.
`JESR_TIMESTAMP`	Time summary.
`JESR_IS_SERVICE_REQUEST`	True if this row describes a HTTP or EJB service request aggregated invocation. False if this row describes a Custom, HTTP, EJB, or other non-service request aggregated invocation.
`JESR_NAME`	Name of the aggregated invocation.
`JESR_TYPE`	Type of the aggregated invocation.
`JESR_HIT_COUNT_SUM`	Total completions (hits) of the aggregated invocation.
`JESR_RESPONSE_TIME_SUM`	Total response time of the aggregated invocation.
`JESR_CPU_TIME_SUM`	Total estimated CPU time of the aggregated invocation.
`JESR_INTERNAL_TIME_SUM`	Portion of total response time of the aggregated invocation that excludes the response time spent in calls (invocations) that were instrumented. In other words, internal time is the portion of the invocation response time that was not instrumented.
`JESR_JDBC_TIME_SUM`	Total response time of the aggregated invocation to directly call JDBC calls.
`JESR_THRESHOLD_BREACH`	True if: this aggregated invocation's average response time exceeded the breaching activities threshold value and this invocation's `IS_SERVICE_REQUEST` value is True

Summarizes each type of invocation.

Column Name	Column Description
`JEAS_PWII_INSTANCE_ID`	Instance ID.
`JEAS_TIMESTAMP`	Time summary.
`JEAS_IS_SERVICE_REQUEST`	True if this row summarizes all HTTP or EJB type service requests. False if this row describes all Custom, HTTP, EJB, or other non-service request invocations.
`JEAS_TYPE`	Type of the summarized invocation type.
`JEAS_HIT_COUNT_SUM`	Total hits of the summarized invocation type.
`JEAS_RESPONSE_TIME_SUM`	Total response time of the summarized invocation type.
`JEAS_CPU_TIME_SUM`	Total estimated CPU time of the summarized invocation type.
`JEAS_INTERNAL_TIME_SUM`	Total internal time of the summarized invocation type excludes all calls to other invocations that were instrumented.
`JEAS_JDBC_TIME_SUM`	Total response time of the summarized invocation type to directly call JDBC calls.
`JEAS_THRESHOLD_BREACH`	True if: this summarized invocation type's average response time exceeded the breaching activities threshold value and this summarized invocation type `IS_SERVICE_REQUEST` value is True
`JEAS_ACTIVE_THREADS_AVG`	Average number of active threads of this summarized invocation type and only when this row has `IS_SERVICE_REQUEST` value as True.

Summarizes the JVM.

Column Name	Column Description
`JEJV_PWII_INSTANCE_ID`	Instance ID.
`JEJV_TIMESTAMP`	Time summary.
`JEJV_HEAP_USED_PCT_AVG`	Percent of this JVMs heap in use.
`JEJV_MAJOR_GC_TIME_PCT_AVG`	Percent of time this JVM spent doing garbage collection.
`JEJV_ACTIVE_THREADS_AVG`	Average number of active threads of all types.
`JEJV_CPU_PCT`	Percentage of the available CPU time that this JVM consumed.

Summarizes the JVM.

Column Name	Column Description
`JEAV_INSTANCE_ID`	Instance ID.
`JEAV_TIMESTAMP`	Slice end time.
`JEAV_AVAIL_PCT`	The percentage of the slice in which the JVM was available.

The J2EE Method group table.

Column Name	Column Description
`JEAG_JEAN_ID`	Method ID.
`JEAG_INGD_ID`	Method group ID.

The J2EE JVM group table.

Column Name	Column Description
`JEIG_INCE_ID`	Instance ID.
`JEIG_INGD_ID`	Instance group ID.

The J2EE server group table.

Column Name	Column Description
`JESG_INCE_ID`	ID of the J2EE instance installed on the server.
`JESG_INGD_ID`	Server group ID.