PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_ID

The instance ID. Columns of XXXX_PWII_INSTANCE_ID have values from the column.

PWII_INSTANCE_NAME

Name of the instance.

PWII_TECHNOLOGY

Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).

PWII_SERVER

Name of the server on which the instance is installed.

PW_WWPS_PERF_SUMMARY_T

Summarizes each aggregated invocation per page.

Column NameColumn Description
WWPS_PWII_INSTANCE_ID

The instance (site) ID. The instance entity represents sites.

Each site groups one or more domains. PS_INCE_INSTANCE lists available instances or sites.

WWPS_TIMESTAMP

Time summary.

WWPS_WWDO_ID

The domain ID. PW_WWO_DOMAIN lists available domain names.

WWPS_WWPL_IDThe page ID. PW_WWPL_PAGE_LOOKUP lists available pages.
WWPS_WWCT_ID

Communication in the user computer, where:

0 = unknown

1 = offline

2 = LAN

3 = modem

WWPS_WWCO_ID

The country ID. PW_WWCO_COUNTRY lists available country names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

WWPS_WWST_ID

The state ID. PW_WWST_STATE lists available United States state names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

WWPS_WWCI_ID

City the user connects from. PW_WWCT_CITY lists available US city names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

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:

-1 = unknown

0 = completed

1 = abandoned

WWPS_INLD_ID

The location definition ID. A location is assigned according to user definitions (in the site map) and the Client IP.

PS_INLD_LOCATION_DEFS lists available locations.

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_IPPrivate IP in long. The real Client IP.
WWPS_WWCL_IPThe Client machine ID. PW_WWCL_CLIENT lists available client machine names.
WWPS_WWLO_IPThe network user login ID. PW_WWLO_LOGIN lists available application user names.
WWPS_WWAU_IPThe application user login ID. PW_WWAU_APPLICATION_USER lists available application user names.
WWPS_PAGE_VIEW_SUMTotal 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_SUMTotal 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_SUMRendering period sum for this aggregation of pages.
WWPS_SLA_UNKNOWN_SUMAmount of pages whose SLA is unknown for this aggregation.
WWPS_SLA_OK_SUMAmount of pages whose SLA is OK for this aggregation.
WWPS_SLA_WARNING_SUMAmount of pages whose SLA is nearly breached for this aggregation.
WWPS_SLA_SEVERE_SUMAmount of pages whose SLA is breached for this aggregation.

Expressions

OracleSQL ServerExpression 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 NameColumn 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. PS_INCE_INSTANCE lists available instances or sites.

WWSC_TIMESTAMP

Time summary.

WWSC_PWII_INSTANCE_ID_PAGE

The page instance ID. The instance entity represents a Web instance. PS_INCE_INSTANCE lists available instances.

WWSC_WWDO_ID_PAGEThe page domain ID. PW_WWO_DPOMAIN lists available domain names.
WWSC_WWDO_IDThe domain ID. PW_WWO_DOMAIN lists available domain names.
WWSC_WWPL_IDThe page ID. PW_WWPL_PAGE_LOOKUP lists available pages.
WWSC_WWUL_IDThe URL ID. PW_WWUL_URL_LOOKUP lists available URLs.
WWSC_WWCT_ID

Communication in the user computer, where:

0 = unknown

1 = offline

2 = LAN

3 = modem

WWSC_WWCO_ID

The country ID. PW_WWCO_COUNTRY lists available country names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

WWSC_WWST_ID

The state ID. PW_WWST_STATE lists available United States state names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

WWSC_WWCI_ID

City the user connects from. PW_WWCT_CITY lists available US city names.

There are two special values: '++' for unknown and '--' for internal, which means the user connects from within the IP range of the company.

WWSC_INLD_ID

The location definition ID. A location is assigned according to user definitions (in the site map) and the Client IP.

PS_INLD_LOCATION_DEFS lists available locations.

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_IPPrivate IP in long. The real Client IP.
WWSC_WWCL_IPThe Client machine ID. PW_WWCL_CLIENT lists available client machine names.
WWSC_WWLO_IPThe network user login ID. PW_WWLO_LOGIN lists available application user names.
WWSC_WWAU_IPThe 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_SUMAmount of pages whose SLA is unknown for this aggregation.
WWSC_SLA_OK_SUMAmount of pages whose SLA is OK for this aggregation.
WWSC_SLA_WARNING_SUMAmount of pages whose SLA is nearly breached for this aggregation.
WWSC_SLA_SEVERE_SUMAmount of pages whose SLA is breached for this aggregation.

