Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Time of search in data base

Time of search in data base

From: Brucken <yaobrucken_at_yahoo.fr>
Date: 5 Nov 2003 08:23:53 -0800
Message-ID: <59a217eb.0311050823.59305aac@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:23:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US