This view shows the page I/Os by database object for each Adaptive Server process. For each process that had page I/Os during the most recent sample interval it shows the:
Login name
Process ID
Kernel Process ID
For each such process and for each database object it accessed, the view shows the:
Object name
Object ID
Database name and ID
Page I/Os
The view also shows the total page I/Os, the percentage of page I/O requests that could be satisfied by Adaptive Server cache, and the number of logical reads, physical reads, and page writes for the most recent sample interval.
SMC_SIZET process_object_page_io_count = 13;
SMC_DATAITEM_STRUCT process_object_page_io_view[] = {
{ SMC_NAME_LOGIN_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_SPID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_KPID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DB_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DB_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_TYPE, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_IO, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SAMPLE }
};
