This final chapter was meant to condense a lot of information into an easy-to-understand format, prioritizing the different elements along the way. This chapter will only get you started on the quest for the ever-elusive tuned database. It doesn't contain everything because the topic is vast and has to be customized to fit your environment—a unique mix of operating systems, application software, Oracle versions, and personnel expertise. A few tips were included for where to look when something else may be wrong; it isn't always the database (or the DBA) that is to blame.
This chapter was meant to get you started learning about how to set events, wading through trace output, collecting statistics, and analyzing explain plans with the different tools and utilities from Oracle. SQL Plan Management is a new feature intended to help with tuning issues both during an Oracle upgrade and afterwards.
Most of the research for this book came from the official Oracle documentation and My Oracle...