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