This view represents the page I/Os by database object for each Adaptive Server process. It shows the login name, Process ID, and Kernel Process ID for each process that had page I/Os during the most recent sample interval.
For each such process and for each database object it accessed, the view also shows the object name, object ID, and the object’s database name and ID, plus the page I/Os associated the object.
The view also shows the total page I/Os, the percentage of page I/O requests that could be satisfied by the Adaptive Server cache, and the number of logical page reads, physical page reads, and page writes for the most recent sample interval.
hs_create_view process_object_page_io, "Login Name", "Value for Sample", "Process ID", "Value for Sample", "Kernel Process ID", "Value for Sample", "Database Name", "Value for Sample", "Database ID", "Value for Sample", "Object Name", "Value for Sample", "Object ID", "Value for Sample", "Object Type", "Value for Sample", "Page I/O", "Value for Sample", "Page Hit Percent", "Value for Sample", "Logical Page Reads", "Value for Sample", "Physical Page Reads", "Value for Sample", "Page Writes", "Value for Sample"
