Re: performance measurment of an oracle db

"M. Gedecke" <spam_at_gedecke.de> wrote in message news:<anrg58$vg0$1_at_redenix.uni-muenster.de>...
> 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

Max,

I have some whitepapers and monographs at www.robonerd.com in the Downloads discussion area and in the catalog. I suggest you read the tuning manual and then maybe look at these papers/monographs. Also, TUSC has many whitepapers at their site, www.tusc.com which also discuss the many facets of tuning. What you are asking has been attempted before, most recently with the Savant (now part of Precise SQL) Q product. Unfortunately there is no one select that will tell you if the database is functioning at peak performance levels.

Mike Ault Received on Wed Oct 16 2002 - 08:36:35 CDT