Page History
...
The Tuxedo service normalization table.
Column Name | Column Description |
---|---|
TUAN_ID | The ID of the service. |
TUAN_STRING_VALUE | The name of the Tuxedo service. |
PW_TUCN_CONSUMER_IP_N
The Tuxedo client IP normalization table.
Column Name | Column Description |
---|---|
TUCN_ID | The ID of the client IP. |
TUCN_STRING_VALUE | The client IP running the Tuxedo service. |
PW_TUSG_SERVER_GRP
The Tuxedo server group table.
Column Name | Column Description |
---|---|
TUSG_INCE_ID | The ID of the server. |
TUSG_INGD_ID | The ID of the server group running the Tuxedo service. |
PW_TUAC_ACTIONS_T
The Tuxedo information summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
TUAC_PWII_INSTANCE_ID | The ID of the Tuxedo domain running the Tuxedo service. |
TUAC_TIMESTAMP | The |
time summary. | |
TUAC_ACTION | The ID of the Tuxedo server. |
TUAC_USER | The ID of the user running the Tuxedo service. |
TUAC_CONSUMER_IP | The ID of the client IP running the Tuxedo service. |
TUAC_CONSUMER_IP_GID | The ID of the client IP group running the Tuxedo service. |
TUAC_PROGRAM | The ID of the Tuxedo server process running the Tuxedo service. |
TUAC_TIME1_SUM | Total time the Tuxedo service waited in a queue. |
TUAC_TIME2_SUM | Total Tuxedo service processing time. The time includes the time the Tuxedo service waited for other Application Tiers. |
TUAC_TIME3_SUM | Total time the Tuxedo service waited for execution of another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. |
TUAC_REQUESTS_SUM | Total number of Tuxedo service executions. |
TUAC_RED_SUM | Total number of Tuxedo service executions, which Breached their SLA. |
TUAC_YELLOW_SUM | Total number of Tuxedo service executions, which Near Breached their SLA. |
TUAC_GREEN_SUM | Total number of Tuxedo service executions, which did Not Breach their SLA. |
Expressions
Oracle | SQL Server | Expression Description |
---|---|---|
SUM( |
TUAC_ |
TIME1_ |
SUM+ |
TUAC_ |
TIME2_SUM) | SUM( |
TUAC_ |
TIME1_SUM+ |
TUAC_ |
TIME2_SUM) | Total Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. | |
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | Total Tuxedo processing time per Tuxedo service or Tuxedo server process. |
SUM(TUAC_TIME1_TIME_SUM |
)/sum(decode(TUAC_ |
REQUESTS_SUM |
,0,1, TUAC_ |
REQUESTS_SUM)) | SUM(TUAC_TIME1_ |
TIME_SUM)/sum(decode(TUAC_ |
REQUESTS_SUM |
,0,1, TUAC_ |
REQUESTS_SUM)) | Average time the Tuxedo service waited in a queue. |
SUM(TUAC_ |
TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_ |
TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average Tuxedo service processing time. This time includes the average time the Tuxedo service waited for other Application Tiers. |
SUM(TUAC_ |
TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_ |
TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average time the Tuxedo service waited for the execution of another Tuxedo service, within another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level, other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. |
SUM(TUAC_ |
TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_ |
SUM+TUAC_ |
TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. | |
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo service or Tuxedo server process. |
SUM(TUAC_ |
REQUESTS_SUM |
-TUAC_ |
RED_SUM |
-TUAC_ |
YELLOW_SUM |
-TUAC_ |
GREEN_SUM |
) |
SUM(TUAC_ |
REQUESTS_SUM |
-TUAC_ |
RED_SUM |
-TUAC_ |
YELLOW_SUM |
-TUAC_GREEN_SUM) |
Total number of Tuxedo service executions, for which the SLA was Not Defined. | ||
SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
SUM(TUAC_YELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_YELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Near Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
SUM(TUAC_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Not Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
PW_TUAC_ACTIONS_U_T
The Tuxedo information summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
TUAC_PWII_INSTANCE_ID | The ID of the Tuxedo domain running the Tuxedo service. |
TUAC_TIMESTAMP | The time summary. |
TUAC_USER | The ID of the user running the Tuxedo service. |
TUAC_TIME1_SUM | Total time the Tuxedo service waited in a queue. |
TUAC_TIME2_SUM | Total Tuxedo service processing time. The time includes the time the Tuxedo service waited for other Application Tiers. |
TUAC_TIME3_SUM | Total time the Tuxedo service waited for execution of another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. |
TUAC_REQUESTS_SUM | Total number of Tuxedo service executions. |
TUAC_RED_SUM | Total number of Tuxedo service executions, which Breached their SLA. |
TUAC_YELLOW_SUM | Total number of Tuxedo service executions, which Near Breached their SLA. |
TUAC_GREEN_SUM | Total number of Tuxedo service executions, which did Not Breach their SLA. |
Expressions
Oracle | SQL Server | Expression Description |
---|---|---|
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM) | Total Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. |
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | Total Tuxedo processing time per Tuxedo service or Tuxedo server process. |
SUM(TUAC_TIME1_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average time the Tuxedo service waited in a queue. |
SUM(TUAC_TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average Tuxedo service processing time. This time includes the average time the Tuxedo service waited for other Application Tiers. |
SUM(TUAC_TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average time the Tuxedo service waited for the execution of another Tuxedo service, within another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level, other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. |
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. |
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo service or Tuxedo server process. |
SUM(TUAC_REQUESTS_SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM) | SUM(TUAC_REQUESTS_SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM) | Total number of Tuxedo service executions, for which the SLA was Not Defined. |
SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
SUM(TUAC_YELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_YELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Near Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
SUM(TUAC_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Not Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |
PW_TUAC_ACTIONS_APC_T
The Tuxedo information summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
TUAC_PWII_INSTANCE_ID | The ID of the Tuxedo domain running the Tuxedo service. |
TUAC_TIMESTAMP | The time summary. |
TUAC_ACTION | The ID of the Tuxedo server. |
TUAC_CONSUMER_IP | The ID of the client IP running the Tuxedo service. |
TUAC_CONSUMER_IP_GID | The ID of the client IP group running the Tuxedo service. |
TUAC_PROGRAM | The ID of the Tuxedo server process running the Tuxedo service. |
TUAC_TIME1_SUM | Total time the Tuxedo service waited in a queue. |
TUAC_TIME2_SUM | Total Tuxedo service processing time. The time includes the time the Tuxedo service waited for other Application Tiers. |
TUAC_TIME3_SUM | Total time the Tuxedo service waited for execution of another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. |
TUAC_REQUESTS_SUM | Total number of Tuxedo service executions. |
TUAC_RED_SUM | Total number of Tuxedo service executions, which Breached their SLA. |
TUAC_YELLOW_SUM | Total number of Tuxedo service executions, which Near Breached their SLA. |
TUAC_GREEN_SUM | Total number of Tuxedo service executions, which did Not Breach their SLA. |
Expressions
Oracle | SQL Server | Expression Description | ||
---|---|---|---|---|
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM) | Total Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. | ||
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM) | Total Tuxedo processing time per Tuxedo service or Tuxedo server process. | ||
SUM(TUAC_TIME1_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average time the Tuxedo service waited in a queue. | ||
SUM(TUAC_TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average Tuxedo service processing time. This time includes the average time the Tuxedo service waited for other Application Tiers. | ||
SUM(TUAC_TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM)) | Average time the Tuxedo service waited for the execution of another Tuxedo service, within another Tuxedo server process. This time is gathered on a Tuxedo service level and should not be used on any summary level, other than Tuxedo service and Tuxedo server process, such as Tuxedo service group or Tuxedo server. | ||
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo domain, Tuxedo server, or any grouped entity. | ||
SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | SUM(TUAC_TIME1_SUM+TUAC_TIME2_SUM+TUAC_TIME3_SUM)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS_SUM)) | Average Tuxedo processing time per Tuxedo service or Tuxedo server process. | ||
SUM(TUAC_REQUESTS_SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM) | SUM(TUAC_REQUESTS_SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM) | Total number of Tuxedo service executions, for which the SLA was Not Defined. | ||
SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | _SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM)SUM(TUAC_REQUESTS_SUM-TUAC_RED_SUM-TUAC_YELLOW_SUM-TUAC_GREEN_SUM) SUM(TUAC_RED_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100
| Percentage of Tuxedo service executions, which Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. | ||
SUM(TUAC_REDYELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_REDYELLOW_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Near Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. | ||
SUM(TUAC_ | YELLOWGREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | SUM(TUAC_ | YELLOWGREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100 | Percentage of Tuxedo service executions, which Not Breached their SLA. The percentage is calculated out of the Tuxedo services, for which the SLA was established. |