Using lct_admin to Determine the Free Log Space

Use logsegment_freepages to determine the amount of free space your dedicated log segment has.

To see the number of free pages for the pubs2 database log segment, enter:
select lct_admin("logsegment_freepages", 4)
---------------------
                      79