OAM-pages are used when performing a table scan on a DOL-table. These OAM-pages refer to allocation-units, which must then be scanned to find the extents on the pages for the table being scanned. When the scan is started, a list of pages is generated the information in the allocation-page. Any newly allocated pages produced by another process in this allocation-unit are not seen by the scanning process as they were not allocated when the scan began. This is due to the way DOL-tables are implemented. If you want to include the newly allocated pages,
use isolation level 3 type of scans (select with holdlock) or,
add an index to the DOL-table which can be used to prevent a table-scan or,
convert the DOL-table to an APL-table.
| Copyright © 2006. Sybase Inc. All rights reserved. |
|
|
