cache found from Adobe software which occupied most storage of my macbook

Hi Eunice,

Welcome to the Community.

Media cache files are temporary files that can be deleted without any harm to your project. Here's how you can remove them: https://community.adobe.com/t5/after-effects/faq-how-to-clean-delete-or-trash-media-cache-files-in-after-effects/td-p/10634312?page=1

Hope it helps.

Thanks,

Nishu