Regardless of which tools you use, you will need interactive and historically focused tools. Each has a distinct focus, and most vendor-supplied tools naturally fall into one of these categories.

Interactive tools operate in real time. When you log in to Oracle using SQL*Plus and run a script, you are being interactive. Interactive tools have the distinct advantage of going technically very deep. All the data is available because the activity is happening now. Hyper-focused interactive tools usually have dazzlingly graphics. However, be aware that interactive tools do have limitations. During a firefight, there is usually a lot of chaos, and while you are focusing on one problem, another problem is occurring. If you are limited to interactive tools, you could miss a key investigative opportunity.

Historically focused tools periodically collect data and then allow you to "look back in time," as they say. Examples of historical tools are Statspack and AWR. Historical tools are wonderful for analyzing a problem after it happened (like while you slept last night), when multiple problems need to be analyzed, or if you need to reference a past situation (this occurs more often than people think). Historical tools usually provide trending and graphing capabilities, which are especially helpful in communicating with nontechnical people.