| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Lag Time Between Log File Switch and Archive Log File
Steve,
Thanks very much for your thoughts. I suspected it was an I/O problem as well but the problem is recently due to a very large data migration project that is happening. The storage system is an EMC with dedicated drives for REDO and ARCHIVE logs. I will check the waits closer.
Thanks again.
Steve Howard wrote:
> dhoffman0917_at_yahoo.com wrote:
> > Colleagues:
> >
> > Has anyone experienced lag times after an automatic log switch happens
> > and the time the archive log file appears in the archive log directory?
> > I am running Oracle9i (9.2) on Solaris/UNIX.
> >
> > For additional information, below are SQL results of time differences
> > between when the log switch happened and when the archive log file was
> > written to disk.
> >
> > I welcome all ideas at your earliest convenience on this and thanks in
> > advance.
> >
> > Donna
> >
> >
> >
> > BYTES NEXT_TIME COMPLETION_TIME LAG
> > ---------------- -------------------- -------------------- ----------
> > 1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54 77
> > 1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27 35
> > 1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06 20
> > 1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40 18
> > 1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12 6
> > 1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28 2
> > 1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04 58
> > 1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50 44
> > 1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19 30
> > 1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01 26
> > 1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33 4
> > 1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41 244
> > 347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54 183
> > 2,733,056 JUN-13-2006 05:44:28 JUN-13-2006 07:47:54 123
> > 2,704,896 JUN-13-2006 06:44:28 JUN-13-2006 07:47:54 63
> > 45,496,832 JUN-13-2006 07:44:30 JUN-13-2006 07:47:55 3
> > 6,064,640 JUN-13-2006 08:44:35 JUN-13-2006 11:34:38 170
> > 3,440,128 JUN-13-2006 09:44:33 JUN-13-2006 11:34:38 110
> > 7,715,840 JUN-13-2006 10:44:34 JUN-13-2006 11:34:38 50
> > 2,077,696 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38 1
> > 512 JUN-13-2006 11:32:58 JUN-13-2006 11:34:38 1
> > 88,776,192 JUN-13-2006 12:32:58 JUN-13-2006 13:39:56 66
> > 25,733,632 JUN-13-2006 13:32:58 JUN-13-2006 13:39:57 6
> > 687,235,584 JUN-13-2006 14:32:58 JUN-13-2006 16:41:49 128
> > 10,010,112 JUN-13-2006 15:32:58 JUN-13-2006 16:41:05 68
> > 1,048,574,976 JUN-13-2006 16:30:14 JUN-13-2006 16:42:46 12
> > 1,048,572,416 JUN-13-2006 16:33:58 JUN-13-2006 16:42:59 9
> > 1,048,572,928 JUN-13-2006 16:37:33 JUN-13-2006 16:43:59 6
> > 1,048,574,976 JUN-13-2006 16:41:21 JUN-13-2006 16:44:15 2
> > 1,048,572,416 JUN-13-2006 16:46:43 JUN-13-2006 17:07:35 20
> > 1,048,574,464 JUN-13-2006 16:50:30 JUN-13-2006 17:07:32 17
> > 1,048,574,464 JUN-13-2006 16:54:28 JUN-13-2006 17:09:16 14
> > 1,048,574,976 JUN-13-2006 16:58:48 JUN-13-2006 17:08:53 10
> > 1,048,573,440 JUN-13-2006 17:03:01 JUN-13-2006 17:10:07 7
> > 1,048,574,976 JUN-13-2006 17:07:40 JUN-13-2006 17:10:16 2
>
>
 |
 |