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

Home -> Community -> Usenet -> c.d.o.server -> Re: to find execution time..

Re: to find execution time..

From: sam <sameer.ocp_at_gmail.com>
Date: 28 Mar 2005 04:47:22 -0800
Message-ID: <1112014042.417756.276250@f14g2000cwb.googlegroups.com> 





Hi



U can do that after connecting as a user and write
set timing on



and after executing the query the time for execution of query will be
there but after connecting set nls_date_format='yyyy-mm-dd 24hh:mi:ss'
othrwise u will not be able to see the time;



sam





rasukutty wrote:


> Hi

>

> ·     in oracle     Can I find the time taken to execute a query? If

so,


> how?please help me in this regard

Received on Mon Mar 28 2005 - 06:47:22 CST












Original text of this message













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