Time of search in data base

[Brucken]

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.

[Smiley]

"Brucken" <yaobrucken@yahoo.fr> wrote in message
news:59a217eb.0311050823.6bc8f128@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.

You can use the command 'Set timing on' in SQL*Plus

Ron