Home » SQL & PL/SQL » SQL & PL/SQL » Get the running time
Get the running time [message #291226] Thu, 03 January 2008 07:49 Go to next message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
Hi,

I am running some procedures and I want to know the running time.
I used set timing on and got it.
But I want to make it automatic.
The ran time should go to a table.

Please advice.
Re: Get the running time [message #291227 is a reply to message #291226] Thu, 03 January 2008 08:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Re: Get the running time [message #291230 is a reply to message #291226] Thu, 03 January 2008 08:03 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at DBMS_PROFILER
Maybe it wil help you.

Regards
Michel
Previous Topic: update
Next Topic: Sequence
Goto Forum:
  


Current Time: Mon Dec 05 14:58:46 CST 2016

Total time taken to generate the page: 0.15706 seconds