I inquired dba_free_space at one of our customer sites but didn't find free space information about three datafiles out of 54 listed in dba_data_files. May I know what could be the possible reason for it? Could it be that there is no free space in these datafiles so they are not listed in dba_free_space?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.