Re: Time of search in data base

From: nobody <nobody_at_nowhere.com>
Date: Wed, 05 Nov 2003 16:30:34 GMT
Message-ID: <KA9qb.29559$152.21900@news01.bloor.is.net.cable.rogers.com>

in sqlpus

set timing on
select * from usager where name = 'John' and age = 45;

r
"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 - 10:30:34 CST