PW_WWAS_AVAILABILITY_SUMMARY_T

Summarizes each sub component aggregated invocation.

Column NameColumn Description
WWAS_PWII_INSTANCE_ID

The instance ID. The instance entity represents a Web instance. PS_INCE_INSTANCE lists available instances.

WWAS_TIMESTAMP

Time summary.

WWAS_AVAIL_WITH_DOWNTIME_SUM

Average availability percentage calculated with downtime.

WWAS_UNAVAIL_WITH_DOWNTIME_SUM

Summed time of unavailability calculated with downtime.

WWAS_AVAIL_AVG

Average availability percentage calculated without downtime.

WWAS_UNAVAIL_SUM

Summed time of unavailability calculated without downtime.

PW_WWCS_COUNTER_STATISTIC_T

Summarizes each webserver counter aggregated invocation.

Column NameColumn Description
WWCS_PWII_INSTANCE_ID

The instance ID. The instance entity represents a Web instance. PS_INCE_INSTANCE lists available instances.

WWCS_TIMESTAMP

Time summary.

WWCS_WWCR_ID

Web servers counter ID. The counter name (Performance Counter) can be found in PW_WWCR_COUNTER.

WWCS_COUNTER_SUM

Represents the value for the counter that summarize data. Null if the counter does not summarize

WWCS_COUNTER_AVG

Represents the value for the counter that average data. Null if the counter does not average.

WWCS_COUNTER_MAX

Represents the value for the counter that holding maximum values. Null if the counter does not holds maximum values.

Expressions

PRESExpression Description
({pss nvl(SUM(WWCS_COUNTER_SUM * 1.0), 0.0)} + {pss nvl(MAX(WWCS_COUNTER_MAX * 1.0), 0.0)} + {pss nvl(AVG(WWCS_COUNTER_AVG * 1.0), 0.0)})

The counter aggregate values.

Because each counter value is one of the three counter columns, this formula is calculating the value regardless of which column is used.

PW_WWCM_COMMON_STATISTIC_T

Summarizes each common counter aggregated invocation.

Column NameColumn Description
WWCM_PWII_INSTANCE_ID

The instance ID. The instance entity represents a Web instance. PS_INCE_INSTANCE lists available instances.

WWCM_TIMESTAMP

Time summary.

WWCM_COUNTER1_SUM

Amount of requests per instance.

WWCM_COUNTER2_SUM

Average concurrent connections per instance.

WWCM_COUNTER3_SUM

Average amount of memory being used by this web server.

WWCM_COUNTER4_SUM

Average amount of page faults in this web server.

WWCM_COUNTER5_SUM

Average amount of CPU being used by this web server.

WWCM_COUNTER6_SUM

Average amount of cache hit ratio in this web server.

WWCM_COUNTER7_SUM

Not in use.

PW_WWPL_PAGE_LOOKUP

List of pages.

Column NameColumn Description
WWPL_URL_ID

The URL ID.

WWPL_WWDO_ID

The domain ID. PW_WWDO_DOMAIN lists available domain names.

WWPL_PROTOCOL

Protocol. The data transfer standard (HTTP, HTTPS).

WWPL_PATH_PART

The part of the path inside the URL.

WWPL_SPLITTER

The character(s) used to separate the path and the parameters.

WWPL_PARM_PART

The parameters. For example: a=1&b=2&c=3.

WWPL_URL_FILE_EXT

File extension. For example: html, htm, asp, jsp.

WWPL_TITLE

Page title.

Expressions

OracleSQL ServerExpression Description
WWPL_PATH_PART||WWPL_SPLITTER||WWPL_PARM_PARTWWPL_PATH_PART+WWPL_SPLITTER+WWPL_PARM_PARTPage URL.

PW_WWUL_URL_LOOKUP

List of URLs.

Column NameColumn Description
WWUL_URL_ID

The URL ID.

WWUL_WWDO_ID

The domain ID. PW_WWDO_DOMAIN lists available domain names.

WWUL_PROTOCOL

Protocol. The data transfer standard (HTTP, HTTPS).

WWUL_PATH_PART

The part of the path inside the URL.

WWUL_SPLITTER

The character(s) used to separate the path and the parameters.

WWUL_PARM_PART

