Re: find sql query last time

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

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

Maybe v$sql[area].LAST_ACTIVE_TIME for the first part. Nowhere, afaik, for the execution time.

Regards
Michel Cadot Received on Thu May 17 2007 - 01:32:46 CDT