I am writing an Oracle performance tracking utility -- oramon. And I have finished the first version of it, to make it more powerful, I compiled a windows version binary for free download. What this utility do is query some data from Oracle performance views periodically and write them out to some OS files. Then we can analyze the Oracle performance problem with the data stored in these files.
As we cannot keep eye on the database server for whole a day, we should have a tool to track some data for later analyze. The another reason is that when you login to the database after get a performance complain, every seems fine, because the load spike time may be very short. As a DBA, this is not a reason that you cannot get it resolved.
Now you can try it, if you get a performance problem, just send the generated files to me, and tell me the time (no exact time required) you get bad performance, I can do some analyze remotely without accessing your database server. To use it, create an oracle user with select_catalog_role role granted.
For remote database, run the following command.
oramon -u username/password@tnsname [-v version]
For local database, run the following command.
oramon [-v version]
For Oracle 8i or 9i, specify "-v 9", "-v 10" for Oracle 10g. I promise you will be interested with this utility.