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
