Re: performance measurment of an oracle db

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 7 Oct 2002 12:22:30 +0100
Message-ID: <X7eo9.19951$zX3.53673@news.indigo.ie>

Danger.
Sharp learning curve ahead.

try autotrace on exp stat in SQL*Plus, and there's a little tool called tkprof.

"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
>
>
Received on Mon Oct 07 2002 - 06:22:30 CDT