Re: find last time sql executed

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 17 May 2007 08:38:18 +0200
Message-ID: <464bf85a$0$9523$426a74cc@news.free.fr>

"Steve Robin" <ocmaman_at_gmail.com> a écrit dans le message de news: 1179382574.894013.313430_at_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
|

Log Miner.
Flashback version query

Regards
Michel Cadot Received on Thu May 17 2007 - 01:38:18 CDT