Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql logging problem
In article <01bc4740$c2465700$3d846380_at_MAURIT>, Mark Aurit
<maurit_at_world.northgrum.com> writes
>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;
-----------------------------------^^The format mask MM is for the month. To get minutes you should use MI.
-- Jim SmithReceived on Sun Apr 13 1997 - 00:00:00 CDT