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 -> find sql query last time

find sql query last time

From: Steve Robin <ocmaman_at_gmail.com>
Date: 16 May 2007 22:22:01 -0700
Message-ID: <1179379321.020738.7790@e65g2000hsc.googlegroups.com> 





Hi All,



Oracle keeps so many things internally and also view them through x$
tables and v$ tables and many other internal tables. Is there any way
to find when was the query executed last time and what was the time
taken by it. When I have not done any tracing or any thing like that.
Simple execute a query many times.



Or



Any way to find when was last time cursor was closed.
Received on Thu May 17 2007 - 00:22:01 CDT












Original text of this message













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