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: Dave <x_at_x.com>
Date: Mon, 28 Mar 2005 12:56:43 GMT
Message-ID: <faT1e.7012$Ab.3190@text.news.blueyonder.co.uk> 






"sam" <sameer.ocp_at_gmail.com> wrote in message 
news:1112014042.417756.276250_at_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;




dont need the alter session
Received on Mon Mar 28 2005 - 06:56:43 CST












Original text of this message













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