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 last time sql executed

find last time sql executed

From: Steve Robin <ocmaman_at_gmail.com>
Date: 16 May 2007 23:16:14 -0700
Message-ID: <1179382574.894013.313430@y80g2000hsf.googlegroups.com> 





Is there any way to find was the sql executed and what was the time
taken by it.


When tracing or auditing is not on.


Actually problem is one of developer is executed delete query on a
table, now I want to when was that query executed last time. Because
same query with different literal was executed by other developer
before it. As well as what was the time taken by that delete query.



ORACLE : 9.2.0.3



Platform  : Any Platform
Received on Thu May 17 2007 - 01:16:14 CDT












Original text of this message













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