The SET TIMING statement enables a single line report of used CPU
    and Elapsed time for each successful SQL statement or command.

    SQL> start transaction;
    SQL> set timing on;
    SQL> select count(*)
    cont> from employees
    cont>      inner join job_history using (employee_id)
    cont>      inner join salary_history using (employee_id)
    cont>      inner join departments using (department_code)
    cont>      inner join jobs using (job_code)
    cont>      left outer join resumes using (employee_id)
    cont>      left outer join degrees using (employee_id)
    cont>      left outer join colleges using (college_code)
    cont>
    cont> ;

            3871
    1 row selected
    Timing: Elapsed:    0 00:00:00.82 Cpu:    0 00:00:00.16
    SQL> set timing off;
    SQL> commit;