Determining the Current Space for Rollback Records

To determine the number of pages a database currently reserves for rollbacks, issue lct_admin with the reserved_for_rollbacks parameter.

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 dbid of 5), issue:

select lct_admin("reserved_for_rollbacks", 5)

See the Reference Manual: Commands.