Database Upgrade Tips
In my last blog, I discussed the various testing strategies we implemented at Giant Eagle to make sure we had a trouble-free migration to Oracle’s latest and greatest release. In this blog, I’ll discuss some general techniques you can use to make any database upgrade easier and less error-prone.
In upcoming blogs, I’ll cover how we have configured 10G Enterprise Manager to monitor and administer our 10G test and production databases. In addition, I’ll also describe how we use the tool to perform performance monitoring and tuning. Performance monitoring and tuning using 10G EM is so drastically different than 9I OEM, that it is definitely worthwhile for me to spend some time telling you how we use it. With SQL joining billion row tables on a regular basis, we quickly become experts on all new tools we use here.