Chapter 15: Managing Free Space with Thresholds

Using lct_admin to determine the free log space

Use logsegment_freepages to determine the amount of free space your dedicated log segment has. The syntax is:

lct_admin("logsegment_freepages", database_id)

To see the number of free pages for the pubs2 database log segment:

select lct_admin("logsegment_freepages", 4)
---------------------
                      79