How to know the when the query was executed? [message #623421] |
Wed, 10 September 2014 04:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e1f4681bfcf7f98d1bc48eac70096827?s=64&d=mm&r=g) |
haadiya
Messages: 10 Registered: September 2014
|
Junior Member |
|
|
1)How to find when a query was executed.I ran a query couple of days ago,im not sure about the exact time, I want to know at what date and time the query was executed. Is it possible to get that information ?
2)How to check the server status when a query is running?
|
|
|
|
|
|
|
|
|
|
Re: How to know the when the query was executed? [message #623573 is a reply to message #623466] |
Thu, 11 September 2014 09:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Just to add some clarification to gazzag's above suggestion :
The v$sql would give the information only till a certain timeline until it exists in the shared_pool. As far as I have experienced, people usually look for first load time in v$sql. Therefore, I would go with Michel's suggestion.
|
|
|
|
|
Re: How to know the when the query was executed? [message #623592 is a reply to message #623580] |
Thu, 11 September 2014 12:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
But your sentence "The v$sql would give the information only till a certain timeline until it exists in the shared_pool." is wrong regarding the question "How to know the when the query was executed?". The rest of your post is irrelevant to the question.
In addition, "loaded" does not mean "executed".
And about "Just to add some clarification to gazzag's above suggestion", I just think gazzag "thought" is answered the question and his answer is also wrong.
|
|
|