Home » SQL & PL/SQL » SQL & PL/SQL » Last run SQL Execution Time.
Last run SQL Execution Time. [message #216585] Mon, 29 January 2007 09:50 Go to next message
pkirangi
Messages: 74
Registered: August 2005
Member
Hello All,
Is there a DBMS Package which gives me the execution time of the last run sql in the session?

Thanks
Re: Last run SQL Execution Time. [message #216789 is a reply to message #216585] Tue, 30 January 2007 07:12 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
There are all sorts of profiling and tracing mechanisms you can use. And means to capture the times yourself, such as with the sqlplus set timing and the dbms_utility time functions.

But you have to "do something" in all of those cases. If you haven't done anything to set any instrumentation up, you can potentially check v$session_longops.
Re: Last run SQL Execution Time. [message #217135 is a reply to message #216789] Wed, 31 January 2007 16:12 Go to previous message
pkirangi
Messages: 74
Registered: August 2005
Member
Thanks Smartin,
I am using v$sql, v$session to get the execution times.
V$sql has the sql execution times.
Previous Topic: Database Time in Oracle 9i
Next Topic: Calculating intervals in Milliseconds
Goto Forum:
  


Current Time: Mon Dec 05 09:16:01 CST 2016

Total time taken to generate the page: 0.04733 seconds