The Open Objects I/O sub-page displays a grid that shows a listing of each object on the selected database (selected on the Databases grid) that is either open, or has been open, and related I/O activity.
Objects are only removed from the list if the configured number of "open objects" is exceeded. Then they are aged out to make room for newly opened objects.
The following table defines the columns on the Open Objects I/O for Database grid:
|
Column |
Definition |
|
Object Name |
Name of the object. Each name can be expanded to show which objects belong to a table. |
|
Logical Reads |
Total number of buffers read |
|
Physical Reads |
Number of buffers read from disk |
|
APF Reads |
Number of Asynchronous Pre-Fetch buffers read |
|
Pages Read |
Total number of pages read |
|
Physical Writes |
Total number of buffers written to disk |
|
Pages Written |
Total number of pages written to disk |
|
Rows Inserted |
Number of rows inserted |
|
Rows Deleted |
Number of rows deleted |
|
Rows Updated |
Number of rows updated |
*The Open Objects I/O sub-page only displays in Adaptive Server versions 12.5.0.3 or later.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
