Some DBAs set some alert value for Oracle performance tracking, but that's not enough. For database (not only Oracle) performance, we need gather the performance data, display and analyze the data. DBAs are the critical resource for database performance, any tools is just a tool. However without good tool, DBAs will be lost in performance tuning.
I am rewriteing the oramon utiltiy, a self developed Oracle performance tracking utility. In the last few days, I write a data collect program for oramon output files. With WebChart utility, we can display the performance data effectively. It's a light way Oracle performance tracking solution, and I am enjoy with it.
The oramon utility will write two copies of data, first copy is fixed length text file, another copy is CSV for the data collect program (I named it as scanomon) to load the data into performance database in time. And then I display them in web pages (For example, the load average and active session of the critical databases). Then we can control the database performance well.
The oramon utility print the key performance data of Oracle database, it plays a very important role in my DBA career, helps me identify the problems in time, and get them resolved without affect the database availability.