How to get Oracle SQL query elapsed time

How to get a Oracle SQL query elapsed time

SQL> sho user
USER is "SCOTT"
SQL> set timing on
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ------
 7369 SMITH CLERK 7902 17/12/80 800 20
 7499 ALLEN SALESMAN 7698 20/02/81 1600 300 30
 7521 WARD SALESMAN 7698 22/02/81 1250 500 30
 7566 JONES MANAGER 7839 02/04/81 2975 20
 7654 MARTIN SALESMAN 7698 28/09/81 1250 1400 30
 7698 BLAKE MANAGER 7839 01/05/81 2850 30
 7782 CLARK MANAGER 7839 09/06/81 2450 10
 7788 SCOTT ANALYST 7566 19/04/87 3000 20
 7839 KING PRESIDENT 17/11/81 5000 10
 7844 TURNER SALESMAN 7698 08/09/81 1500 0 30
 7876 ADAMS CLERK 7788 23/05/87 1100 20
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- -----
 7900 JAMES CLERK 7698 03/12/81 950 30
 7902 FORD ANALYST 7566 03/12/81 3000 20
 7934 MILLER CLERK 7782 23/01/82 1300 10
14 rows selected.
Elapsed: 00:00:00.01
SQL>
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in scripts. Bookmark the permalink.

6 Responses to How to get Oracle SQL query elapsed time

  1. Melodee says:

    I love reading an article that can make men and
    women think. Also, thanks for permitting me to comment!

  2. Jannette says:

    Hello there, I discovered your web site via Google while searching for a related
    subject, your website got here up, it appears to be like good.
    I’ve bookmarked it in my google bookmarks.
    Hi there, simply become alert to your weblog via Google, and
    found that it is truly informative. I am going to watch out for
    brussels. I’ll be grateful if you happen to proceed this in future.
    A lot of other people might be benefited from your writing.

    Cheers!

  3. Liliana says:

    I’m gone to convey my little brother, that he should also pay a visit
    this web site on regular basis to get updated from newest news.

  4. unicef books says:

    I will immediately take hold of your rss ass I can’t finmd your
    email subscription hyperlink or e-newsletter service.

    Do youu have any? Please let me realize so that I could subscribe.

    Thanks.

  5. bbandt says:

    Hi I am so glad I found your webpage, I really found you by error, while I was searching on Bing for something else, Regardless I am
    here now and would just like to say many thanks
    for a fantastic post and a all round interesting blog (I also
    love the theme/design), I don’t have time to read it all at
    the moment but I have book-marked it and also added your RSS feeds, so when
    I have time I will be back to read much more,
    Please do keep up the excellent work.

  6. Sher khan says:

    Thanks for your inputs. I feel happy if people are using my sites and that’s why your comments make me to write more.
    Best Regards,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s