"nobody" <nobody_at_nowhere.com> wrote in message
news:KA9qb.29559$152.21900_at_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.
>
>
In addition not using bind variables and other optimization techniques will
give you a slower time than using such techniques.
Jim
Received on Wed Nov 05 2003 - 19:11:41 CST
