Versions Compared

Old Version 3

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Tuxedo service normalization table.

Column NameColumn 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 NameColumn 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 NameColumn 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 NameColumn Description
TUAC_PWII_INSTANCE_ID

The ID of the Tuxedo domain running the Tuxedo service.

TUAC_TIMESTAMP

The

name of the Tuxedo service

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

OracleSQL ServerExpression Description
SUM(
OAAC
TUAC_
NETWORK
TIME1_
TIME_
SUM+
OAAC
TUAC_
TIME1
TIME2_SUM)SUM(
OAAC
TUAC_
NETWORK_TIME
TIME1_SUM+
OAAC
TUAC_
TIME1
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_
TIME2
REQUESTS_SUM
+
,0,1, TUAC_
TIME3
REQUESTS_SUM))
SUM(TUAC_TIME1_
SUM+
TIME_SUM)/sum(decode(TUAC_
TIME2
REQUESTS_SUM
+
,0,1, TUAC_
TIME3
REQUESTS_SUM))

Average time the Tuxedo service waited in a queue.

SUM(TUAC_
TIME1
TIME2_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM))
SUM(TUAC_
TIME1
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_
TIME2
TIME3_TIME_SUM)/sum(decode(TUAC_REQUESTS_SUM,0,1, TUAC_REQUESTS_SUM))
SUM(TUAC_
TIME2
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_
TIME3_TIME
TIME1_SUM+TUAC_TIME2_SUM)/sum(decode(TUAC_REQUESTS_SUM, 0,1,TUAC_REQUESTS_SUM))SUM(TUAC_TIME1_
TIME3
SUM+TUAC_
TIME
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_
TIME1
REQUESTS_SUM
+
-TUAC_
TIME2
RED_SUM
+
-TUAC_
TIME3
YELLOW_SUM
)/sum(decode (
-TUAC_
REQUESTS
GREEN_SUM
,0,1,TUAC_REQUESTS_SUM
)
)
SUM(TUAC_
TIME1
REQUESTS_SUM
+
-TUAC_
TIME2
RED_SUM
+
-TUAC_
TIME3
YELLOW_SUM
)/sum(decode (TUAC_REQUESTS_SUM,0,1,TUAC_REQUESTS
-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))*100SUM(TUAC_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100Percentage 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 NameColumn 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

OracleSQL ServerExpression 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))*100SUM(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 NameColumn 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

YELLOWYELLOW
OracleSQL ServerExpression 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_GREEN_SUM)/sum(decode(TUAC_RED_SUM+TUAC_YELLOW_SUM+ TUAC_GREEN_SUM,0,1,TUAC_RED_SUM+TUAC_YELLOW_SUM+TUAC_GREEN))*100SUM(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.

Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 |  
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
  | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse