Compare time taken by sqls

Advertisement
Hi experts,
Can any one refer me any tool or utility by which i can get time taken by different sql's without using explain plan..
Regards,
SKP
Advertisement

Replay

If you are running it from SQL*Plus, just set timing on
SQL> set timing on
SQL> select empno,ename from emp where deptno=10;
EMPNO ENAME
7782 CLARK
7839 KING
7934 MILLER
Elapsed: 00:00:01.97
SQL> select empno,ename from emp where deptno=20;
EMPNO ENAME
7369 SMITH
7566 JONES
7788 SCOTT
7876 ADAMS
7902 FORD
Elapsed: 00:00:01.91
SQL>