Page History
...
In the Association area, click the row of the database you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays an overview of the database you want to investigate, and the Association area shows general details on the tables that are associated with the database you selected. For more information about Precise for Sybase tabs, see About Precise for Sybase tabs.
| Anchor | ||||
|---|---|---|---|---|
|
...
- I/O Size. Shows the size of the buffers in the pool. Specifies the amount of bytes that can be read at once. The default size of the pool is the size of the server's logical page.
- Config Size. The amount of memory space configured for the pool.
- Run Size. The amount of memory space currently assigned for the pool. The value may differ from the config size of the pool because one cannot explicitly configure its size. The value may differ for other pools if you have tried to move space between them, and some of the space could not be freed.
- Wash Size. Size of the Wash area. A portion of each pool is configured as the wash area. After dirty pages (pages that have been changed in cache) pass the wash marker and enter the wash area, Adaptive Server starts an asynchronous I/O on the page. When the write completes, the page is marked clean and remains available in the cache. The space in the wash area must be large enough so that the I/O on the buffer can complete before the page needs to be replaced. For more information, see the Precise Installation Guideand Administration.
- APF (%). Displays the percentage of the pool that can hold unused buffers brought in by asynchronous prefetch.
...
To examine distribution statistics of indexes and columns, use the Statistics view of the Column entity to help you see the distribution of values in that column. For more information about viewing these statistics, see About viewing density and selectivity statistics and About viewing column statistics.