how can I find out how long a query runs

[gbrabham]

select to_char(sysdate,'dd-mon-yy hh24:mi:ss') from dual;
sqlstatement;
select to_char(sysdate,'dd-mon-yy hh24:mi:ss') from dual;

look at difference or ...

dbms_utility.get_time();

HTH
Gregg