Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Lag Time Between Log File Switch and Archive Log File
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 2Received on Tue Jun 13 2006 - 22:20:48 CDT