Flow pattern and heat transfer enhancement in self-sustained oscillatory flows