performance measurment of an oracle db

hello ng,
I want to measure the performance of an oracle db 8i or 9i. it is only about to see the actual performance. I think about a sql-select-statement which makes an complex select on standard databases. then i want to measure the time it needs to be performed. I will perform this statement once when there is no activity on the db at all to get a reference time. this time can then always be taken as reference value, so when I compare these two values i know the load on the db.
which tables are useful for this purpose?

set timing on

    select * from ????? where ???? like ??? set timing off

max Received on Mon Oct 07 2002 - 03:18:27 CDT