The parameters. For example: a=1&b=2&c=3.

WWUL_URL_FILE_EXT

File extension. For example: html, htm, asp, jsp.

Expressions

OracleSQL ServerExpression Description
WWUL_PATH_PART||WWUL_SPLITTER||WWUL_PARM_PARTWWUL_PATH_PART+WWUL_SPLITTER+WWUL_PARM_PARTPage URL.

PW_WWDO_DOMAIN

List of domains.

Column NameColumn Description
WWDO_NAMEName of the domain.

PW_WWCO_COUNTRY

List of countries from where users are surfing.

Column NameColumn Description
WWCO_INITIAL

The country initials from where the user is surfing. For example: IL - Israel.

WWCO_NAME

The country from where the user is surfing. There are two special values:

  • unknown
  • internal

Internal means that the user is surfing from within the IP range of the company.

PW_WWST_STATE

List of states from where users are surfing.

Column NameColumn Description
WWST_INITIAL

The state initials from where the user is surfing. For example: TX - Texas.

WWST_NAME

The state from where the user is surfing. There are two special values:

  • unknown
  • internal

Internal means that the user is surfing from within the IP range of the company.

PW_WWCI_CITY

List of cities from where users are surfing.

Column NameColumn Description
WWCI_NAME

The city from where the user is surfing. There are two special values:

  • unknown
  • internal

Internal means that the user is surfing from within the IP range of the company.

PW_WWCL_CLIENT

List of user client machines.

Column NameColumn Description
WWCL_CLIENT

The client machine name.

PW_WWAU_APPLICATION_USER

List of the application users. This is the user name for entering PeopleSoft.

Column NameColumn Description
WWAU_NAME

The application user login name.

PW_WWLO_LOGIN

List of user logins.

Column NameColumn Description
WWLO_LOGIN

The login name of the user.

PW_WWCR_COUNTER

List of instance statistics counters.

Column NameColumn Description
WWCR_NAME

The instance statistic counter name.

PW_WWBT_BUSINESS_TRAN_GRP_VIEW

Basic transaction grouping view.

Column NameColumn Description
INGD_NAME

The business transaction group name.

WWPL_NAME

The page URL.

PW_WWAG_URL_GRP_VIEW

URL Grouped grouping view.

Column NameColumn Description
INGD_NAME

The URL Grouped group name.

WWUL_NAME

The URL.

PW_WWIG_INSTANCE_GRP_VIEW

Instance Grouped grouping view.

Column NameColumn Description
INGD_NAME

The Instance Grouped group name.

INCE_NAME

The instance name.

PW_WWPG_PSOFT_PANEL_GRP_VIEW

PeopleSoft Panel grouping view.

Column NameColumn Description
INGD_NAME

The PeopleSoft Panel group name.

WWPL_TITLE

The PeopleSoft Panel name.

PW_WWPV_PAGE_SBL_VIEW_GRP_VIEW

Page Siebel View grouping view.

Column NameColumn Description
INGD_NAME

The Page Siebel View group name.

WWPB_VIEW

The Page Siebel view.

PW_WWSG_SERVER_GRP_VIEW

Servers grouping view.

Column NameColumn Description
INGD_NAME

The server group name.

INSM_NAME

The server name.

PW_WWSL_SBL_TITLE_GRP_VIEW

Siebel Title Grouped grouping view.

Column NameColumn Description
INGD_NAME

The Siebel Title Grouped group name.

WWPL_TITLE

The Siebel title.

PW_WWST_SAP_TITLE_GRP_VIEW

SAP Title Grouped grouping view.

Column NameColumn Description
INGD_NAME

The SAP Title Grouped group name.

WWPL_TITLE

The SAP title.

PW_WWTG_TRANSACTION_GRP_VIEW

Transaction Grouped grouping view.

Column NameColumn Description
INGD_NAME

The Transaction Grouped group name.

WWTG_TITLE

The transaction title.

PW_WWUE_URL_EXT_GRP_VIEW

URL File Extension Grouped grouping view.

Column NameColumn Description
INGD_NAME

The URL File Extension Grouped group name.

WWUL_URL_FILE_EXT

The URL File Extension.

PW_WWUV_URL_SBL_VIEW_GRP_VIEW

URL Siebel View grouping view.

Column NameColumn Description
INGD_NAME

The URL Siebel View group name.

WWUB_VIEW

The URL Siebel view.

IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal