sql logging problem

I have some sql (see below) that takes around 20 minutes to execute. To get some timings, I attempt to create a log (see bottom) what shows the start and stop time. However, it consistently says that only a short amount of time has been spent, even though, as I said, at least 20 minutes have bypassed. ??????
Thanks, Mark
mark_aurit_at_mail.northgrum.com

• scheduled sql ********************** spool e:\lvs_app\log\s_lcoatp.lst

select substr(to_char(sysdate,'DD-MM-YY'),1,10) run_date from dual; select substr(to_char(sysdate,'HH:MM:SS'),1,10) start_time from dual;

• sql script that takes 20 minutes to process commit;

select substr(to_char(sysdate,'HH:MM:SS'),1,10) end_time from dual;

spool close
exit

• LOG FILE ************* Nothing in SQL buffer to run. Nothing in SQL buffer to run.

RUN_DATE                                                                   
                        


----------                                                                 

                        
10-04-97                                                                   
                        


START_TIME                                                                 
                        


----------                                                                 

                        
07:04:20                                                                   
                        

92824 rows created.

Commit complete.

END_TIME                                                                   
                        


----------                                                                 

                        
07:04:56