we killed oldest active transaction and suddenly all data files got 99% free space and we were able to release more than 120GB.

Can any experts here help me find why the database files showed no free space when the transaction waas active?