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