Home » SQL & PL/SQL » SQL & PL/SQL » Query to know the last 5 querys laucnhed (merged)
Query to know the last 5 querys laucnhed (merged) [message #388591] Wed, 25 February 2009 09:45 Go to next message
guif
Messages: 17
Registered: November 2008
Junior Member
hi!
whith this query i can know what's the last query launched:

select sql_text from v$sql
where first_load_time=(select max(first_load_time) from v$sql);


Is it possible to see the last 5 querys?

Re: Query to know the last 5 querys laucnhed [message #388595 is a reply to message #388591] Wed, 25 February 2009 09:58 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>Is it possible to see the last 5 querys?
Yes. This is a FAQ so SEARCH for solution.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.
Re: Query to know the last 5 querys laucnhed (merged) [message #388600 is a reply to message #388591] Wed, 25 February 2009 10:49 Go to previous message
guif
Messages: 17
Registered: November 2008
Junior Member
what's the problem? I don't know...
Previous Topic: index & constraint
Next Topic: Get_Hash_Value_collisions (merged)
Goto Forum:
  


Current Time: Sat Dec 03 20:28:06 CST 2016

Total time taken to generate the page: 0.11418 seconds