PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | PWII_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. |
PW_OASG_SERVER_GRP
The Oracle Application server group table.
| Column Name | Column Description |
|---|---|
OASG_INCE_ID | The ID of the server. |
OASG_INGD_ID | The ID of the server group running the Oracle Application form. |
PW_OAIG_INSTANCE_GRP
The Oracle Application instance group table.
| Column Name | Column Description |
|---|---|
OAIG_INCE_ID | The ID of the instance. |
OAIG_INGD_ID | The ID of the instance group running the Oracle Application form. |
PW_OAUG_USER_GRP
The Oracle Application server group table.
| Column Name | Column Description |
|---|---|
OAUG_ORUS_ID | The ID of the user. |
OAUG_INGD_ID | The ID of the user group running the Oracle Application form. |
PW_OAAG_ACTION_GRP
The Oracle Application form group table.
| Column Name | Column Description |
|---|---|
OAAG_ORPR_ID | The ID of the Oracle Application form. |
OAAG_INGD_ID | The ID of the form group running the Oracle Application form. |
PW_OAAC_ACTIONS_T
The Oracle Application information summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
OAAC_PWII_INSTANCE_ID | The ID of the Oracle instance running the Oracle Application form. |
OAAC_TIMESTAMP | The time summary. |
OAAC_ACTION | The ID of the Oracle Application form. |
OAAC_USER | The ID of the Oracle Application user running the Oracle Application form. |
OAAC_CONSUMER_IP | The ID of the Oracle Application client IP running the Oracle Application form. |
OAAC_CONSUMER_IP_GID | The ID of the Oracle Application client IP group running the Oracle Application form. |
OAAC_APPLICATION | The ID of the Oracle Application application running the Oracle Application form. |
OAAC_NETWORK_TIME_SUM | Round-trip Oracle Application form network time between the Oracle Application client and the server. |
OAAC_STAT1_SUM | Total number of network packets, transferred while running the Oracle Application form. |
OAAC_STAT2_SUM | Total number of network bytes, transferred while running the Oracle Application form. |
OAAC_STAT3_SUM | Total number of network requests in the round-trip of the Oracle Application form. |
OAAC_TIME1_SUM | Total Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
OAAC_REQUESTS_SUM | Total number of Oracle Application form executions. |
OAAC_RED_SUM | Total number of Oracle Application form executions, which Breached their SLA. |
OAAC_YELLOW_SUM | Total number of Oracle Application form executions, which Near Breached their SLA. |
OAAC_GREEN_SUM | Total number of Oracle Application form executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | Total Oracle Application form processing time. This time includes network and all other times, which sum the Oracle Application response time. |
sum(OAAC_NETWORK_TIME_SUM)/sum(decode (OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_REQUESTS_SUM,0,1, OAAC_REQUESTS_SUM)) | Average round-trip Oracle Application form network time between the Oracle Application client and the server. |
sum(OAAC_TIME1_TIME_SUM)/sum(decode (OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_REQUESTS_SUM,0,1, OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/sum(decode (OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time include network and all other times, which sum the Oracle Application response time. |
sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM- OAAC_YELLOW_SUM-OAAC_GREEN_SUM) | sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_YELLOW_SUM-OAAC_GREEN_SUM) | Total number of Oracle Application form executions, for which the SLA was Not Defined. |
sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Near Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_ YELLOW_ SUM+OAAC_GREEN))*100 | sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Not Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
PW_OAAC_ACTIONS_AL_T
The Oracle Application information summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
OAAC_PWII_INSTANCE_ID | The ID of the Oracle Application instance running the Oracle Application form. |
OAAC_TIMESTAMP | The time summary. |
OAAC_ACTION | The ID of the Oracle Application form. |
OAAC_APPLICATION | The ID of the Oracle Application application running the Oracle Application form. |
OAAC_NETWORK_TIME_SUM | Round-trip Oracle Application form network time between the Oracle Application client and the server. |
OAAC_STAT1_SUM | Total number of network packets, transferred while running the Oracle Application form. |
OAAC_STAT2_SUM | Total number of network bytes, transferred while running the Oracle Application form. |
OAAC_STAT3_SUM | Total number of network requests in the round-trip of the Oracle Application form. |
OAAC_TIME1_SUM | Total Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
OAAC_REQUESTS_SUM | Total number of Oracle Application form executions. |
OAAC_RED_SUM | Total number of Oracle Application form executions, which Breached their SLA. |
OAAC_YELLOW_SUM | Total number of Oracle Application form executions, which Near Breached their SLA. |
OAAC_GREEN_SUM | Total number of Oracle Application form executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | Total Oracle Application form processing time. This time includes network and all other times, which sum the Oracle Application response time. |
sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average round-trip Oracle Application form network time between the Oracle Application client and the server. |
sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/sum(decode (OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/sum(decode (OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time include network and all other times, which sum the Oracle Application response time. |
sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_YELLOW_SUM-OAAC_ GREEN_SUM) | sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_YELLOW_SUM-OAAC_GREEN_SUM) | Total number of Oracle Application form executions, for which the SLA was Not Defined. |
sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Near Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+OAAC_ YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_ SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Not Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
PW_OAAC_ACTIONS_CAL_T
The Oracle Application information summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
OAAC_PWII_INSTANCE_ID | The ID of the Oracle instance running the Oracle Application form. |
OAAC_TIMESTAMP | The time summary. |
OAAC_ACTION | The ID of the Oracle Application form. |
OAAC_CONSUMER_IP | The ID of the Oracle Application client IP running the Oracle Application form. |
OAAC_CONSUMER_IP_GID | The ID of the Oracle Application client IP group running the Oracle Application form. |
OAAC_APPLICATION | The ID of the Oracle Application application running the Oracle Application form. |
OAAC_NETWORK_TIME_SUM | Round-trip Oracle Application form network time between the Oracle Application client and the server. |
OAAC_STAT1_SUM | Total number of network packets, transferred while running the Oracle Application form. |
OAAC_STAT2_SUM | Total number of network bytes, transferred while running the Oracle Application form. |
OAAC_STAT3_SUM | Total number of network requests in the round-trip of the Oracle Application form. |
OAAC_TIME1_SUM | Total Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
OAAC_REQUESTS_SUM | Total number of Oracle Application form executions. |
OAAC_RED_SUM | Total number of Oracle Application from executions, which Breached their SLA. |
OAAC_YELLOW_SUM | Total number of Oracle Application form executions, which Near Breached their SLA. |
OAAC_GREEN_SUM | Total number of Oracle Application form executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | Total Oracle Application form processing time. This time includes network and all other times, which sum the Oracle Application response time. |
sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average round-trip Oracle Application form network time between the Oracle Application client and the server. |
sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/ sum(decode(OAAC_REQUESTS_SUM,0,1,OAAC_ REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/ sum(decode(OAAC_REQUESTS_SUM,0,1,OAAC_ REQUESTS_SUM)) | Average Oracle Application form processing time. This time include network and all other times, which sum the Oracle Application response time. |
sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_ YELLOW_SUM-OAAC_GREEN_SUM) | sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_ YELLOW_SUM-OAAC_GREEN_SUM) | Total number of Oracle Application form executions, for which the SLA was Not Defined. |
sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Near Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Not Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
PW_OAAC_ACTIONS_UAL_T
The Oracle Application information summarized by each aggregated invocation.
| Column Name | Column Description |
|---|---|
OAAC_PWII_INSTANCE_ID | The ID of the Oracle instance running the Oracle Application form. |
OAAC_TIMESTAMP | The time summary. |
OAAC_ACTION | The ID of the Oracle Application form. |
OAAC_USER | The ID of the Oracle Application user running the Oracle Application form. |
OAAC_APPLICATION | The ID of the Oracle Application running the Oracle Application form. |
OAAC_NETWORK_TIME_SUM | Round-trip Oracle Application form network time between the Oracle Application client and the server. |
OAAC_STAT1_SUM | Total number of network packets, transferred while running the Oracle Application form. |
OAAC_STAT2_SUM | Total number of network bytes, transferred while running the Oracle Application form. |
OAAC_STAT3_SUM | Total number of network requests in the round-trip of the Oracle Application form. |
OAAC_TIME1_SUM | Total Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
OAAC_REQUESTS_SUM | Total number of Oracle Application form executions. |
OAAC_RED_SUM | Total number of Oracle Application from executions, which Breached their SLA. |
OAAC_YELLOW_SUM | Total number of Oracle Application form executions, which Near Breached their SLA. |
OAAC_GREEN_SUM | Total number of Oracle Application form executions, which did Not Breach their SLA. |
Expressions
| Oracle | SQL Server | Expression Description |
|---|---|---|
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM) | Total Oracle Application form processing time. This time includes network and all other times, which sum the Oracle Application response time. |
sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average round-trip Oracle Application form network time between the Oracle Application client and the server. |
sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | sum(OAAC_TIME1_TIME_SUM)/sum(decode(OAAC_ REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time includes the time the Oracle Application waited for other Application Tiers. |
sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/ sum(decode(OAAC_REQUESTS_SUM,0,1,OAAC_ REQUESTS_SUM)) | sum(OAAC_NETWORK_TIME_SUM+OAAC_TIME1_SUM)/ sum(decode(OAAC_REQUESTS_SUM,0,1,OAAC_REQUESTS_SUM)) | Average Oracle Application form processing time. This time include network and all other times, which sum the Oracle Application response time. |
sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_ YELLOW_SUM-OAAC_GREEN_SUM) | sum(OAAC_REQUESTS_SUM-OAAC_RED_SUM-OAAC_ YELLOW_SUM-OAAC_GREEN_SUM) | Total number of Oracle Application form executions, for which the SLA was Not Defined. |
sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_ RED_SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | sum(OAAC_RED_SUM)/sum(decode(OAAC_RED_SUM+ OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_ RED_SUM+OAAC_YELLOW_SUM+OAAC_GREEN))*100 | Percentage of Oracle Application form executions, which Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_SUM+OAAC_ GREEN))*100 | sum(OAAC_YELLOW_SUM)/sum(decode(OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_SUM+OAAC_ GREEN))*100 | Percentage of Oracle Application form executions, which Near Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |
sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_SUM+OAAC_ GREEN))*100 | sum(OAAC_GREEN_SUM)/sum(decode(OAAC_RED_ SUM+OAAC_YELLOW_SUM+OAAC_GREEN_SUM,0,1,OAAC_RED_SUM+OAAC_YELLOW_SUM+OAAC_ GREEN))*100 | Percentage of Oracle Application form executions, which Not Breached their SLA. The percentage is calculated out of the Oracle Application forms, for which the SLA was established. |