What biblical evidence or otherwise is there that....weight of prayer plays any role?

On that note, as god is all knowing anyway, what exactly is the point?