There are 10 spheres in total which you need all of them to unlock Aurons forth overdrive attack.

They don't have any effect on Tidus' overdrives, you gain them by just using them each a certain number of times.