PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_TUIG_INSTANCE_GRP
The Tuxedo domain group table.
| Column Name | Column Description |
|---|---|
TUIG_INCE_ID | The ID of the domain. |
TUIG_INGD_ID | The ID of the domain group running the Tuxedo service. |
PW_TUUG_USER_GRP
The Tuxedo user group table.
| Column Name | Column Description |
|---|---|
TUUG_TUUN_ID | The ID of the user. |
TUIG_INGD_ID | The ID of the user group running the Tuxedo service. |
PW_TUPG_PROGRAM_GRP
The Tuxedo server process group table.
| Column Name | Column Description |
|---|---|
TUPG_TUPN_ID | The ID of the server process. |
TUPG_INGD_ID | The ID of the server process group running the Tuxedo service. |
PW_TUAG_ACTION_GRP
The Tuxedo service group table.
| Column Name | Column Description |
|---|---|
TUAG_TUAN_ID | The ID of the service. |
TUAG_INGD_ID | The ID of the service group running the Tuxedo service. |
PW_TUUN_USER_N
The Tuxedo user normalization table.
| Column Name | Column Description |
|---|---|
TUUN_ID | The ID of the user. |
TUUN_STRING_VALUE | The name of the users running the Tuxedo service. |
PW_TUPN_PROGRAM_N
The Tuxedo server process normalization table.
| Column Name | Column Description |
|---|---|
TUPN_ID | The ID of the server process. |
TUPN_STRING_VALUE | The name of the server process running the Tuxedo service. |
PW_TUAN_ACTION_N
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)/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. |