I am thinking to develop a monitoing and dignosing tool,I need tips/inputs from you all to have it in a better way and very relaiable one.My requirments are very simple.I need to clock database activities for a day of 8 hours.I need to monitor those process which hogs cpu at unix level and drill down those process to database to identify the sid,serial#,program,process,module name.This needs to be stored either in a table or in a file.

Later i want to generate a graphical interface by using this statistics like those modules consumed high cpu in a day and how much cpu used at that time.

Any suggestions other than to use statspack.