Monday, January 21, 2008

Timing SQL Plus query

To time a query in Oracle SQL Plus do the following.
SET TIMING ON
select * from mytable
.... Results here....
Elapsed: 00:00:00.15

No comments: