Re: Lag Time Between Log File Switch and Archive Log File

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
Hi Donna,

That may extraordinarily slow I/O, would be my guess. On what kind of devices are the archived redo logs stored? Trace the archiver process to what waits it is experiencing and post back.

Regards,

Steve Received on Wed Jun 14 2006 - 10:34:07 CDT