Page History
...
| 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. |