1) have a DBMS_OUTPUT with SYSDATE before and after the query.

2) If u can't see the OUTPUT. Have a dummy_process_table where you insert the start and end time