Home » SQL & PL/SQL » SQL & PL/SQL » find elapsed time?
find elapsed time? [message #324187] Sat, 31 May 2008 05:50 Go to next message
nagaa
Messages: 33
Registered: August 2007
Location: chennai
Member
I want to find how long it will take to insert the records or execute the procedure after running?
Can u pls anyone tell me the command for that

ex: i want to display like this...

SQL> insert /*+ append */ into sample3
2 select * from table (sample3_tab_fnc(CURSOR(select * from SAMPLE3_EXT)))
3 /
31233 rows created.
Elapsed: 00:00:00.96

Re: find elapsed time? [message #324192 is a reply to message #324187] Sat, 31 May 2008 07:25 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member

Is this what you are looking for?

SQL> set timing on
SQL> select * from employee;

      E_NO FIRSTNAME            LASTNAME             DEPARTMENT_ID
---------- -------------------- -------------------- -------------
       111 Rajmoham             Rao                              1
       112 Suhrad               Suvarna                          2
       113 Manan                Panchal                          3
       114 Duragdas             Menon                            4
       115 Dennis               D"souza                          1

Elapsed: 00:00:00.06
Previous Topic: i need pl/sql code
Next Topic: select index count on a different schema
Goto Forum:
  


Current Time: Thu Dec 08 12:06:50 CST 2016

Total time taken to generate the page: 0.14762 seconds