Use the 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 amount of free pages for the pubs2 database log segment:
select lct_admnin("logsegment_freepages", 4)
---------------------
79
