Page History
...
Oracle | SQL Server | Expression Depression |
---|---|---|
sum(OTAC_NETWORK_TIME_SUM+OTAC_TIME1_SUM) | sum(OTAC_NETWORK_TIME_SUM+OTAC_TIME1_SUM) | Total Other Application Tier activity processing time. This time includes network and all other times, which sum the Other Application Tier response time. |
sum(OTAC_NETWORK_TIME_SUM)/sum(decode(OTAC_REQUESTS_SUM,0,1,OTA C_REQUESTS_SUM)) | sum(OTAC_NETWORK_TIME_SUM)/sum(decode(OTAC_REQUESTS_SUM,0,1,OTAC_REQUESTS_SUM)) | Average round-trip Other Application Tier activity network time between the Other Application Tier client and the Application server. |
sum(OTAC_TIME1_TIME_SUM)/sum(decode(OTAC_REQUESTS_SUM,0,1,OTAC_ REQUESTS_SUM)) | sum(OTAC_TIME1_TIME_SUM)/sum(decode(OTAC_REQUESTS_SUM,0,1,OTAC_REQUESTS_SUM)) | Average Other Application Tier activity processing time. This time includes the time the Other Application Tier waited for other Other Application Tiers. |
sum(OTAC_NETWORK_TIME_SUM+OTAC_TIME1_SUM)/ sum(decode(OTAC_REQUESTS_SUM,0,1,OTAC_REQUESTS_SUM)) | sum(OTAC_NETWORK_TIME_SUM+OTAC_TIME1_SUM)/ sum(decode(OTAC_REQUESTS_SUM,0,1,OTAC_REQUESTS_SUM)) | Average Other Application Tier activity processing time. This time includes network and all other times, which sum the Other Application Tier response time. |
sum(OTAC_REQUESTS_SUM-OTAC_RED_SUM-OTAC_YELLOW_SUM-OTAC_GREEN_SUM) | sum(OTAC_REQUESTS_SUM-OTAC_RED_SUM-OTAC_YELLOW_SUM-OTAC_GREEN_SUM) | Total number of Other Application Tier activity executions, for which the SLA was not defined. |
sum(OTAC_RED_SUM)/sum(decode(OTAC_RED_SUM+ OTAC_YELLOW_SUM+OTAC_ GREEN_SUM,0,1,OTAC_RED_SUM+ OTAC_YELLOW_SUM+OTAC_GREEN))*100 |
| Percentage of Other Application Tier activity executions, which Breached their SLA. The percentage is calculated out of the Other Application Tier activities, for which the SLA was established. |
sum(OTAC_YELLOW_SUM)/sum(decode(OTAC_RED_SUM+OTAC_YELLOW_SUM+OTAC_GREEN_SUM,0,1, OTAC_RED_SUM+OTAC_YELLOW_ SUM+OTAC_GREEN))*100 | sum(OTAC_YELLOW_SUM)/sum(decode(OTAC_RED_SUM+OTAC_YELLOW_SUM+OTAC_GREEN_SUM,0,1, OTAC_RED_SUM+OTAC_YELLOW_SUM+OTAC_GREEN))*100 | Percentage of Other Application Tier activity executions, which Near Breached their SLA. The percentage is calculated out of the Other Application Tier activities, for which the SLA was established. |
sum(OTAC_GREEN_SUM)/sum(decode(OTAC_RED_SUM+OTAC_YELLOW_SUM+OTAC_GREEN_SUM,0,1, OTAC_RED_SUM+OTAC_YELLOW_SUM+OTAC_GREEN))*100 |
| Percentage of Other Application Tier activity executions, which Not Breached their SLA. The percentage is calculated out of the Other Application Tier activities, for which the SLA was established. |
...