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.

Hi Brucken,
You should read up on the use of tkprof. There is a master index to the Oracle
documentation that should help you get under way.

Regards,

Ruud.
--
--------------------------------------------------------------------------------------
Ruud de Koter HP OpenView Software Business Unit
Senior Software Engineer IT Service Management Operation
Telephone: +31 (20) 514 15 89 Van Diemenstraat 200
Telefax : +31 (20) 514 15 90 PO Box 831
Telnet : 547 - 1589 1000 AV Amsterdam, the Netherlands
Email : ruud_dekoter (AT) hp (DOT) com

internet: http://www.openview.hp.com/products/servicedesk
intranet: http://ovweb.bbn.hp.com/itservicemanager
--------------------------------------------------------------------------------------

Hi,

One simple way is to set timing on sql plus.

i.e

sql>set timing on;

execute your query. oracle will display elapsed time taken by
the query.



thanks and regards,

Parag


--
parag


Posted via http://dbforums.com