Thanks @Jason-MSFT for your reply.
I am unable to understand how a share can be accessed using TFTP without authentication. Is there any document around this?

Hi, Thanks for the reply.
I just queried from the view as well and the size is still the same of what I had got from table.

Thank you!

Hi, Thanks for the reply. As I already mentioned in my initial post, I have already executed and deleted all orphaned packages using ContentLibraryCleanup.exe