Table statistics – HP Neoview Release 2.4 Software User Manual
Page 47
Table 3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)
Description
Data Type
Field Name
Among processes that had more
than 30 dispatches, the greatest
number of dispatches for any
process
INTEGER UNSIGNED
MAX_NUMBER_OF_DISPATCHES
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
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:
Table Statistics
47