Partition Function of Non-Supersymmetric Black Holes in the Supergravity Limit