You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_IDID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column.
PWII_INSTANCE_NAMEName of the instance.
PWII_TECHNOLOGYTwo characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).
PWII_SERVERName of the server on which the instance is installed.

PW_OTSG_SERVER_GRP

The other server group table.

Column NameColumn Description
OTSG_INSM_IDThe ID of the servers.
OTSG_INGD_IDThe ID of the server group running the Other Application Tier network requests.

PW_NTVN_SERVER_IP_N

The Insight network and other server IP normalization table.

Column NameColumn Description
NTVM_IDThe ID of the server IP.
NTVM_STRING_VALUEThe name of the server IP.

PW_NTCN_CONSUMER_IP_N

The Insight network and other client IP normalization table.

Column NameColumn Description
NTCN_IDThe ID of the client IP.
NTCN_STRING_VALUEThe name of the client IP.

PW_OTAC_VIEW_T

The other AppTier network activity summarized by each aggregated invocation.

Column NameColumn Description

OTAC_TIMESTAMP

The time summary.
OTAC_PWII_INSTANCE_IDThe ID of the instance running the Other Application Tier network requests.
OTAC_CONSUMER_IPThe ID of the client IP running the Other Application Tier network requests.
OTAC_CONSUMER_IP_GIDThe ID of the client IP group running the Other Application Tier network requests.
OTAC_ID1The ID of the server IP running the Other Application Tier network requests.
OTAC_NETWORK_TIME_SUMRound-trip Other Application Tier activity network time between the Other Application Tier client and the Application server.
OTAC_STAT1_SUMTotal number of network packets, transferred while running the Other Application Tier network requests.
OTAC_STAT2_SUMTotal number of network bytes, transferred while running the Other Application Tier network requests.
OTAC_TIME1_SUMTotal Other application tier activity processing time. This time includes the time the Other Application Tier waited for other Other Application Tiers.
OTAC_REQUESTS_SUMTotal number of Other Application Tier network requests.
OTAC_RED_SUMTotal number of Other Application Tier activity executions, which Breached their SLA.
OTAC_YELLOW_SUMTotal number of Other Application Tier activity executions, which Near Breached their SLA.
OTAC_GREEN_SUMTotal number of Other Application Tier activity executions, which did Not Breach their SLA.

Expressions

Oracle SQL Server Expression description
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,OTA C_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_S UM)/sum(decode(OTAC_R EQUESTS_SUM,0,1,OTAC_ REQUESTS_SUM)) sum(OTAC_TIME1_TIME_S UM)/sum(decode(OTAC_R EQUESTS_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_REQUE STS_SUM,0,1,OTAC_REQU ESTS_SUM)) sum(OTAC_NETWORK_TIME
_SUM+OTAC_TIME1_SUM)/ sum(decode(OTAC_REQUE STS_SUM,0,1,OTAC_REQU ESTS_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_YE LLOW_SUM-OTAC_GREEN_S UM) sum(OTAC_REQUESTS_SUM
-OTAC_RED_SUM-OTAC_YE LLOW_SUM-OTAC_GREEN_S UM) 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_RE D_SUM+OTAC_YELLOW_SUM
+OTAC_GREEN))*100 sum(OTAC_RED_SUM)/sum (decode(OTAC_RED_SUM+ OTAC_YELLOW_SUM+OTAC_ GREEN_SUM,0,1,OTAC_RE D_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_S UM+OTAC_YELLOW_SUM+OT AC_GREEN_SUM,0,1,OTAC
_RED_SUM+OTAC_YELLOW_ SUM+OTAC_GREEN))*100 sum(OTAC_YELLOW_SUM)/ sum(decode(OTAC_RED_S UM+OTAC_YELLOW_SUM+OT AC_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)/s um(decode(OTAC_RED_SU M+OTAC_YELLOW_SUM+OTA C_GREEN_SUM,0,1,OTAC_ RED_SUM+OTAC_YELLOW_S UM+OTAC_GREEN))*100 sum(OTAC_GREEN_SUM)/s um(decode(OTAC_RED_SU M+OTAC_YELLOW_SUM+OTA C_GREEN_SUM,0,1,OTAC_ RED_SUM+OTAC_YELLOW_S UM+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.
PW_NTAC_VIEW_T
The network activity summarized by each aggregated invocation.
Column name Column description
NTAC_TIMESTAMP The time summary.
NTAC_PWII_INSTANCE_ID The ID of the AppTier instance running the network requests.
OTAC_CONSUMER_IP The ID of the client IP running the network requests.
NTAC_CONSUMER_IP_GID The ID of the client IP group running the network requests.
NTAC_ID1 The ID of the server IP running the network requests.
NTAC_NETWORK_TIME_SUM Round-trip network time between the Application client and the Application server.
NTAC_STAT1_SUM Total number of network packets, transferred while running the network requests.
NTAC_STAT2_SUM Total number of network bytes, transferred while running the network requests.
NTAC_REQUESTS_SUM Total number of network requests.
Expressions
Oracle SQL Server Expression description
sum(NTAC_NETWORK_TIME_ SUM)/sum(decode(NTAC_R EQUESTS_SUM,0,1,NTAC_R EQUESTS_SUM))sum(NTAC_ NETWORK_TIME_SUM+NTAC_ TIME1_SUM) sum(NTAC_NETWORK_TIME_S UM)/sum(decode(NTAC_REQ UESTS_SUM,0,1,NTAC_REQU ESTS_SUM))sum(NTAC_NETW ORK_TIME_SUM+NTAC_TIME1
_SUM) Average round-trip network time between the
Application client and the Application server.


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels