Versions Compared

Key

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

...

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.



Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse