Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: find sql query last time
"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
![]() |
![]() |