Neoview Repository User Guide (R2.4 SP1)

Table 3-11 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions (continued)
DescriptionData TypeField Name
Among processes that had more
than 30 dispatches, the greatest
number of dispatches for any
process
INTEGER UNSIGNEDMAX_NUMBER_OF_DISPATCHES
Count of processes with page faultsINTEGER UNSIGNEDNUMBER_OF_CHILDREN_W_PAGE_FAULTS
Among processes that had page
faults, the smallest number of page
faults
INTEGER UNSIGNEDMIN_NUMBER_OF_PAGE_FAULTS
Among processes that had page
faults, the average number of page
faults
INTEGER UNSIGNEDAVG_NUMBER_OF_ PAGE_FAULTS
Among processes that had page
faults, the maximum number of
page faults
INTEGER UNSIGNEDMAX_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 UNSIGNEDNUMBER_OF_CHILDREN_W_FILE_OPEN_CALLS
Among processes that had file open
calls, the minimum number of file
open calls
INTEGER UNSIGNEDMIN_NUMBER_OF_FILE_OPEN_CALLS
Among processes that had file open
calls, the average number of file
open calls
INTEGER UNSIGNEDAVG_NUMBER_OF_ FILE_OPEN_CALLS
Among processes that had file open
calls, the maximum number of file
open calls
INTEGER UNSIGNEDMAX_NUMBER_OF_ FILE_OPEN_CALLS
Number of processes that had
pages present in memory at the end
of the measurement interval
INTEGER UNSIGNEDNUMBER_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 UNSIGNEDMIN_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 UNSIGNEDAVG_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 UNSIGNEDMAX_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 65