Apr 10, 2001 #1 Ezequiel Programmer Joined Apr 4, 2001 Messages 30 Location CA Is there a way to retrieve the time spent on a query, when I execute it in the SQLPlus? Thanks in advance. --- Ezequiel Glinsky eze@bumeran.com Buenos Aires, Argentina
Is there a way to retrieve the time spent on a query, when I execute it in the SQLPlus? Thanks in advance. --- Ezequiel Glinsky eze@bumeran.com Buenos Aires, Argentina
Apr 10, 2001 1 #2 carp MIS Joined Sep 16, 1999 Messages 2,622 Location US Try this: SET TIMING ON Now your time will be displayed at the conclusion of each query. Upvote 0 Downvote