Table statistics – HP Neoview Release 2.5 Software User Manual
Page 82
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