Yea, OSCommerce is pretty stable but I have never seen it under a high loaded server. Like Andrew was saying the best setup for a very high traffic site would be to place the php/html files on 1 server and the mySQL on another. If it is a high traffic site you may want to use dual Xeon's for both servers and at least 1 GB RAM.
Also, look around at some other shopping carts. Not trying to put OScommerce down but there are some nice paid programs out there. One that some of my customers use is Turnkey Web Tools (
http://www.turnkeywebtooks.com) < Not my site >