Oscillating and stagnating plumes in the Earth's lower mantle