This view shows the objects in Adaptive Server databases and the page I/Os associated with them. It shows the Adaptive Server database name and ID, and the object names and IDs within each database. For each object, this view shows the associated logical reads, physical reads, and page writes for both the most recent sample interval and for the session.
SMC_SIZET object_page_io_count = 10;
SMC_DATAITEM_STRUCT object_page_io_view[] = {
{ SMC_NAME_DB_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DB_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_NAME, 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 },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SESSION }
};
