In this book, we have covered various themes such as transactions, locking, blocking, redo, and undo. As we went along, we touched on basic troubleshooting techniques related to these subjects. In this chapter, we dive deeper into diagnosing issues related to these topics. Specifically, we’ll look at the following:
Detecting unindexed foreign key columns
Displaying blocking sessions
Killing sessions
Reporting top consumers of undo and redo
Inspecting log switching and redo generation
Having said that, the goal of this chapter is ...
