beautypg.com

Table statistics – HP Neoview Release 2.5 Software User Manual

Page 82

background image

Table C-2 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name

Count of processes with page
faults

INTEGER UNSIGNED

NUMBER_OF_CHILDREN_W_PAGE_FAULTS

Among processes that had page
faults, the smallest number of
page faults

INTEGER UNSIGNED

MIN_NUMBER_OF_PAGE_FAULTS

Among processes that had page
faults, the average number of
page faults

INTEGER UNSIGNED

AVG_NUMBER_OF_ PAGE_FAULTS

Among processes that had page
faults, the maximum number of
page faults

INTEGER UNSIGNED

MAX_NUMBER_OF_ PAGE_FAULTS

Number of processes with calls
to open regular files, pipes,
FIFOs, AF_INET sockets,
AF_UNIX sockets, directories,
and other files, including implicit
opens due to process creation
APIs

INTEGER UNSIGNED

NUMBER_OF_CHILDREN_W_FILE_OPEN_CALLS

Among processes that had file
open calls, the minimum number
of file open calls

INTEGER UNSIGNED

MIN_NUMBER_OF_FILE_OPEN_CALLS

Among processes that had file
open calls, the average number
of file open calls

INTEGER UNSIGNED

AVG_NUMBER_OF_ FILE_OPEN_CALLS

Among processes that had file
open calls, the maximum
number of file open calls

INTEGER UNSIGNED

MAX_NUMBER_OF_ FILE_OPEN_CALLS

Number of processes that had
pages present in memory at the
end of the measurement interval

INTEGER UNSIGNED

NUMBER_OF_CHILDREN_W_ PRES_PAGES_END

Among processes that had pages
present in memory at the end of
the interval, the minimum
number of pages present

INTEGER UNSIGNED

MIN_NUMBER_OF_ PRES_PAGES_END

Among processes that had pages
present in memory at the end of
the interval, the average number
of pages present

INTEGER UNSIGNED

AVG_NUMBER_OF_ PRES_PAGES_END

Among processes that had pages
present in memory at the end of
the interval, the maximum
number of pages present

INTEGER UNSIGNED

MAX_NUMBER_OF_ PRES_PAGES_END

Table Statistics

Table statistics are not turned on by default. If you want HP Support to enable table statistics,
please contact your HP Support representative.
The Repository includes two views that provide access to data about tables or materialized views
whose histogram statistics are missing or out of date. The views have identical column definitions
but satisfy different purposes:

82

Repository Views Disabled by Default