Hi everybody!
We have started a procedure for performance tuning of our Oracle 8i database. In order to identify potential bottlenecks we are generating virtual user load using Rational Robot -- one time through SQL8 and second time through the application which is accessing the database. What I miss is a benchmarking test plan....For example -- how many times a day should we load the database with virtual users, how to extract the valuable statistic data from the results etc.The idea is to build a performance baseline which should used later as regression test when a performance tuning improvements are done..if anyone has done such kind of database load testing please share the experience...

Best Regards