I recently stumbled across an issue where by the frontend wasn’t displaying the latest code that had been uploaded to the live site.
There are a few options I discovered to clear the APC cache
1) Do a graceful restart on httpd
2) Add a module to Magento to clear the APC cache on prompt example extension http://www.magentocommerce.com/magento-connect/clean-apc-cache.html