Re: Time of search in data base

From: Lakshmi Jagarlapudi <jlnarayana_at_comcast.net>
Date: Thu, 06 Nov 2003 01:59:24 GMT
Message-ID: <0Whqb.85707$275.251707@attbi_s53>

Probably more accurate way is to trace it and know the cpu and elapsed time statistics.

good luck,
lakshmi narayana

"Brucken" <yaobrucken_at_yahoo.fr> wrote in message news:59a217eb.0311050823.59305aac_at_posting.google.com...
> Hi!!!!
> I created a data base under oracle9i and I want to measure the search
> time in this data base. Let us suppose that I have this request to
> carry out:
>
> select * from usager where name = 'John' and age = 45;
>
> I want to know time that oracle puts to make this search in the data
> base. What's the script enabling me to determine this search time?
>
> Thanks.
Received on Wed Nov 05 2003 - 19:59:24 CST