1) A login step with takes 10 seconds
2) A reporting step that takes 10 hours

1) break your procedure into parts.  This can be pretty much anything you want, 
but use some common sense.  For example, each SQL statement inside your process could 
each be one part.  Break it up in whatever way makes sense to you.

2) get runtime stats for each part.  This can be as simple as monitoring the "WALL CLOCK" 
for each step.  How many eplapsed seconds does each part take.

begin
dbms_output.put_line(to_char(sysdate,'dd-mon-rrrr hh24:mi:ss'));
   do_sql1;
dbms_output.put_line(to_char(sysdate,'dd-mon-rrrr hh24:mi:ss'));
   do_sql2;
dbms_output.put_line(to_char(sysdate,'dd-mon-rrrr hh24:mi:ss'));
   do_sql3;
dbms_output.put_line(to_char(sysdate,'dd-mon-rrrr hh24:mi:ss'));
end;
/