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: peter <hhh.database_at_gmail.com>
Date: 17 May 2007 04:16:29 -0700
Message-ID: <1179400589.711159.109820@h2g2000hsg.googlegroups.com>


Is there any way to find when was the last time 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 - 06:16:29 CDT

Original text of this message

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