Re: Time of search in data base
From: Smiley <anoniemke888noway_at_hotmail.com>
Date: Wed, 5 Nov 2003 20:10:31 +0100
Message-ID: <bobhvo$5hu$1_at_news.hccnet.nl>
Date: Wed, 5 Nov 2003 20:10:31 +0100
Message-ID: <bobhvo$5hu$1_at_news.hccnet.nl>
"Brucken" <yaobrucken_at_yahoo.fr> wrote in message
news:59a217eb.0311050823.6bc8f128_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.
You can use the command 'Set timing on' in SQL*Plus
Ron Received on Wed Nov 05 2003 - 20:10:31 CET