A Refined Analysis of Massive Activations in LLMs