DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL Statement

  1. #1

    Question

    How could I know the duration a single SQL statement takes.
    Is there any column in V$SQLAREA shows the time?
    Queyon Zeng

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Hi
    Use package DMS_UTILITY.get_time()
    start := DMS_UTILITY.get_time();
    select .....
    stop := DMS_UTILITY.get_time();


    Originally posted by Queyon
    How could I know the duration a single SQL statement takes.
    Is there any column in V$SQLAREA shows the time?

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    in 8.1.6 >

    use v$session_longops

  4. #4
    Join Date
    Feb 2001
    Posts
    184
    You can have a Timing on That gives yo the Time in Miliseconds.


    SQL> Set Timing on
    Select Count(*) From Emp;

    Real: 145
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width