CREATE OR REPLACE PACKAGE Test is

  procedure Quick;

end Test;

CREATE OR REPLACE PACKAGE BODY Test as

  procedure Quick (Parameter1 in  varchar2,
                   Response   out varchar2) is

    begin

      Insert into a table that takes longer than 3 minutes.  Something that takes a long time to process.

      Response := 'Your report is running.';

    end;

end Test;

orclz>
orclz> create or replace procedure slow_proc as begin
  2  dbms_lock.sleep(60);
  3  end;
  4  /

Procedure created.

orclz> exec dbms_scheduler.create_job(job_name=>'run_now',-
> job_type=>'stored_procedure',-
> job_action=>'slow_proc',-
> enabled=>true)

PL/SQL procedure successfully completed.

orclz> select JOB_NAME,ELAPSED_TIME from user_scheduler_running_job
  2  ;
select JOB_NAME,ELAPSED_TIME from user_scheduler_running_job
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist


orclz> select JOB_NAME,ELAPSED_TIME from user_scheduler_running_jobs;

JOB_NAME
----------------------------------------------------------------------------
ELAPSED_TIME
---------------------------------------------------------------------------
RUN_NOW
+000 00:00:23.24


orclz> select JOB_NAME,ELAPSED_TIME from user_scheduler_running_jobs;

JOB_NAME
----------------------------------------------------------------------------
ELAPSED_TIME
---------------------------------------------------------------------------
RUN_NOW
+000 00:00:35.81


orclz>