Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: Time of search in data base



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



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.