Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Lag Time Between Log File Switch and Archive Log File

Lag Time Between Log File Switch and Archive Log File

From: <dhoffman0917_at_yahoo.com>
Date: 13 Jun 2006 20:20:48 -0700
Message-ID: <1150255248.236264.179250@p79g2000cwp.googlegroups.com>


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
Received on Tue Jun 13 2006 - 22:20:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US