Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> why do redo logs stay 'ACTIVE' for so long?
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHAN FIRST_TIME
1 1 7051 20971520 1 NO ACTIVE 72156077 02/23/00 16:14:30
2 1 7052 20971520 1 NO ACTIVE 72156121 02/23/00 16:15:13
3 1 7050 20971520 1 NO ACTIVE 72156029 02/23/00 16:14:00
4 1 7053 20971520 1 NO ACTIVE 72156124 02/23/00 16:15:44
5 1 7049 20971520 1 NO ACTIVE 72155928 02/23/00 16:13:28
6 1 7054 20971520 1 NO ACTIVE 72156126 02/23/00 16:16:15
7 1 7055 20971520 1 NO ACTIVE 72157473 02/23/00 16:19:00
8 1 7056 20971520 1 NO CURRENT 72158806 02/23/00 16:19:48
9 1 7047 20971520 1 NO INACTIVE 72155765 02/23/00 16:06:07
10 1 7048 20971520 1 NO ACTIVE 72155926 02/23/00 16:06:53
Each of them is about 20 Megs, and I see no disk contention.
As soon as I turn off TIMED_STATISTICS they all become INACTIVE (weel, except for one)
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Wed Feb 23 2000 - 16:32:22 CST