PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | The instance ID. 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_WWPS_PERF_SUMMARY_T
Summarizes each aggregated invocation per page.
Column Name | Column Description |
---|---|
WWPS_PWII_INSTANCE_ID | The instance (site) ID. The instance entity represents sites. Each site groups one or more domains. |
WWPS_TIMESTAMP | Time summary. |
WWPS_WWDO_ID | The domain ID. |
WWPS_WWPL_ID | The page ID. PW_WWPL_PAGE_LOOKUP lists available pages. |
WWPS_WWCT_ID | Communication in the user computer, where:
|
WWPS_WWCO_ID | The country ID. There are two special values: ' |
WWPS_WWST_ID | The state ID. There are two special values: ' |
WWPS_WWCI_ID | City the user connects from. There are two special values: ' |
WWPS_WWAT_ID | Indicates whether the page was abandoned. A page is abandoned when the page load to the user’s browser is not completed. Possible values include:
|
WWPS_INLD_ID | The location definition ID. A location is assigned according to user definitions (in the site map) and the Client IP.
|
WWPS_NAT_IP | The Client IP in long. The Client IP is needed in case the server is within the firewall neighborhood or the Firewall IP needed in case the server is outside the firewall. |
WWPS_CLIENT_IP | Private IP in long. The real Client IP. |
WWPS_WWCL_IP | The Client machine ID. PW_WWCL_CLIENT lists available client machine names. |
WWPS_WWLO_IP | The network user login ID. PW_WWLO_LOGIN lists available application user names. |
WWPS_WWAU_IP | The application user login ID. PW_WWAU_APPLICATION_USER lists available application user names. |
WWPS_PAGE_VIEW_SUM | Total amount of pages viewed for this aggregation. |
WWPS_EXTENDED_PAGE_VIEW_SUM | Total amount of supported pages viewed for this aggregation. Supported pages are executions whose performance can be measured. |
WWPS_BASIC_PAGE_VIEW_SUM | Total amount of unsupported pages viewed for this aggregation. Unsupported pages are executions whose performance cannot be measured. |
WWPS_ABANDON_COUNT_SUM | Total amount of abandoned pages for this aggregation. An abandoned page is an HTML-page left before it was fully loaded to the client browser. |
WWPS_TPCOUNT_SUM | Total amount of pages with a known text period for this aggregation. |
WWPS_TEXT_PRD_SUM | First byte period sum for this aggregation of pages. First byte is the period between the page request and the time the first byte arrives at the client browser. |
WWPS_RENDERING_PRD_SUM | Rendering period sum for this aggregation of pages. |
WWPS_SLA_UNKNOWN_SUM | Amount of pages whose SLA is unknown for this aggregation. |
WWPS_SLA_OK_SUM | Amount of pages whose SLA is OK for this aggregation. |
WWPS_SLA_WARNING_SUM | Amount of pages whose SLA is nearly breached for this aggregation. |
WWPS_SLA_SEVERE_SUM | Amount of pages whose SLA is breached for this aggregation. |
Expressions
Oracle | SQL Server | Expression Description |
---|---|---|
SUM(WWPS_PAGE_VIEW_SUM)*DECODE(greatest(SUM(WWPS_TPCOUNT_SUM),0) , 0, 0.0,((SUM(WWPS_TEXT_PRD_SUM)*1.0)/(SUM(WWPS_TPCOUNT_SUM)*1.0))) | SUM(WWPS_PAGE_VIEW_SUM)*CASE case when SUM(WWPS_TPCOUNT_SUM)>0 then SUM(WWPS_TPCOUNT_SUM) else 0 end when 0 then 0.0 else ((SUM(WWPS_TEXT_PRD_SUM)*1.0)/(SUM(WWPS_TPCOUNT_SUM)*1.0)) end | Total time of the first byte periods of pages. |
SUM(WWPS_PAGE_VIEW_SUM)*(decode(greatest(SUM(WWPS_TPCOUNT_SUM),0), 0, 0.0, ((SUM(WWPS_TEXT_PRD_SUM)*1.0)/(SUM(WWPS_TPCOUNT_SUM)*1.0)))+decode(greatest (SUM(WWPS_EXTENDED_PAGE_VIEW_SUM),0),0,-1.0,((SUM(WWPS_RENDERING_PRD_SUM)* 1.0)/(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM)*1.0)))) | SUM(WWPS_PAGE_VIEW_SUM)*(decode(greatest(SUM(WWPS_TPCOUNT_SUM),0), 0, 0.0, ((SUM(WWPS_TEXT_PRD_SUM)*1.0)/(SUM(WWPS_TPCOUNT_SUM)*1.0)))+decode(greatest (SUM(WWPS_EXTENDED_PAGE_VIEW_SUM),0),0,-1.0,((SUM(WWPS_RENDERING_PRD_SUM)* 1.0)/(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM)*1.0)))) | Total wait time of pages. |
SUM(WWPS_PAGE_VIEW_SUM)*decode(greatest(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM),0), 0,-1.0,((SUM(WWPS_RENDERING_PRD_SUM)*1.0)/(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM)*1.0))) | SUM(WWPS_PAGE_VIEW_SUM)*decode(greatest(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM),0), 0,-1.0,((SUM(WWPS_RENDERING_PRD_SUM)*1.0)/(SUM(WWPS_EXTENDED_PAGE_VIEW_SUM)*1.0))) | Total rendering time of pages. |
PW_WWSC_SUMMARY_T
Summarizes each sub component aggregated invocation.
Column Name | Column Description |
---|---|
WWSC_PWII_INSTANCE_ID | The Web instance (site) ID. The instance entity represents Web instances or sites. Each site groups one or more domains. |
WWSC_TIMESTAMP | Time summary. |
WWSC_PWII_INSTANCE_ID_PAGE | The page instance ID. The instance entity represents a Web instance. |
WWSC_WWDO_ID_PAGE | The page domain ID. PW_WWO_DPOMAIN lists available domain names. |
WWSC_WWDO_ID | The domain ID. PW_WWO_DOMAIN lists available domain names. |
WWSC_WWPL_ID | The page ID. PW_WWPL_PAGE_LOOKUP lists available pages. |
WWSC_WWUL_ID | The URL ID. PW_WWUL_URL_LOOKUP lists available URLs. |
WWSC_WWCT_ID | Communication in the user computer, where:
|
WWSC_WWCO_ID | The country ID. There are two special values: ' |
WWSC_WWST_ID | The state ID. There are two special values: ' |
WWSC_WWCI_ID | City the user connects from. There are two special values: ' |
WWSC_INLD_ID | The location definition ID. A location is assigned according to user definitions (in the site map) and the Client IP.
|
WWSC_NAT_IP | The Client IP in long. The Client IP is needed in case the server is within the firewall neighborhood or the Firewall IP needed in case the server is outside the firewall. |
WWSC_CLIENT_IP | Private IP in long. The real Client IP. |
WWSC_WWCL_IP | The Client machine ID. PW_WWCL_CLIENT lists available client machine names. |
WWSC_WWLO_IP | The network user login ID. PW_WWLO_LOGIN lists available application user names. |
WWSC_WWAU_IP | The application user login ID. PW_WWAU_APPLICATION_USER lists available application user names. |
WWSC_HIT_SUM | Total amount of URL requests for this aggregation. |
WWSC_CLIENT_CACHE_SUM | Total amount of URLs retrieved from caching for this aggregation. |
WWSC_ERROR_SUM | Total amount of URLs that ended with an error for this aggregation. |
WWSC_BYTE_SUM | Total amount of bytes transferred during the send and receive actions. |
WWSC_SERVER_PRD_SUM | The summarized server period for this aggregation. The server time is the period spent in the Web server. |
WWSC_NETWORK_PRD_SUM | The summarized network period for this aggregation. The network time is the period spent in the network. |
WWSC_SLA_UNKNOWN_SUM | Amount of pages whose SLA is unknown for this aggregation. |
WWSC_SLA_OK_SUM | Amount of pages whose SLA is OK for this aggregation. |
WWSC_SLA_WARNING_SUM | Amount of pages whose SLA is nearly breached for this aggregation. |
WWSC_SLA_SEVERE_SUM | Amount of pages whose SLA is breached for this aggregation. |