Page History
...
Summarizes each sub component aggregated invocation.
Column Name | Column Description |
---|---|
WWAS_PWII_INSTANCE_ID | The instance ID. The instance entity represents a Web instance. |
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. |
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 |
---|---|
({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. |
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. |
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. |
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 |
---|---|
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:
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 |
---|---|
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:
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 |
---|---|
WWCI_NAME | The city from where the user is surfing. There are two special values:
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. |