Andreas Korneliussen wrote:
> Problem:
> For holdable cursors, we will release the table intent lock when doing
> commit on the transaction for the cursor.
>
> The table intent lock, prevents the system from doing a compress of the
> table, causing all RowLocations to be invalid. In addition, it prevents
> reuse of RowLocation for deleted + purged rows.
I think this last paragraph is an incorrect assuption. The table intent
lock prevents other transactions from doing a compress, but not the
transaction holding the lock.
I think there are other situations where the RowLocation will become
invalid, such as the transaction deleteing the row.
Dan.
|