OraFAQ Forum: SQL & PL/SQL » execution time

Home » SQL & PL/SQL » SQL & PL/SQL » execution time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

execution time [message #628042]

Wed, 19 November 2014 08:50

nisjess
Messages: 4
Registered: November 2014

Junior Member

Hi I m a newbie..
Can anybody tell how to record the execution time for every query in a SQL Script through a select statement?
Thanks

Report message to a moderator

Re: execution time [message #628043 is a reply to message #628042]

Wed, 19 November 2014 08:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

ALTER SESSION SET SQL_TRACE=TRUE;

Report message to a moderator

execution time [message #628044 is a reply to message #628042]

Wed, 19 November 2014 08:54

nisjess
Messages: 4
Registered: November 2014

Junior Member

Hi I m a newbie..
Can anybody tell how to record the execution time for every query in a SQL Script through a select statement?
Thanks

Report message to a moderator

Re: execution time [message #628046 is a reply to message #628044]

Wed, 19 November 2014 09:10

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

What's the point in repeating yourself? Did you consider reading Blackswan's suggestion?

For single query you could do "set time on timing on" in SQL*Plus. In PL/SQL, you could nuse dbms_utility.get_time for each operation. And use dbms_output to display the time elapsed.

Another way is to query v$sql to get elapsed_time for the individual SQLs.

Report message to a moderator