I will recommend other tools beside the ones above later in this presentation. The above tools were chosen as the minimal set to easily tune a system.
The first The scripts "bstat/estat" has been around since v6 and is easy to use and dependible. There is a new similiar tool, "stats pack" that is much more powerful but available only in v8.1.6, thus the more limited discussion. Oracle also has of course OEM which again is limited to certain versions, but I refrain from discussing it at all because I think it is a badly written behemoth of a beast.
The next script sqldmp.sh is pretty necessary in order to read v$sqlarea with any ease. Oracle doesn't provide any scripts that I know if to facitilate this. What sqldmp.sh does is pretty simple, it just dumps the sqlarea to a flat file and sorts the statments by buffer hits and disk hits and buffer hits per execute. This is the simple information that is needed
Collecting data is complicated by: