Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Old Version 3

changes.mady.by.user Nadja Pollard

Saved on Mar 10, 2021

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on Mar 10, 2021

Key

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

...

Summarizes each sub component aggregated invocation.

Column Name	Column 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 Name	Column 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

PRES Expression Description

PRES	Expression 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.

({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 Name	Column 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 Name	Column 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

Oracle	SQL Server	Expression Description
`WWPL_PATH_PART\|\|WWPL_SPLITTER\|\|WWPL_PARM_PART`	`WWPL_PATH_PART+WWPL_SPLITTER+WWPL_PARM_PART`	Page URL.

PW_WWUL_URL_LOOKUP

List of URLs.

Column Name	Column 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

Oracle	SQL Server	Expression Description
`WWUL_PATH_PART\|\|WWUL_SPLITTER\|\|WWUL_PARM_PART`	`WWUL_PATH_PART+WWUL_SPLITTER+WWUL_PARM_PART`	Page URL.

PW_WWDO_DOMAIN

List of domains.

Column Name	Column Description
`WWDO_NAME`	Name of the domain.

PW_WWCO_COUNTRY

List of countries from where users are surfing.

Column Name Column Description

Column Name	Column 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.

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 Name Column Description

Column Name	Column 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.

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 Name Column Description

Column Name	Column 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.

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 Name	Column 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 Name	Column Description
`WWAU_NAME`	The application user login name.

PW_WWLO_LOGIN

List of user logins.

Column Name	Column Description
`WWLO_LOGIN`	The login name of the user.

PW_WWCR_COUNTER

List of instance statistics counters.

Column Name	Column Description
`WWCR_NAME`	The instance statistic counter name.

PW_WWBT_BUSINESS_TRAN_GRP_VIEW

Basic transaction grouping view.

Column Name	Column Description
`INGD_NAME`	The business transaction group name.
`WWPL_NAME`	The page URL.

PW_WWAG_URL_GRP_VIEW

URL Grouped grouping view.

Column Name	Column Description
`INGD_NAME`	The URL Grouped group name.
`WWUL_NAME`	The URL.

PW_WWIG_INSTANCE_GRP_VIEW

Instance Grouped grouping view.

Column Name	Column Description
`INGD_NAME`	The Instance Grouped group name.
`INCE_NAME`	The instance name.

PW_WWPG_PSOFT_PANEL_GRP_VIEW

PeopleSoft Panel grouping view.

Column Name	Column 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 Name	Column Description
`INGD_NAME`	The Page Siebel View group name.
`WWPB_VIEW`	The Page Siebel view.

PW_WWSG_SERVER_GRP_VIEW

Servers grouping view.

Column Name	Column Description
`INGD_NAME`	The server group name.
`INSM_NAME`	The server name.

PW_WWSL_SBL_TITLE_GRP_VIEW

Siebel Title Grouped grouping view.

Column Name	Column 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 Name	Column Description
`INGD_NAME`	The SAP Title Grouped group name.
`WWPL_TITLE`	The SAP title.

PW_WWTG_TRANSACTION_GRP_VIEW

Transaction Grouped grouping view.

Column Name	Column 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 Name	Column 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 Name	Column Description
`INGD_NAME`	The URL Siebel View group name.
`WWUB_VIEW`	The URL Siebel view.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools

Versions Compared

Old Version 3

New Version Current

Key

PW_WWCS_COUNTER_STATISTIC_T

Expressions

PW_WWCM_COMMON_STATISTIC_T

PW_WWPL_PAGE_LOOKUP

Expressions

PW_WWUL_URL_LOOKUP

Expressions

PW_WWDO_DOMAIN

PW_WWCO_COUNTRY

PW_WWST_STATE

PW_WWCI_CITY

PW_WWCL_CLIENT

PW_WWAU_APPLICATION_USER

PW_WWLO_LOGIN

PW_WWCR_COUNTER

PW_WWBT_BUSINESS_TRAN_GRP_VIEW

PW_WWAG_URL_GRP_VIEW

PW_WWIG_INSTANCE_GRP_VIEW

PW_WWPG_PSOFT_PANEL_GRP_VIEW

PW_WWPV_PAGE_SBL_VIEW_GRP_VIEW

PW_WWSG_SERVER_GRP_VIEW

PW_WWSL_SBL_TITLE_GRP_VIEW

PW_WWST_SAP_TITLE_GRP_VIEW

PW_WWTG_TRANSACTION_GRP_VIEW

PW_WWUE_URL_EXT_GRP_VIEW

PW_WWUV_URL_SBL_VIEW_GRP_VIEW