To determine the number of pages a database currently reserved for rollbacks, issue lct_admin with the reserved_for_rollbacks parameter. The partial syntax for lct_admin is:
select lct_admin ("reserved_for_rollbacks", dbid)
The number of pages returned are the number reserved, but not yet allocated, for rollback records.
For example, to determine the number of pages reserved for rollbacks in the pubs2 database (which has a pubid of 5), issue the following:
select lct_admin("reserved_for_rollbacks", 5)
See the Reference Manual for more information about lct_admin.
